Update all Rows where there are columns with Application Formulas
I would like to please know how I cam update all the rows in any table I have, such that all Appplicaiton Formulas will trigger in all rows where a column with them exist? This should update the values regardless if it is a table column or a virtual column.
@Colin You might want to look into reference actions, which run on a set of rows:
help.appsheet.com - Actions: The Essentials
https://www.appsheet.com/samples/This-app-shows-how-to-use-reference-actions?appGuidString=e76d2e73-... Actions: The Essentials help.appsheet.com
A sync will update all app formulas.
I am attempting to have additional columns in my spreadsheet for where virtual columns would normally go. So for example, I usually have a column for the Tableโs Label.
Previously I had a virtual columns like:
VC_LABEL_EXTENDED
(Prefix VC_ = Virtual Column)
but now I have added a spreadsheet column:
AFC_LABEL_EXTENDED
(Prefix AFC_ = Appsheet Forumla Column)
They would run a Application Forula like:
=CONCATENATE( [KEY_ID],
" - ", [DOCUMENT_NAME], " - ", [VERSION] )
It seems that when storing the value in a Virtual Column would update its data all the time, when storing the value in a Spreadsheet Column it would not update unless the record was opened, modified (โforcingโ the app forumla to recalculate), then saved.
(The idea of putting what would be Virtual Columns into the Spreadsheet as Columns is that I can use only one Appsheet application to create/calculate and manage the tableโs data. I can then have other Appsheet Applications use that tableโs data, without having to re-write Virtual Columns in all those other Applications as well. Hence the example of a common Table Label Column. Its a crude way of attempting reuse, avoiding concentrating all my application requirements into a one Huge, Super โfrankensteinโ Appsheet Application with all the huge performance and maintenance problems that brings.)
@Colin Yeah, only a sync will get the scope of updates you want.
A sync did not seem to force the updating of values on the Spreadsheet Column though.
Ahhhโฆ Iโm not aware of a way to update spreadsheet formulas en masse from AppSheet. Iโd suspect youโll need to use a timed trigger from the spreadsheet side to look for and apply changes.
Actually it is the column in the spreadsheet which is being updated with the Appsheet Formula. (Not the spreadsheet formula, but that is a later questionโฆ)
User | Count |
---|---|
41 | |
28 | |
28 | |
23 | |
13 |