Just create a formula field that equals the field you want to lock off. Formula fields are “read only” fields, so they can’t be edited by the user.
But remember, if they go back to the original view, they’ll be able to access the field again.
Just create a formula field that equals the field you want to lock off. Formula fields are “read only” fields, so they can’t be edited by the user.
See, I knew someone had this answer. Thank you @ScottWorld!!! Anyway you can show me an example of the formula field. Would this be a concentrate or could I use a lookup/rollup?
See, I knew someone had this answer. Thank you @ScottWorld!!! Anyway you can show me an example of the formula field. Would this be a concentrate or could I use a lookup/rollup?
The only thing in the formula would be a pointer to the field you want to “lock.” For example, if your target field is named something like {Bid Price}
, then the Formula field could be named something like {Bid Price Locked}
, with the formula:
{Bid Price}
That would duplicate the value in the {Bid Price}
field, but wouldn’t be editable.
The only thing in the formula would be a pointer to the field you want to “lock.” For example, if your target field is named something like {Bid Price}
, then the Formula field could be named something like {Bid Price Locked}
, with the formula:
{Bid Price}
That would duplicate the value in the {Bid Price}
field, but wouldn’t be editable.
Thank you @Justin_Barrett. You and @ScottWorld saved me so much trouble!!