Freeze Fields that are updated by a formula

Question

Is there away to freeze a field that has been updated by a formula. So if the formula changes in the future it does not change the value for a that has already been approved and processed?
Example - miles rate .555 x miles if the miles rate changes in the future, I don't want the value to change of pervious rates calculated.&nbsp;------------------------------Willis Taylor------------------------------

markshnier__you · Answer

Is the Miles Rate a lookup field?&nbsp; Or is that 0.555 hard coded in a formula field.&nbsp; If you can make up be a look up field then you can create a Snapshot field to freeze in that value when the record is first saved.
Otherwise you would have to set up a pipeline to run say every night and copy the calculated field into a scalar field for any records that were created the previous day.&nbsp;------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

willistaylor1 · Answer

Awesome thanks I will give this a try.&nbsp;
Miles rate is hardcoded to a formula field.------------------------------Willis Taylor------------------------------

Forum Discussion

Freeze Fields that are updated by a formula