topic Re: "If" type formula in Workato Pros Discussion Board

"If" type formula

dan-lowry — Fri, 11 Jun 2021 00:12:17 GMT

Hello all!

Is there a way to create a formula that uses .present? on a string and then inserts one of two options into the field? Seems like there is a way to do it, but I'm having issues with the syntax. The specific use case is as follows:

[datapill1].present?

{"true": [datapill1].gsub(_([datapill1]).split(';').first()+"; ","")}

{"false": nil}

Re: "If" type formula

ajorde — Fri, 11 Jun 2021 00:16:52 GMT

[datapill1].present? ? ([datapill1].gsub(_([datapill1]).split(';').first()+"; ","")) : null

Sometimes I want the result to be an empty string instead of nil - in that case, I do this:

[[datapill1],''].compact[0]

Re: "If" type formula

vijay-narsimha — Fri, 11 Jun 2021 00:18:19 GMT

you can use something like this

Re: "If" type formula

bala-s — Fri, 11 Jun 2021 00:37:45 GMT

=_('data.logger.3dcdc175.message').present?? (_('data.logger.3dcdc175.message').gsub("dr","").split(";").first() + "; " + "") : nil

Re: "If" type formula

dan-lowry — Fri, 11 Jun 2021 00:42:40 GMT

Thanks for all the responses! I knew I was missing something and that second ? fixed it.

Re: "If" type formula

georgiaria — Fri, 11 Jun 2021 02:57:02 GMT

The "ifCondition ? resultIfTrue : resultIfFalse" syntax is called a ternary expression in case that helps your research/understanding. 🙂

Re: "If" type formula

glen-nicholas1 — Fri, 11 Jun 2021 03:11:56 GMT

You can write it in english too:

if [pill].present?

"resultifTrue"

else

"resultifFalse"

end

I find it helpful to have it be descriptive if I'm sharing the recipes with other teams.