Hi I have create an app for our employees to ...

[Peter_Westin]

Hi I have create an app for our employees to register idea for process development.

I like to have the following restrictions:

1. the user should not be able to vote on his own ideas 2. the user should only be able to place one vote per idea, per day.

Any suggestions on how to do the above?

peter

[Grant_Stead]

Slices will be your best friend. https://help.appsheet.com/data/slices/defining-and-using-slices

As people are entering info you should have a column with an initial value of USEREMAIL(). Then make a slice for my ideas, and not my ideas… Something like this…

https://help.appsheet.com/security/security-filters/limiting-users-to-their-own-data

And basically what you’re doing is liking/favoriting/ thumbsupping something, which means you’re creating a list in each item of who has voted for it. The best way to do this is to create an action that adds their USEREMAIL() to a list…

@MultiTech_Visions this is your method anyway, we had an awesome post about this. I’m mobile today so I can’t search Google from my phone… WTF… You think you can dig up that post where you outlined exactly how to do this…

[Aleksi_Alkio]

Did you find the USERSETTINGS? Are you able to identify the user on that way?

[Peter_Westin]

@Aleksi_Alkio I create a field for email in the table, and yes it’s fetching the users email-adress.

restrict one vote per day. an not voting on own idea

[Aleksi_Alkio]

What plan are you using for this app?

[Peter_Westin]

@Grant_Stead Thanks for input. When I create one slide with the users records, and another slide that show everybody elses records, it works!

But, how do I limit the voting by not allowing more than one vote per idea/per day?

[Grant_Stead]

@Peter_Westin you put that on the action that concatenates the useremail… So they can only vote “press/see the action” if they’re email is not in the list

[Peter_Westin]

@Grant_Stead Hi, I like to restrict the voting on ideas by one vote / idea / day

[Grant_Stead]

@Peter_Westin Yeah, That’s a little tougher…

[Aleksi_Alkio]

If you add a virtual column with an expression CONCATENATE([DateColumn],"-",[Useremail],"-",[IdeaID]) and you add this as a key column, one user can’t save this vote more than once in a day.