Re: Can a formula field be converted to read only after a condition is met?
Re: Big Problem No problem!
Snapshots to the rescue. It's not really the "formula" you want locked, it is the lookup of the rate that you want frozen.
So I would rename your current lookup fields to be called like [Rate (lookup)] and then per the help text below, make a new field called [Rate] or if you prefer [Rate (frozen)] or perhaps [Rate (snapshot)]. Set the field properties to snapshot (freeze) the value of the lookup field. Remember to initialize the field with the checkbox when you create the field.
Then look for all uses of the field [Rate (lookup)] and replace with [Rate (frozen)]
Here is help text on Snapshots.
https://help.quickbase.com/user-assistance/setting_up_snapshot_fields.html
Snapshots to the rescue. It's not really the "formula" you want locked, it is the lookup of the rate that you want frozen.
So I would rename your current lookup fields to be called like [Rate (lookup)] and then per the help text below, make a new field called [Rate] or if you prefer [Rate (frozen)] or perhaps [Rate (snapshot)]. Set the field properties to snapshot (freeze) the value of the lookup field. Remember to initialize the field with the checkbox when you create the field.
Then look for all uses of the field [Rate (lookup)] and replace with [Rate (frozen)]
Here is help text on Snapshots.
https://help.quickbase.com/user-assistance/setting_up_snapshot_fields.html
