I'm trying to get a special format for a field if it is a number or if it is text.
I have a field where I can enter either a value 13,49.-€ or text for info.
Is there a way that FM takes care of the format in the following way:
if 14,59.-€ entered, that the text is aligned on the right
if Bank entered, that the text is align on the left?
thank you in advance