...y formula keeps giving me syntax errors. here are few examples of formulas i have tried that give me syntax errors. (now + 7.days).beginning_of_week now.next_week.beginning_of_week t...
...n the recipe, a search result has a list datapill result like below (I'm showing just the first three results of many - showing 2 unique campaigns). I was trying to use this formula "(d...
Hi, I am trying to see if a list is present and if it's not, then use another list. I'm using this in a list input step for a modal. I would use a formula but there is no button for formula m...
Hi, I'm trying to build my first HTTP connector recipe and I'm running into an issue when I try to use formulas in the request body of a Post call. The request content type is set to json and e...
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 d...
Hi, I'd like to test IF variable a is equal to something AND variable b is either equal to value 1 OR value 2. I've set up the IF condition similar to below, but can't seem to get the IF condition t...
Hi, We have a Parse EDI task, of which the output we put in a list. For a specific field, we need to pluck a value, based on a qualifier in an object. The list "MOA loop" contains multiple "MOA"...
Hi everyone. I had a query with regards to a formula. I have a scenario where on a Wrike form, I have 4 fields that I get as a user input. Below are the fields: 1. Goal 2. Campaign P...
Hi, I am trying to use an AND operator with IF ELSE in the Formula mode in Workato. Trying to do something like: IF condition1=TRUE AND Condition2=True Value Can s...