Hello All,
I have a virtual column in my โCustomerโ table which does calculations of โpointsโ based on transactions in the โBookingsโ table.
I would like to โsaveโ these results in a โpointsโ cell in my Customer table. so that they are hard coded in the spreadsheet and so that i can work with them with another application.
I can obviously save the points into the cell using the app formula =VirtualColumn but then it only saves when I update the customer and i hit the save button. I would like the save to happen automatically across all the customers.
Anyways i can achieve this?
Thanks in advance!
@Hannes_Rohregger In non-virtual columns, app formulas are only updated when the row is added or updated (or related rows are added or updated).
One thing you might consider is using a spreadsheet formula. That will be computed on sync, but it will happen for every instance of the formula (not just when the record is updated).
The spreadsheets formulas would work but then who/how would they be populated once there is a new โCustomerโ entry? I would need to manually go in and copy down the formulas to the new row?
Thanks
@Hannes_Rohregger AppSheet can automatically add spreadsheet formulas to new rows that are added. Take a look at this article: help.appsheet.com - Spreadsheet Formulas Spreadsheet Formulas help.appsheet.com
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |