Usersettings in "condition to check" when using branching with bots

[Jens_Damen]

I’m trying to guide my bot to different templates based on the language the user selected in the usersettings menu.

My first guess was the obvious : USERSETTINGS([Preffered Language])="Dutch"
So this formula lives in the “condition to check” section of the branch menu.

But this returns : Function ‘USERSETTINGS’ should have exactly 1 parameters, the name of an option from the user settings.

Are usersettings not available to use in bots or am I missing something obvious again?

Thanks!

[Marc_Dillon]

Jens_Damen:

or am I missing something obvious again?

Yep.

Jens_Damen:

USERSETTINGS([Preffered Language])="Dutch"

change to

USERSETTINGS( "Preffered Language" ) = "Dutch"

i.e. quote, not square brackets.

[Jens_Damen]

Marc_Dillon:

USERSETTINGS( "Preffered Language" ) = "Dutch"

Unable to find column ‘_THISUSER’, did you mean ‘User’?

This is what I get in return

[Steve]

Attn @Dan_Bahir

[Marc_Dillon]

Oh. Bots are run by the server and thus don’t have access to USERSETTINGS, I believe.

[Jens_Damen]

Any workaround I could use to get this to work?
I don’t see a way to log the language to the sourcedata as multiple people with different languages could be viewing the data at the same time.

[Marc_Dillon]

You can implement your own user settings table. Then in the record the Bot is triggering on, have a “created_by” column, auto-filled by USEREMAIL() (this is a smart thing to do for every Table actually). Then the Bot can lookup the language preference by the recorded user email.

[Jens_Damen]

I found another way I think.

At the event level the usersettings are accepted as a condition.
So instead of 1 bot branching out I just have to build 20 bots.

If that doesn’t work out in the end I’ll try your option.

[Rafael_ANEIC-PY]

Jens_Damen:

So instead of 1 bot branching out I just have to build 20 bots.

I highly recommend building an users table, it’s very userful, and it’s a lot less work than building a bot army.

[Daisy_Ramirez]

Hi Marc, I’m running into this same issue where I need to reference data from USERSETTINGS in a task action and getting the same error “Unable to find column’_THISUSER, did you mean …”

We have a public app in our case with no access to USEREMAIL(). Is there any other way to reference USERSETTINGS in a bot?

[Marc_Dillon]

You could manage a custom user settings table with CONTEXT(“Device”) instead of USEREMAIL().

Or you can record the appropriate USERSETTINGS values into the record that the Bot is triggering on. (I mean invisibly, here, at the same time that the data change happens that triggers the bot).

[Daisy_Ramirez]

Thanks Marc, the bot was triggering an action. I was able to use USERSETTINGS by updating the action directly but not by updating the action “from within” the bot. When I ran the bot, it worked as expected.

Thanks again Marc