Change User USERSETTINGS

[Hattan_Hamoud]

Hi,

I have an application with partition capabilities and I set the condition to be the country of the user. My question is, can I input initial values for “Country Option” in USERSETTINGS table for each user manually? I want to do that to force them into using the partition meant for their country only.

Thanks for your support!

[1minManager]

Yes you can set stuff in USERSETTINGS()

help.appsheet.com

USERSETTINGS()

Specified user setting value

Simon@1minManager.com

[Hattan_Hamoud]

I know how to set them up, but I do not know how to choose their values for certain users. For example, I want Jone to be on partition for Country USA from first login, how can I do that as an Admin?

[1minManager]

So you need an app user table where you have at least [Login Email] and [Country]. Then you Usersettings formula will be something like

ANY(Select(UserTable[Country],[Login Email]=UserEmail()))

[Aurelien]

Hi @Hattan_Hamoud

In addition to what @1minManager said, you also may want to use this expression:
LOOKUP(USEREMAIL(), “UserTable”, “Login Email”, “Country”)
(which is strictly the same)

[Hattan_Hamoud]

This make so much sense, it is working now!

Thanks a lot for your quick support everyone. Much appreciated.