Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Sep 29, 2022 12:34 PM
Hello
So I basically have a rollup tracking the amount of products ive sold in total, i was wondering if theres a way i can freeze the value in the rollup so when i delete a record that contains an amount of products sold it doesnt affect the value in the rollup.
so say i sold 5 items yesterday and 5 items today, the rollup would give me a value of 10, but if i delete the record that says ive sold 5 items yesterday i want the rollup to still give me the value of 10 and not just 5
Sep 29, 2022 12:48 PM
Hi @Luyz,
You would need to add an automation to copy the result of the roll-up at a given point in time and paste the string to a text field. The copied string will not be linked to other records and will not change dynamically.