How are expressions calculated during form en...

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?

0 3 320
3 REPLIES 3

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.

Top Labels in this Space