Format Rules for Form Rules

[Daisy_Ramirez]

I’m looking to add some interest to my data entry forms by using color but I noticed my format rules are not being applied to Form Views automatically. Based on a few searches here it seems format rules should apply to form views as well. I remember this happening automatically before. Is there a setting I should update?

Can someone assist?

[Aleksi]

If you are looking for a dynamic formatting on your form view, I’m afraid that’s not possible because format rules are applied only when you save the form, not when you are filling.

[Daisy_Ramirez]

Thanks Aleksi

[Lucinda_Mason]

Aleksi,

If I have data displayed in a form that is already saved and I view it for EDITING purposes, can I apply formatting rules? I want to alert the user certain values appear.

[Aleksi]

Unfortunately that doesn’t work because that format rule is applied when you save again. It doesn’t matter is it an existing value or a new one.

[Lucinda_Mason]

Thanks. I was afraid of that.

[Steve]

You could use a virtual column of type Show and category Text to conditionally display a message.

See also:

help.appsheet.com

Column Types: Diving Deeper

Learn more about each column type you can have when structuring your columns.

[PocketDragon]

How do you get this to work with virtual columns? I created a virtual text column to show information in forms, but it still doesn’t respond to Format Rules.

[Aleksi]

You’re welcome

[Daisy_Ramirez]

Quick question, how about just fixed formatting? Just colored text?

[Aleksi]

For example you can use format rules for the Enum values.

[Daisy_Ramirez]

Got it. thanks again!