I have an app where our users can create idea...

(Peter Westin) #1

I have an app where our users can create ideas. and then other users can vote on their favourite ideas.

I would like to restrict it to one vote/idea per day /per user.

How do I create that?

https://www.appsheet.com/start/300f38aa-7f90-4034-b42d-d56a9a2ac29b#appName=idebank-325266-3&group=[]&page=detail&row=4&sort=[{"Column"%3A"Röster"%2C"Order"%3A"Descending"}]&table=idebank&view=idebank_Detail

(Aleksi Alkio) #2

For that functionality your users need to sign in or using the User Setting feature so you can identify who they are. I believe you have a related table for votes. If you concatenate all three columns together like CONCATENATE(Date],USEREMAIL(),[IdeaID]) and set it as key, they can’t save the vote more than once.

(Peter Westin) #3

H@Aleksi_Alkio Hi, thanks for your reply. I have dived into the documentation about User Settings, but to be honest, I does not understand how to use in order to solve the problem

(Aleksi Alkio) #4

You need to identify the user somehow… otherwise the user can vote as many times he/she wants. I assume your app doesn’t request the sign in. Then you should use USERSETTING() where the user can identify him with his device. 3rd option is to give some kind of unique ID and they should add it while filling the form.

(Peter Westin) #5

@Aleksi_Alkio do you have any links to an existing app that has implemented the Usersetting as you describe above, in order for me to see how they solved it?

(Aleksi Alkio) #6

I haven’t seen any of with that feature. I will ask if there is something already.

(Aleksi Alkio) #7

appsheet.com - Driver Jobs - A sample app to create a list of jobs for field workers. Driver Jobs - A sample app to create a list of jobs for field workers. appsheet.com

(Aleksi Alkio) #8

youtube.com - Enable Customizable Apps with User Settings Enable Customizable Apps with User Settings