I am new here, it is my first topic, and first of all I wanted to congratulade Glide team ! It is an awesome job what they have done !
My project :
I have question, and I want people to vote on different choices.
So in a question, I have create a “FORM” button that I have called “VOTE” and that displays “CHOICE” list.
I want user to be able to vote JUST ONCE.
However I cannot figure out how to make the button invisible when the user has already voted once.
The idea that I have explored :
In my google sheet I have a tab for que questions, and a tab where I collect the votes.
I was able to create a “relation table with multiple” between those two and a “lookup” to see “who has voted” (email) for each question.
I wanted to say something like IF “Who has voted” contains “Current User”, make the button “Vote” invisible. But I was no able to go to the end of this idea.