Smarter Expression

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]

1 Like

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.

1 Like

Yes, Usersetting is a good approach.