Limit One Record Per Person

Question

Good day,I have an app with two tables (employees and votes).&nbsp; I am trying to set it up so that the current user (employee) can only create/submit one vote record.&nbsp; 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.&nbsp; 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.

suryaexpert · Answer

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.

suryaexpert · Answer

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.

quickbasecoachd · Answer

You can also make the field on the votes table for [Related Employee] be Unique.&nbsp; That is a field property setting.&nbsp; That will definitely block the save.

bintu85bintu85 · Answer

Thank you!

bintu85bintu85 · Answer

Thank you!&nbsp; This option worked and won't interfere with the reports we have already setup for the vote table.

Forum Discussion

Limit One Record Per Person

Related Content

Calculation/Performance Limits Inquiry

Kanban records per column limit

Custom Record Titles

Record limit when searching table

Is it true you cannot add a duplicate personal report name per App?