I have 7 virtual columns that are derived from a small set of inputs, like so:
Timestamp Name Date Weight Goal (Virtual) StartWeight (Virtual) ← Ref to the first weight an individual entered BackRefStartWeight (Virtual) ← BackRef created by StartWeight LostWeight (Virtual) PoundsToLose (Virtual)
PercentLost (Virtual) PercentProgress (Virtual) Pace (Virtual) AheadBehind (Virtual)
As you can imagine, most of of those virtual columns are calculated using the first two: StartWeight and Goal.
I show each of these virtual columns on the table and detail views, but I don’t really want any of them on the form, which should just have a name, date and weight. Following the advice of a previous post I tried to set their Show_Ifs to FALSE, and changed the UX → Options → Apply Show-Ifs Universally to FALSE as well.
The trouble is, if I switch the ShowIf of either Goal or StartWeight to FALSE, AppSheet throws errors for every row they depend on saying Goals/StartWeight can’t be found. Worse yet, when I re-set ShowIf to blank or true, those errors persist, meaning I have to roll-back my whole app using version history!
At the moment I have the form set to hide everything except those two Virtual Columns. Is there any way to hide them as well, that won’t completely break my app?
I figure I could re-write each of the other rows to not depend on StartWeight and Goal, but those two Virtual Columns have pretty lengthy AppFormulas as is, and it would seem incredibly wasteful to do so, if even possible.