As a newer appsheet user, I and not having success using the โAre updates allowed?โ setting with the Expression Assistant for tables.
If I modify the example expression something like below (with my email replacing "myemail@mydomain.com"), I would expect when I am using the app I can edit a record, but all others are read-only.
What is happening is, nobody can edit the records.
SWITCH(USEREMAIL(),
"myemail@mydomain.com", โALL_CHANGESโ,
โREAD_ONLYโ)
Has anybody got this working?
Is it possible that USERMAIL() does not work if the app is not yet deployed?
Any advice appreciated!
@Mike_Adler, that looks generally right. I wonder if this is an uppercase/lowercase issue with your email address. Could you add two virtual columns to test this:
a) with the formula USEREMAIL()
b) with the exact same expression you have there above โฆ SWITCH(โฆ)
@praveen - I will try that and report back the results.
Thanks for the idea (still learning)โฆ
@praveen - I tested it as you suggested and the results worked!
Works as intended now (not sure why but thanks for the testing approach).
I suspect the issue was I was using the emulator screen to test.
This meant I was not logging in and out properly across accounts to accurately test the security changes.
Adding the virtual fields allowed me to check the values more accurately.
thanks again!
Even better for my use case is to use the new USERROLE() property.
Very nice addition!!
SWITCH(USERROLE(),
โAdminโ, โALL_CHANGESโ,
โREAD_ONLYโ)
@praveen - Now I just wish
appsheet leveraged the google โAdd Accountโ capability when logging in, so we could rapid switch users during development.
I can always dream!!
@Mike_Adler, I think you can do that. When you sign in to AppSheet using Google, you see Googleโs signin screen. That letโs you switch between Google accounts (and even Add Account, if Iโm not mistaken)
yesโฆ but the challenge is, you are required to re-authorize the accounts every time you change.
Not a great user experience.
Oh wellโฆ nothings perfect
User | Count |
---|---|
36 | |
34 | |
27 | |
23 | |
18 |