I’m developing a sample taking application and I’m trying to get my head around App Formulas and Spreadsheet Formulas and which is best for my situation.
I have a Thing and I’m taking Samples on the thing. The Thing might have multiple Samples.
I have a column in my Thing database structure called date_last_inspected which I’m currently using the following App Formula to populate:
This works after I take multiple samples and then resave the Thing record. As I would suspect given the definition in the documentation.
If I create a Virtual Column it is automatically updated as I would suspect. However, as far as I understand it this is only kept at the App Sheet layer and is not saved back into the database.
I need to be able to save the maximum returned date back into the database so that an external system can reference it. Is this possible?
Any help would be greatly appreciated.