Quick Base Discussions

Expand all | Collapse all

Limit one record creation per user for some of-not all of tables in an app?

  • 1.  Limit one record creation per user for some of-not all of tables in an app?

    Posted 04-06-2018 14:24
    Is there a way to only allow one record creation per user for some of but not all of the tables in an app?


  • 2.  RE: Limit one record creation per user for some of-not all of tables in an app?

    Posted 04-06-2018 15:04
    I would create a user table and then join that table as a parent to any table you want to limit. When you join the table, make the related field same as record owner. Then use summary fields to count how many records they created. Create form rules letting them know they already have a record(s) and abort the save.