Freeze/lock record/rows and linked values

Feature Ideas
1

Freeze/lock rows and linked values

We use Baserow + Carbone to generate invoices and contracts from table records. Once a document is generated, we’d like to freeze that row / record as a snapshot.

Freezing should:

  • Prevent manual edits unless the row/record is unfrozen.

  • Freeze values coming from linked tables, so later changes to those records don’t alter the frozen record.

We want to preserve the exact state of a row at the moment a document is generated.

I think this would also be valuable for anyone using Baserow for administrative, financial, contractual, or other auditable workflows, where records need to remain exactly as they were when approved, submitted, processed etc. Linked data changing retrospectively can make it difficult to determine/catalog what information a record contained at a particular point in time.

Since Baserow’s record history already tracks previous values, could a “Freeze row” feature build on that existing version history system?

2

Hi Avinash :waving_hand:,

This is an interesting feature request.
Another solution for this challenge is to create a new records table that only admins have access. You could call it Archive or Frozen data.

And whenever a specific action happens in your main table, ex- document generated or status change, you can trigger an automation that copies this row into that archive table.