Hello Everyone,
I Have an Enum List “Number” that contains multiple Values, Each representing a column of the same name:
The fields are set to Show_If only if they are selected in “Number” and their Initial Value is 0.
However, If the user inputs a value on any of these fields, but then unselects it from “Number” I need that value to return to its Initial Value (0 in this case).
Is this possible? or is there any other method I could use achieve a similar result?
Note: Currently if unselected from “Number” it still saves the value input by user.
You could use an event action on form save to reset columns to 0 that have not been selected in the enumlist.
So if column “One” is unselected in the enum, the form save event action expression for column [One] can be something like
IF(NOT(IN(“One”, [Number], 0, [One])))
Similar expressions can be there in the action for other columns.
In general you may also want to avoid naming columns as [Number], [SELECT], [FILTER] etc. because those are either used as column types or function names in AppSheet. AppSheet is in general very tolerant in accepting such “reserved words” in column or slice , table names etc. But better to avoid them.
2 Likes
There is a setting inside the column settings: Reset On Edit
- This allows you to specify a true/false formula, that when true will cause the initial value formula to recompute.
- You can use [_thisrow_before] and [_thisrow_after] to help with detecting changes to columns as well.
https://support.google.com/appsheet/answer/10106509?sjid=8926489898349321640-NC#reset-on-edit
2 Likes
