change a fields value that wont affect previous records

  • 0
  • 1
  • Question
  • Updated 10 months ago
  • Answered
So i have a product list with a cost price.  This cost price is used in calculation of job costing.  When I have an increase in price, I would like to adjust the cost price field, but I don't want it to change the cost price for prior records that have used the "old" price.

So basically what I want to do is change a fields value and only have new records use that value after the value has changed - All older records are still using the old price.

Please assist
Photo of Geoffrey

Geoffrey

  • 1,730 Points 1k badge 2x thumb

Posted 10 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,928 Points 50k badge 2x thumb
np.
Snapshots to the rescue
https://help.quickbase.com/user-assistance/setting_up_snapshot_fields.html

Post back after you read that help text if you are stuck.

I assume that you have a Parts Master and there is a relationships where 1 Parts Master has many Parts Order Lines.

Basically all you do is to rename your current lookup field [Price] to be suffixed Price (lookup)]  - that is what i do so I don't get confused, and then set up a new numeric field called [Price] (which is not a lookup field) and at the bottom of the field configure it to be a lookup and remember to update all current records!

Then use the Usage Tab on [Price Lookup] to find all places it was used in formuals and replace it with [Price], for example you will no doubt have a field for [Extended Line Price] with  as formula of [Qty] * [Price (lookup)], so that will need to be updated to [Qty] * [Price]
Photo of Geoffrey

Geoffrey

  • 1,730 Points 1k badge 2x thumb
Brilliant, thanks Mark.