Data Manipulation using List Formulas

SUMMARY: 🔔To use formulas in Workato, activate formula mode at the field level. 🔔Formula mode provides approved formulas and guidance for data manipulation. 🔔The editor shows type-specific formulas based on the data-pill type in an input field. 🔔Text must be explicitly formatted in formula mode, unlike in text mode. Topic: Modify Recipe Data with List Formulas In this session, we talk about List formulas. 📚1. first This formula returns the first item in a list. It can also be used to return the first n items in a list. In this case, the output will be formatted as a list. 📚2. last This formula returns the last item in a list. It can also be used to return the last n items in a list. In this case, the output will be formatted as a list. 📚3. index Returns the index of the first item matching the given value. Returns nil if no matching items are found. 📚4. where Retrieves only the rows (hashes) that satisfy the specified WHERE condition. This formula accepts a single argument in the form of a hash with one or more key-value pairs. 📚 Previous Session Link: https://youtu.be/Xtoa2Q6AQ1g?si=pLgTAlmcKc41D2um Find #Workato everywhere! ► Website: www.workato.com ► Twitter: https://twitter.com/workato ► LinkedIn: https://www.linkedin.com/company/workato/ ► Instagram: https://www.instagram.com/workatohq/?... 🔔Got suggestions for topics? Leave your comment down below or drop us a note at [email protected]