issue with useremail, userrolle or username

AppSheet AppSheet Q&A
,
1

Have a problem. I can’t figure out why. I am logged in to the Appsheet editor program, where you design the app. there it says that I am Admin Userrole() but when I add a product to the list, it says that I am Guest. why? I can’t find out where the problem lies, is it something to do with Sync, Server caching or the like? or key? but the Key is not changed. Suggestions on how to find the problem? security formula for the database is: IFS(
USERROLE() = “Collectium Bro”,
“ALL_CHANGES”,
AND(
ISNOTBLANK(USEREMAIL()),
ISNOTBLANK([Email Address]),
USEREMAIL() = [EmailAddress]
),
“ALL_CHANGES”,
TRUE,
“no_access”
)

Email is linked as Useremail()
Name are linked to Username()
Userrole() are linked to Membership

2

It looks like you’ve misunderstood the USERROLE function. See an overview of how to implement custom user metadata at SUMMARY TIP: User permissions, roles, and settings - Google Cloud Community .

1 Like
3

if i missunderstood the Userole, can you be more spsific to how?

4
1 Like