How are expressions calculated during form entry? Are the referenced columns in expressions calculated in order or are they in a way nested and calculated in each insurance. Does having a helper column help speed?
EX: column1 has an ENUM. Column2 has some if statement with a MaxRow expression based on that ENUM. And column3 has a simple expression [column2]+[column8]… So, do all the columns recalculate at the same exact time, like is that MAXROW expression in column2 actually nested into the expression of column3 for calculation purposes?
Adding @Adam_Stone_AppSheet for the details
I noticed in the expression assistant that the created conversational expression had the formlas from referenced columns embedded… So it got me curious…
@Adam_Stone_AppSheet still interested in this. If my “helper” columns are just bloat, I want to take them out.
User | Count |
---|---|
40 | |
36 | |
34 | |
23 | |
17 |