sheet formulas - how are they treated in Apps...

references
(Grant Stead) #1

sheet formulas - how are they treated in Appsheet? I know that when I regenerate a table, Appsheet pulls in the formula in reference format. Is that formula only applied once on row creation, or is it also updated on row edit, similar to how an app formula recalculates when the row is touched?

(Grant Stead) #2

Alright, I did a little test. The sheet formula is ONLY inserted on a legit row add. Editing the record does NOT trigger the sheet formula to be added/updated.

(Grant Stead) #3

@praveen I’m using a QUERY to have most of a table already there, and I need the user to simply edit a record. (But then I need a formula to run GOOGLETRANSLATE…) Have any ideas? Cause the sheet formula won’t get dropped into the record unless it’s a row add. And I can’t use an APP formula to drop a formula into the cell?

(Praveen Seshadri (AppSheet)) #4

Hmm, sounds like you just want to invoke this translate method once rather than have a sheet formula (that is always computed)