Bots: branch on a condition

[Orcua]

Hi,
Maybe it is a novice question but I cant find out how to do it:
I want a bot to do an action based on the chosen value of a list in a field, when I tried to do it, the simple way would be checks[actions] = “reset” but Im getting the error that a text cant be compare with a list.
then if I use in(“reset”, checks[actions]) it will always result in a YES as the value “reset” would be always IN the list.

what can I do to only check if the “reset” value was chosen?

thanks

[Marc_Dillon]

Referencing a Column value in a Table, versus referencing ALL Column values in the entire Table Tips & Tricks 💡

Having answered this question about 1 million times now, I guess I should make a tips-and-tricks post about it. Expressions of the form Table[Column] return a List type data value that contains the values in Column for ALL records in the entire Table. Most likely, If I’ve referred you to this post, the answer to your question is simply to change it to just: [Column] One of the most common places I’ve seen new app builders use this, is within SELECT() expression, like: SELECT( Table[Col…

[Orcua]

Thank you but I think the result of the SELECT will be a “List” and not a “Yes/No” which is required for the branch condition right?

[Marc_Dillon]

Orcua:

but I think the result of the SELECT will be a “List”

You seemed to have greatly mis-read the linked post. You aren’t using a SELECT expression, so the middle portion of the linked post does not apply to you.

---

---

Orcua:

checks[actions] = “reset”

Referencing a Column value in a Table, versus referencing ALL Column values in the entire Table

Expressions of the form

Table[Column]

return a List type data value that contains the values in Column for ALL records in the entire Table.

Most likely, If I’ve referred you to this post, the answer to your question is simply to change it to just:

[Column]

[Orcua]

Thanks for the clarification! yes I mis-read the important part of the post.