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"...
...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...
Hello everyone I have a question about the lookup tables。I want use formula in column。 I want to find a data start with “B”, How to write the formula in column?
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...
I have an array which look like this below. I can manage to remove the 1st level of fields using except formula. users[0].except(:two_factor_auth_enabled,:signature). I am trying to remove the n...
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...
