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

  • 39
  • 1
  • Question
  • Updated 1 year ago
  • In Progress
Is there a way to only allow one record creation per user for some of but not all of the tables in an app?
Photo of Aylin Nazlim

Aylin Nazlim

  • 312 Points 250 badge 2x thumb

Posted 1 year ago

  • 39
  • 1
Photo of Gil Spigelman

Gil Spigelman

  • 940 Points 500 badge 2x thumb
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.