Forum Discussion

Qrew Captain

4 years ago

Conditional Read Only in Grid Edit

I don't believe this functionality is possible, but this community comes up with a lot of sneaky work-arounds... I have a form with a dynamic rule that makes some fields read only, based off anothe...

Grid edit

Tables and fields

MarkShnier__You

Qrew Legend

4 years ago

I often find myself making Mirror fields which are simply formula equivalents of data entry fields, in order to put them on a grid edit embedded report on a form and thus prevent data entry into those fields.

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

MichaelTamoush
Qrew Captain
4 years ago
Yeah I will probably make mirror fields, however the trick is I WANT them to be able to grid edit, up until a certain condition is met, and then I want those same fields locked. Since I can't dynamically choose what columns to show in a report link, I am thinking I need two report links - one that includes editable fields, and one that includes the mirrors. Then use dynamic rules to show the appropriate report link.

I was hoping there was some trick in making a grid edit form and using dynamic form rules there, but I don't believe that works. Wasn't sure if there were more solutions I was overlooking.

------------------------------
Mike Tamoush
------------------------------