Hello.
I'm writing an app with a single form. It is a calculator (not an arithmetic one) where the user supplies some data (16 items) and it returns an evaluation.
The basic flow is this:
1. The app shows 3 fields where the user provides the data. All other fields are hidden at this moment.
2. After all 3 fields are filled in, the Category field of the user is determined (based on a formula using a sheet with the data indicating which ranges correspond to each category).
3. With the Category field (which is a required Ref, not Virtual column) not blank anymore, the other fields are shown. The show_if formula for each of these fields is the same: ISNOTBLANK([_THISROW].[Category]) .
4. This Category field is always hidden. It used to be displayed, but we added a Category Description field with friendlier text to the user and it maps each Category to a Description in other sheet (1 : 1). Now we keep the Category field hidden, since it is used by other fields (not only their show_if formulas but their value formulas too).
5. The user can now provide the remaining data. A score is calculated for each input (for some, a simple formula, for others a mapping to other sheets, one per input). At the end, a final evaluation field (also displayed after the first 3 fields are filled in) gives a result back (after mapping the sum of the individual scores to predefined texst in other sheet (1 : 1) ).
The issue is: AFTER filling the first 3 fields (always displayed) and getting the Category filled automatically, some fields show and others don't, even though they have the same show_if formula: ISNOTBLANK([_THISROW].[Category]).
And this behavior appears and disappears as we change the app, adding more features or changing existing ones.
Any idea what could be causing this?
Thanks.
LinkedIn
Twitter
