Forum Discussion

LienGilhooley's avatar
LienGilhooley
Qrew Cadet
4 years ago

Toggle the "Read-only" form element attribute

I have a key field that ties my child record to my parent record.  The key field of the child record has the "read-only" form attribute as shown here:


When a user creates a child record from within the parent record, there are no issues as the key field in the child record gets automatically populated with the parent key data and the child key field is locked so the user can't inadvertently change it.

The issue is when the user creates the child record without being inside the parent record already.  In this case, the child key field is blank/null and the field is "read-only".  I would like to toggle the "read-only" attribute off at this point so the user can select the parent record in which to tie to the child record.  Is this possible?


------------------------------
Lien Gilhooley
------------------------------
Forms
roles and permissions

1 Reply

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    4 years ago
    You can have a form rule that says when Related Parent >0, make read only related parent.  You can also give the user a check box visible in edit mode to unlock related parent and put that in the form rule as well. (like if the poarent got deleted and the child needed to be re attached to a new parent. 

    I get what you are trying to do.  You don't want the user to inadvertently change the parent record or clutter the input form with an extra data entry field when they launch off the parent..

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