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

(Peter Westin) #1

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?


(Grant Stead) #2

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…


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) #3

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

(Peter Westin) #4

@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) #5

What plan are you using for this app?

(Peter Westin) #6

@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) #7

@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) #8

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

(Grant Stead) #9

@Peter_Westin Yeah, That’s a little tougher…

(Aleksi Alkio) #10

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.