This is driving me nuts. I’ve achieved it in the past. Say I put an image into Section Pro and fix the background. Then another Pro undeath with a coloured png file with transparent text. Like this
It has been so long since I used PS that I can’t even be certain about this, but as far as I recall, PS doesn’t have that function. You would need a vector app such as Illustrator, Designer, Graphic App, etc…
I just fired up Designer and it works or me. What I did was I created a large red square, added a character as text, converted to curves, selected all and did a Subtract, and that worked.
I don’t know if thishelps:
When a font character is converted to outlines, it creates a compound path if there’s two paths in the letter. For example, P, R, O, Q etc.
A compound path is treated as one object which is why the whole character gets deleted. I don’t use Affinity but in AI you can convert compound paths to ordinary paths.