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 |
---|---|
63 | |
25 | |
14 | |
11 | |
6 |