App sheet form saving

AppSheet AppSheet Q&A
1

In my App sheet form, how can i make sure to save a form , the user has to enter responce to atleast one question in that form? i tried giving a valid if expression to one of the question, but as per my understanding, a vaid if checks only if we are editing a question responce. right?? i want some way to make sure that,that form can be saved only when atleast one question is answered.

2

Please try setting the question columns with “required_if” setting set to checked.

image
image1062Ă—528 63.4 KB

3 Likes
3

To expand on the response from @Suvrutt_Gurjar … you would need to set an expression in the Required_If property of each column that makes them required when NONE of the columns have yet been filled in.

For example, let’s say you have 5 columns on your Form of which at least one needs to be answered. The expression you would place in each of the Required_If properties would be something like:

AND(
ISBLANK([Column 1]),
ISBLANK([Column 2]),
ISBLANK([Column 3]),
ISBLANK([Column 4]),
ISBLANK([Column 5])
)

Basically, all 5 columns are initially required until one is filled in then none of them are required any more.

For me, this is not user friendly enough. So I would also supplement this with a “helper message” implemented in a Show column that explicitly explains that at least one of the 5 questions need to be answered before saving.

I hope this helps!

3 Likes