issue with useremail, userrolle or username

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

Solved Solved
0 3 134
1 ACCEPTED SOLUTION

3 REPLIES 3

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

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

Top Labels in this Space