How are expressions calculated during form en...

(Grant Stead) #1

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?

(Praveen Seshadri (AppSheet)) #2

Adding @Adam_Stone_AppSheet for the details

(Grant Stead) #3

I noticed in the expression assistant that the created conversational expression had the formlas from referenced columns embedded… So it got me curious…

(Grant Stead) #4

@Adam_Stone_AppSheet still interested in this. If my “helper” columns are just bloat, I want to take them out.