I am not very good at explaining, but here is an app I made for just that.
Not sure if it may be too simple for you…
(This also takes advantage of the NEW Look before you Sign In option!)
1 Like
Nice job!
nice app but now i need a way for users to vote without forms so i am trying to use increment but using increment can not stop multiple voting
I would probably create another relation on the candidates sheet using candidate name and a rollup to count the number of votes in the form response sheet.
Make sure position is part of the template columns used for your original relation.
I don’t think this would work. You need to use a form so you can get the user’s email, candidate position, and candidate. User email is key here so you can assure that there is only one vote per person per position.