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

  • 0
  • 1
  • Question
  • Updated 7 months 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

  • 202 Points 100 badge 2x thumb

Posted 7 months ago

  • 0
  • 1
Photo of Gil Spigelman

Gil Spigelman

  • 870 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.