Whenever I paste data into my Filemaker database using command-v (we use Macs), it shows up with the original formatting and not the formatting of the field. I'm attaching an example using my name.

If I do command-z it wipes out the formatting and shows the formatting on the layout as in the second image. 

Is there a way to force the data to just use the field formatting and ignore whatever the original formatting was without having to do command-option-shift v (Paste Text Only) or command-z? I'm pretty careful about this but I'm afraid that as more people use the solution the formatting will be all over the place.

Thanks in advance.

You can use a custom menu to make Paste Text Only the default action.

Another option is to remove formatting using an auto-entered calculation - but this could make it difficult to apply formatting when you do want it.

 

OK. Looks like there's no way to force it. Thanks.

Not sure what you mean by "force it". If you strip the formatting at entry/modification, then users have no way to enter formatted text into the field, even if they want to. Similarly, if you don't give them access to the Paste command, they won't be able to paste formatted text. What more would you want?

Edited April 16, 2025Apr 16 by comment