Grid Edit overriding Form Rules

Question

Hi All,&nbsp;I have a form rule that basically shuts down all fields on a record once it has been checked, making it view only to the end user. Unfortunately, we have users that like to update and/or copy their records in Grid Edit, and as we all know, Grid Edit overrides form rules. Without excluding these checked records from a Grid Edit report, are there any workarounds for displaying records in Grid Edit but keeping them view only?&nbsp;&nbsp;------------------------------Urs.------------------------------

markshnier__you · Answer

Are you willing to set up a Custom Permission Rule to block editing of the record for certain Roles if some formula condition calculates to false?

For example create a field called [Regular staff can edit?] as a formula checkbox field and then hook a Custom Role permission to Modify based on that being true.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

ursulallaveria · Answer

Hmmm I hadn't thought of that as an option. Would that make records view-only in a grid edit report?
It's worth a try no matter what!

------------------------------
Ursula
------------------------------

markshnier__you · Answer

Re: Would that make records view-only in a grid edit report?

Yes.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Forum Discussion

Grid Edit overriding Form Rules