Discussions

Expand all | Collapse all

Making a field read-only in a grid edit report

  • 1.  Making a field read-only in a grid edit report

    Posted 02-04-2020 12:12
    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
    ------------------------------


  • 2.  RE: Making a field read-only in a grid edit report

    Posted 02-04-2020 12:18
    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
    ------------------------------



  • 3.  RE: Making a field read-only in a grid edit report

    Posted 02-04-2020 12:49
    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
    ------------------------------



  • 4.  RE: Making a field read-only in a grid edit report

    Posted 02-04-2020 12:54
    Yes, Exactly.  make a new form called Grid Edit.

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



  • 5.  RE: Making a field read-only in a grid edit report

    Posted 02-04-2020 14:55
    I went the formula field route, it worked splendidly, thanks!

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