Hi Community,
I wonder if anyone would know of a smarter way to write this expression:
contains(lookup(USEREMAIL(),โUsersโ,โEmailโ,โSiteโ),[Site])
This works for me as a security filter for a table but I get the old:
Note, this expression could significantly impact sync time.
Which when the app is complete could slow it down somewhat.
Thanks in advance,
Chris
May I ask what these two Site columns are? What is the column type?
Absolutely,
They are both text columns and contain the Location Name i.e. London
Are you able to use just LOOKUP(USEREMAIL(),โUsersโ,โEmailโ,โSiteโ)=[Site]
Yes, able to use that but is the same warning that it may imapact sync times.
Instead, I have took the plunge into USERSETTINGS() and finding that this is better, kind of strayed away from these before but theyโre fantastic!
Thanks for investigating @Aleksi, as always, great help and response from the team.
Best,
Chris.
Yes, Usersetting is a good approach.
User | Count |
---|---|
35 | |
35 | |
28 | |
23 | |
18 |