Hi, I’m using Softr Database and trying to do the following:
1 table with products: Reference, Description, Price
1 table with Orderlines : …,OrderRefrence,ProductReference, ProductPrice, Quantity, .TotalLine…
1 table with Orders: Reference, OrderlinesTotal
Using a page Order details with a table with source=Orderlines and a button ‘Add Record’ I need to add a record OrderLine: pickup a product and define quantity.
It works as expected, my problem is that the original product price changes over time but I don’t want my past orders to be updated with new price.
Is there a way to avoid that like removing the link on price field?
In other words, is there a way to use a table kind of reference table for the record creation then have that created record unlinked from the original reference tabel.
You could create a duplicate product record in: “1 table with products: Reference, Description, Price” and change the price. Then, keep all previous records linked to the product variety with the previous price and all new records linked to the same product variety at the new price.
Not ideal if you have many products and frequent price changes.
When automations are released, these would be helpful for writing a dynamic price to a static field, therefore capturing a price at sold-at price at its point in time to another field to preserve its historic value.
Had the same idea with an extra field like Archive to flag past products but then how can i make my ‘Add record’ button load only non-archived products?