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:
(Prefix VC_ = Virtual Column)
but now I have added a spreadsheet column:
(Prefix AFC_ = Appsheet Forumla Column)
They would run a Application Forula like:
" - ", [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.)