Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Changing Display Patterns dependent on other fields

Avatar

30-01-2009

Hello,



Is it possible to change the display format of one field depending on what is selected/entered in another field?



I.e. we offer two types of discounts, a percentage and a monetary. One requires the zz.zzz% and the other a $zzz.zz format. The display pattern will depend on another field which the user indicates which form of discount is being applied. I would like to combine this all into one field. Is this possible?



I've tried the Format() function, but am having trouble with it.



Thank you for your help.



-Robinson