topic Re: How to use character comparaison with IF condition in Formula Mode? in Community Chat

How to use character comparaison with IF condition in Formula Mode?

SylvainA — Wed, 29 Jan 2025 15:48:52 GMT

Hello everyone,

With Automation studio, I need to do a character comparaison in Formula Mode. My currency code in Epicor is CAN but I need to save CAD in currency code of HudSpot.

I need to do something like this:

CurrencyCodeField = "CAN"? "CAD" : "USD"

I tried this but it doesn't work.

Re: How to use character comparaison with IF condition in Formula Mode?

Prudvi — Thu, 30 Jan 2025 10:54:13 GMT

Hi @SylvainA,
Did you try using "match?" formula.(MatchFunction )

datapill.match?(/CAN/)?"CAD":"USD"

I have created a variable and using match function, I am validating if the variable contains the CAN.
If true passes CAD and false passes USD.
Regards,
Prudvi

Re: How to use character comparaison with IF condition in Formula Mode?

shivakumara — Thu, 30 Jan 2025 14:58:31 GMT

Hi @SylvainA ,
Here is solution:

I prefer to add one more condition to have optimize solution to avoid the wrong response
<Input> == "CAN" : "CAD" : <input> == "USD" ? "USD" : "Wrong Input"

Thanks and Regards,
Shivakumar K A

Re: How to use character comparaison with IF condition in Formula Mode?

shivakumara — Thu, 30 Jan 2025 15:00:59 GMT

Hi @Prudvi,

Your solution not works in most cases, Say if the word is prefixed or suffixed with "CAN," it still returns "CAD."

For exmmple:
- "DECCAN" matches and results in "CAD."
- "CANBERRY" also returns "CAD."

While I understand that we are aiming for accurate input matching, our solution should be more optimized to handle such cases effectively.

Thanks and Regards,
Shivakumar K A

Re: How to use character comparaison with IF condition in Formula Mode?

Prudvi — Thu, 30 Jan 2025 14:58:05 GMT

Hi @shivakumara,
Thanks for pointing out.
Regards,
Prudvi

Re: How to use character comparaison with IF condition in Formula Mode?

SylvainA — Thu, 30 Jan 2025 22:20:08 GMT

Thank you for your quick answer @shivakumara but ... it still doesn't work. I tried the easiest way to keep it simple.

<Input> == "CAN" ? "CAD" : "USD"

and I receive this error msg

{"status":"error","message":"Property values were not valid: [{\"isValid\":false,\"message\":\"USD== \\\"CAN\\\" ? \\\"CAD\\\" : \\\"USD\\\" was not one of the allowed options: [label: \\\"CAD\\\"\\nvalue: \\\"CAD\\\"\\ndisplay_order: 0\\nhidden: false\\nread_only: false\\n, label: \\\"USD\\\"\\nvalue: \\\"USD\\\"\\ndisplay_order: 1\\nhidden: false\\nread_only: false\\n, label: \\\"EUR\\\"\\nvalue: \\\"EUR\\\"\\ndisplay_order: 2\\nhidden: false\\nread_only: false\\n]\",\"error\":\"INVALID_OPTION\",\"name\":\"devise___currency\",\"localizedErrorMessage\":\"USD== \\\"CAN\\\" ? \\\"CAD\\\" : \\\"USD\\\" ne faisait pas partie des options autorisées : [label: \\\"CAD\\\"\\nvalue: \\\"CAD\\\"\\ndisplay_order: 0\\nhidden: false\\nread_only: false\\n, label: \\\"USD\\\"\\nvalue: \\\"USD\\\"\\ndisplay_order: 1\\nhidden: false\\nread_only: false\\n, label: \\\"EUR\\\"\\nvalue: \\\"EUR\\\"\\ndisplay_order: 2\\nhidden: false\\nread_only: false\\n]\",\"propertyValue\":\"USD== \\\"CAN\\\" ? \\\"CAD\\\" : \\\"USD\\\"\",\"portalId\":452734}]","correlationId":"0d7d8ca1-1894-4f9f-8b25-25e0bc7924f4","category":"VALIDATION_ERROR"}

Re: How to use character comparaison with IF condition in Formula Mode?

shivakumara — Fri, 31 Jan 2025 03:43:42 GMT

Hi @SylvainA ,
Could you please include the Workato formula you used so that I can review it? (Include screenshot of your source and formula you have used)

Thanks and Regards,
Shivakumar K A

Re: How to use character comparaison with IF condition in Formula Mode?

SylvainA — Fri, 31 Jan 2025 18:42:58 GMT

HI @shivakumara ,

Sorry, Your answer was correct. The problem was that I wrote a formula but in a text mode. I simply switch to formula mode and it was a success. It's my fisrt formula, I will learn. 🙃

Regards,

Sylvain