Forum Discussion
MarkShnier__You
2 years agoQrew Legend
Is the Miles Rate a lookup field? Or is that 0.555 hard coded in a formula field. 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.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- WillisTaylor12 years agoQrew Trainee
Awesome thanks I will give this a try.
Miles rate is hardcoded to a formula field.
------------------------------
Willis Taylor
------------------------------