Hello,
I am working in an app where I want the user to be able to edit a field based in the useremail.
I want the app to allow edit rights to the columns Tier 1 Approval, Tier 2 Approval, Tier 3 Approval looking to the columns Division and Tier Approval on the following table were requests are recorded:
For reference, there is this other table, were depending on the Division and Tier Approval in the previous table and if the user has the matching email, then will able to edit.
Solved! Go to Solution.
Hey. You can put something like this in the Editable? for Tier 1 Approval... etc...
AND(
[Tier] = ANY(SELECT(UsersTable[Tier],[Email] = USEREMAIL()))
[Division] = ANY(SELECT(UsersTable[Division],[Email] = USEREMAIL()))
)
Hey. You can put something like this in the Editable? for Tier 1 Approval... etc...
AND(
[Tier] = ANY(SELECT(UsersTable[Tier],[Email] = USEREMAIL()))
[Division] = ANY(SELECT(UsersTable[Division],[Email] = USEREMAIL()))
)
Thank you, this did the trick.
Approaching the expression like the following would be more efficient, as it removes one of the two scans of the UsersTable table:
ISNOTBLANK(
FILTER(
"UsersTable",
AND(
([Email] = USEREMAIL()),
([_THISROW].[Tier] = [Tier]),
([_THISROW].[Division] = [Division])
)
)
)
Even more efficiency could be gained by using a Current_User table:
Current User (Slice) | How to conform your app a... - Google Cloud Community
Thank you Steve, I tried the expression but for some reason I can't get it to work.
User | Count |
---|---|
41 | |
25 | |
25 | |
17 | |
12 |