succ → new_strReturns the successor to str. The successor is calculated by incrementing characters starting from the rightmost alphanumeric (or the rightmost character if there are no alphanumerics) in the string. Incrementing a digit always results ...
Hi All,I'm trying to return records from a SQL database where the dates in the "lastcastingdate" column of the DB is more than 14 days ago. I have entered the following into the WHERE clause in the Select Row action:=LASTCASTINGDATE < today - 14.da...
Hi all,This may be a simple 'yes/no' but just posting here in case I'm missing something - I am using the Slack Workbot to send messages and manually 'build' the block kit.It looks like the 'Header' block is not available?Header on Slack is larger th...
Hi all,New to Workato.I have a requirement to extract the first 500 characters of a string, I tried to do this with a formula but for some reason it's not working:String.scan(/.{0,500})The regex seems to be correct, but the end result is empty - not ...
Dear Workato teamI hope this message finds you well. I recently attempted the Automation Pro II Exam but was unable to pass. I have been studying the material and practicing to improve my understanding. I would greatly appreciate it if you could pro...
Hi Workato Team,Is there any future releases/plan to include AI copilot trail feature to the users using Base plan.I would like to explore the tool to help in managing the recipes efficiently.Regards,Prudvi
Hi everyone,I have a Workato recipe that connects Salesforce with Google Drive.In the recipe, I’m creating Google Drive folders where the folder names are based on Contact names and their Date of Birth.This setup works perfectly.However, I want to ch...
Dear Automation Pro Community,I very much want to discuss Workday data access/update to/from Workato. It appears that invoking processes within Workay - such as "Hire Employee" is easy enough, but providing the associated parameters looks to be rath...
: Dynamic SQL Query with Keywords from Lookup Table in WorkatoCurrent SQL Query:SELECT * FROM ( SELECT *, TRIM( COALESCE( CASE WHEN LOWER(TRIM(formula_1)) LIKE '%payments%' THEN 'Payments' ELSE '' END || CASE WHEN LOWER(TRIM(formula_1)) LIKE '%servic...
I'm getting null objects in my filtered list. how can I remove the null objects w/o using Pythion script?Example:[{"name" : "Nitish","Id": "010"},{},{"name" : "Nitesh","Id": "020"}]
