Unable to user Usersettings() in Action's "Only if this condition is true" expression

Hi,

I’m having trouble with using Usersettings() in Action’s “Only if this condition is true” expression.

Here’s my example scenario:

  1. I set the “Option 8” App formula and Initial value to “TRUE” in User settings as shown below.

  1. I create new Action which specify the condition to [_THISUSER].[Option 8] (which is basically equal to “TRUE”) as shown below

  1. The result is that the action is not visible. Then I just change the Action’s condition to “TRUE” and it’s visible again.

Has anyone exprerienced this kind of behavior?

Well first of all, setting both an app formula and an initial value is never correct. If this is a new thing in the settings, you may have to go into the settings view first and save it to initialize the values before seeing it reflected elsewhere in the app.

1 Like

Hi @Marc_Dillon ,

I’ve tried removing the the app formula and just set it as a Yes/No column. But it still doesn’t work. In the settings, I input the “Option 8” as “TRUE” and then save. The action is still not visible. Any suggestions?

Seems to work fine for me:

1 Like

Hi @Marc_Dillon ,

Thank you for your quick response. I think I’ve found the cause of this. It only happens with Action:“Data: set the values of some columns in this row” with inputs. Below is the how to reproduce this bug:

If I delete the input, then the condition works as expected.
Do you think this is a bug?

Yah that’s a bit weird, I can see the issue as well. An input setting with other behavior conditions seems to work ok, just not when it’s based on usersettings.

But I wonder why you are even using those input settings? I really have no idea what it is even for. You can instead use INPUT() or [_INPUT] in the column values without touching that setting.

1 Like

Hi @Marc_Dillon,

I haven’t used INPUT() because it’s being deprecated (according to this link from Appsheet). And in order to use [_INPUT] instead of INPUT(), I have to add the input settings because the Expression assistant would produce an error as shown below if I don’t add them first.

Seems like a bug to me.

There’s another post on the issue too:

3 Likes