Hi I have create an app for our employees to register idea for process development.
I like to have the following restrictions:
Any suggestions on how to do the above?
peter
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…
Did you find the USERSETTINGS? Are you able to identify the user on that way?
@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
What plan are you using for this app?
@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?
@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
@Grant_Stead Hi, I like to restrict the voting on ideas by one vote / idea / day
@Peter_Westin Yeah, That’s a little tougher…
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.
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
17 |