Formula that manages current form entry

AppSheet AppSheet Q&A
1

Hi everyone,

I followed several courses but I cannot understand how to mention in a formula a value I’m entering in the form: I have a form with 2 fields for example, I would like to set ShowIf in field #2 in dependence of entry currently inserted in field #1.

2

Columns are always referenced in expressions by placing square brackets around the column name. In a Show_If property, you only to specify the condition. AppSheet will construct the appropriate formula to apply your constraint. So for your use case, you only need to enter into the Show_If something like:

ISNOTBLANK([Field #1])

This basically translates into “If the value of Field #1 is not blank then show Field #2”

2 Likes
3

thanks much @Anonymous

1 Like