Forum Discussion

ChrisSwirtz3's avatar
ChrisSwirtz3
Qrew Member
2 years ago

Limiting the number of child records that can be created

I have a child table that a user is only meant to be able to make 1 record for each parent. Is there a way to limit the user's ability to create more than 1 child record?

------------------------------
Chris Swirtz
------------------------------
Custom Data Rules
Relationships

2 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    2 years ago
    np,
    There are two parts to the method.

    The first is to make a summary field of the # of children.  Then make a form rule on your parent form to hide the add child button if the # of children is greater than zero.  Also, users can add children in Grid Edit Mode, so best if you can have the embedded child table not be going into grid edit mode when the parent is in edit mode .

    Also,  go to the roles settings and for every role set the User Interface to block the add record button.  Note I'm not talking about permissions, they do need Add permission, but the user interface so they can't just go to the child table and add a record test that way.

    ​​

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • PrashantMaheshw's avatar
      PrashantMaheshw
      Qrew Captain
      2 years ago
      Mark solution is nice and elegant .

      I tried a custom rule which will stop user from entering another after record 1 is created ,it works but that too will require Grid Edit to be turned off.

      ------------------------------
      Prashant Maheshwari
      ------------------------------