If you have spreadsheet formulas in your app, there may be situations where expressions cannot be calculated properly until the sync is complete. I would love to have an IFERROR kind of expression so that I could designate an alternate behavior (or alternate display) until the sync is complete. Is that possible with current expressions?
Any conditional expression (IF(), IFS(), SWITCH()) would work, I’d think.
Can you provide a more-concrete example of what you’d like to do?
Thanks @Steve! I think what I need to do is make a little demo app that replicates the problem. I’ll try to do that eventually but I’ll have to put it on the back burner for a few days.
1 Like
@Kirk_Masden I sometimes have a similar problem where I have a massive formula in a virtual column, but I don’t want the App to run it in its entirity on every row. So at the beginging I create a sort of quick bug-out option (similar to what @Steve was suggesting:
IF([Bugout]=0,“”,…
This will cause it to skip the rest of the formula.
Hope this helps
4 Likes
Thanks! I was trying to do something like that but for some reason was having trouble. I’m not yet sure what I was doing wrong.