I have an app which used to enter the log of Production orders running on it. With each new production order. I put entry with its details like production order number, material number, material discription and starting date. Whenever i enter the new entry in a log sheet, against a specific mahine number, the previous entriese of the same machine numbers automatically updated. I didn’t deployed any automation or action for this. But i coudn’t understande, how it is being done. Please guide, what may be the reason.
Are those columns virtual columns?
If so, they continuously calculate over all the rows.
For phisical columns (real in the database), there are 2 options:
formula in the Formula field - recaulculates on record edit for that record alone
formula in Initial Value - runs only at record creation and doesn’t run again on record updates
eg.
NOW() in Formula field will update to current date and time each time you update the record, for that record alone
NOW() in Initial Value will be populated when the record is created and will stay the same for each record regardless of how many time the record is being edited.
NOW() in Virtual Column will update all the records with current date and time when any of them will be edited.