topic Re: Can we create both AND and OR options in IF/Else action in workato? in Workato Pros Discussion Board

Can we create both AND and OR options in IF/Else action in workato?

alvina-aslam — Tue, 14 Jun 2022 18:51:57 GMT

Like when we create an if/else condition, it asks for "Or" and "And". But when we select "Or" then in the next step it shows only "Or". Can we use the "And" operator after "Or" in if/else?

Re: Can we create both AND and OR options in IF/Else action in workato?

jelle-vanloock — Tue, 14 Jun 2022 18:56:36 GMT

Currently it is not supported. However, it is possible to switch to formula mode and retype your condition towards an "is true" condition for example

data field: "firstName == 'Jelle' or lastName == 'Van Loock' and ..."

condition: is true

Re: Can we create both AND and OR options in IF/Else action in workato?

alvina-aslam — Tue, 14 Jun 2022 19:11:33 GMT

Like if I said amount>9000 and deptno=8 or deptno=7

is it possible to make and or or like scenerio??

Re: Can we create both AND and OR options in IF/Else action in workato?

jelle-vanloock — Tue, 14 Jun 2022 19:13:46 GMT

With correct encapsulation, it will work. Just make sure the condition will end in a boolean value.

Re: Can we create both AND and OR options in IF/Else action in workato?

alvina-aslam — Tue, 14 Jun 2022 19:24:58 GMT

but when once I select the OR then the AND option disappeared.

Can you give a screenshot where we can use both AND/OR in if/else at a time??

Re: Can we create both AND and OR options in IF/Else action in workato?

jelle-vanloock — Tue, 14 Jun 2022 19:28:33 GMT

Don't use AND/OR, switch entirly towards a formula.

Hopefully this helps!

Re: Can we create both AND and OR options in IF/Else action in workato?

alvina-aslam — Wed, 15 Jun 2022 11:56:24 GMT

yeah I got it.

Thank You

Re: Can we create both AND and OR options in IF/Else action in workato?

srveluthurla — Mon, 20 Jun 2022 11:01:26 GMT

CAN YOU SHERE on vedio of SDK

PLEASE

srveluthurla@gmail.com

thanks

Re: Can we create both AND and OR options in IF/Else action in workato?

jcapitan — Thu, 23 Jun 2022 04:40:44 GMT

I'm trying to do something like this but clearly I'm down the wrong path. Any suggestions on how best to achive this?

Re: Can we create both AND and OR options in IF/Else action in workato?

harish — Thu, 23 Jun 2022 08:43:04 GMT

You can use the `is true` option and write your complex condition in the formula mode in the `Data field` as shown below