...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'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...
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, 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...
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"...
I had a partner ask "Is there like a master cheat sheet for workato formulas that I can refer to? Copilot helps me a lot, but I think having a list of commonly used real-life formulas will be great f...
Hello! I'm struggling with an error in one of my formulas 'Formula received a nil value: undefined method `+' for nil:NilClass' After doing some research, I was thinking that using "&" for safe n...
I have a recipe where I am pulling invoices from the past 2 years. I want to add a condition where it will only pull records for 10 customers. I have not been very successful in setting up a formula...