Limit One Record Per Person

  • 1
  • 1
  • Question
  • Updated 1 month ago
  • Answered
Good day,

I have an app with two tables (employees and votes).  I am trying to set it up so that the current user (employee) can only create/submit one vote record.  I attempted to create a relationship with a summary of votes, so that I could create a form rule that says if the current user's vote summary = 1, then hide the ADD VOTE button.  However, there is not an option to hide the ADD button.

Is there something I am missing or is there another way I can set up the app so that only one vote record is allowed per person?

Thank you.
Photo of bintu85

bintu85

  • 90 Points 75 badge 2x thumb

Posted 1 month ago

  • 1
  • 1
If an Employee can have zero or one vote, you could just have the vote as a field on the employees table itself. You don't need a votes table.
Having said that, if you still want to create a separate table for votes for other reasons, you can definitely hide the Add vote button on the form rule. It is just a field that you would put on the form and then hide it in the form rule.
Photo of bintu85

bintu85

  • 90 Points 75 badge 2x thumb
Thank you!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,256 Points 50k badge 2x thumb
You can also make the field on the votes table for [Related Employee] be Unique.  That is a field property setting.  That will definitely block the save.
Photo of bintu85

bintu85

  • 90 Points 75 badge 2x thumb
Thank you!  This option worked and won't interfere with the reports we have already setup for the vote table.