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

[Peter_Westin]

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=[...

[Aleksi_Alkio]

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]

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]

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]

@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]

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

[Aleksi_Alkio]

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]

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