How can I make a user’s rating on a photo unique?

Ask for Help
1

Hi everyone,

How can I make a user’s rating on a photo unique?
Sheet1 is formed in this motion:
Photo ID, photo, voting, email, I created a realtion column that relates photo Id to voting column, then I created a column Lookup retrieves the emails from the email column.
I configured a button that when pressed retrieves the user email from the User table and writes it in the email column of sheet 1, and makes the button to limit the votes disappear.
It works, but the problem is that only one user will be able to vote since the email column has already been populated by the previous user who voted.
How do I make the vote unique for each individual user?
Do I need to retrieve user id from user table?
I don’t understand what logic I should use.
Thank you for your attention

2

If you make the email column User Specific, then each user will have their own value in that column.

The downside to that is that it won’t be possible to count all votes (for example). If you need something like that, then the solution is slightly more complicated. You’d either need a separate table to record votes (one per row), or use an array of user emails in your existing table.

1 Like