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!