Set "Option Set" based on conditional logic

Questions
1

I have an Option Set called “Yes/No/Pending” that is used in some Things. By default, it is set to “Pending” in these Things.

Triggered by a user action, I run a workflow that sets this field to “Yes” or “No” based on OR/AND logic from other factors.

I may be missing something very simple, but how do I set a field to “Yes” or “No” (from my Option Set) based on OR/AND logic?

image

For example, in this case, I would like to set the KYC status to “Yes” if the Value is >= 100, and “No” otherwise.

(PS: As a workaround, I’m using a text field and “:formatted as text” after the conditional logic. I know that I can also move this logic to “Only when” and set the field to “Yes” or “No”, but it becomes a nightmare when I have to deal with multiple Yes/No/Pending fields per Thing.)

Any ideas are much appreciated. Thanks!

2

To get this to work in a single dynamic expression the trick is to use the :filtered operator.

This is how I would do it:
KYC Status = Get an option > All Options : flitered [Constraint: Display = YOUR EXPRESSION WITH MULTIPLE ANDS/ORS :formatted as text (Yes → Display Name of the Option for yes, No → Display Name of the Option for no)]

For more complicated option setting, adding a number/text property on the optionset can be helpful when filtering, but its not necessary.

3

Amazing nico! Thanks!

1 Like