Making a field read-only in a grid edit report

Question

Is it possible to make a field read-only when viewing a report in grid edit mode? We want users to be able to see what selections were made in that field on the report but not be able to change what was selected.

------------------------------
Chris Swirtz
------------------------------

chrisswirtz2 · Answer

I went the formula field route, it worked splendidly, thanks!------------------------------Chris Swirtz------------------------------

markshnier__you · Answer

np, There are actually two easy choices.

What you do is to make a formula field equal to the editable field. So for example if [Priority] is the real field then the formula text field called [Priority.] (note the period in the name) will just have the formula field.

The other option is to make a dummy form with the exact columns that you want to use in Grid Edit. I typically name those forms "Grid Edit". :) checkbox that field as being read only on the Form Property.

Then because you have more than 1 form, Quick Base gives you options in forms usage of which form to use, and you can set the Grid Edit Form to be used for Grid Edit.

So two ways to go.

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

chrisswirtz2 · Answer

So i thought I was being clever but kind of utilizing the 2nd option you provided. But what I did was create a copy of the original field in the form and set that one to be read only in the form properties and only be shown when viewing a record. Then set up rules to mark it checked or unchecked based on the original field being checked or unchecked when adding or editing a record, which that all worked perfectly. However the intent was to be able to use that field that was marked as read-only in the report that would be used for grid-editing instead of the originally field, but when I tested it out, that read-only field was no longer read-only once grid edit mode was entered.

But you are saying that if I just create a separate form and make that original field as read-only, that will do the trick instead?

------------------------------
Chris Swirtz
------------------------------

markshnier__you · Answer

Yes, Exactly.&nbsp; make a new form called Grid Edit.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Forum Discussion

Making a field read-only in a grid edit report

Related Content

Pipeline Make Request - Return Make Request JSON Output into fields

Make entire form read-only

Problems constructing Headers in pipelines 'make request' channel

embedded reports

Way to Duplicate Tables or Make A Template for a Table?