Understanding Expression Nuances. - I want to make sure I’ve got this right.
A Virtual Column recalculates when?
An app formula only recalculates when a record is opened/initially created. i.e. you have to touch it in order for it to calculate. If I have a PO with a total amount, and PO lines with costs. If I go in the back end, and adjust a single line items cost, the app will NEVER recalculate the PO total if the PO record is never actually opened in the app?
I can use an expression in the initial box, but then it’s order based, if the user changes something, and then goes back up, it’s not live, like once it pops, it’s done.
A Sheet formula isn’t live until you get a good sync. Will the sync ALWAYS pick up the results or are there cases where it doesn’t catch the results of the formulas?
Is there a way to have an app formula that calculates live throughout filling in a form, and then locks down once it’s submitted and won’t change upon subsequent reopens?