I have a report that has data up to the end of previous calendar month. I want to email it, with the subject line saying "Report as of November 2024" I can get December 2024 with this:=today.in_time_zone("America/New_York").strftime(" %B %Y ")But can...
Hi, I am creating a CSV output in a recipe from Query results, then sending it as an email attachment.Is there a way to make the default column width of a CSV wider ? I want the email recipient to get it and not have to widen the columns to see all t...
If a recipe is scheduled for 2:00 am, after spring DST time jumps forward to 3:00 am, Workato reschedules the job for 3:00 am. This could be a problem if there are jobs scheduled between 2 am - 3 am that are dependent on the first job running at 2 ...
I am reading 1 text field from a SQL Server select rows and want to send them in an email. Currently, it puts all the records on one line, but I want each record on a new line. Any suggestions ? I tried to force a "New line" break, but no luck.See Sc...
Hi, When writing records to SQL, I see an option to insert a "Batch of Rows", but I don't see that "batch" option in Airtable, so I am guessing I have to write 1 row at a time somehow ? Probably just 10 - 20 records when it runs.Any suggestions?
Thanks for both suggestions. At first it appeared your suggestions did not work.I found a "bug" that if the variable was "DATE" type, changed to "STRING" , Workato remembers it used to be DATE and doesn't work, so I had to create new variables
AirTable has a restriction on how many INSERTS can occur in a time-frame. So I decided to insert 1 at a time in a loop, and include a WAIT delay to insert slowly.
