change a fields value that wont affect previous records

Question

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

QuickBaseCoachD · Answer

np.Snapshots to the rescuehttps://help.quickbase.com/user-assistance/setting_up_snapshot_fields.htmlPost 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]

Sign up

Login to the community