I am trying to use the automation feature to create 4 new records in my table at the start of each month. I would like to use the month the records are created as part of the record name, written out alphabetically, follow by some custom text. For instance, the records automatically created in November would read “November Totals”
I currently have the trigger set to…“Trigger type: At a scheduled time” —> “Interval Type: Months” —> “Timing: Every 1 month on the 1st at 12am” —> “Starting: Today”
For the action i currently have… “Action: Create Record” —> “Table: Totals” —> “Field: Monthly Report”
When i select next trigger time and run a test, it creates a record that reads “2021-11-01T06:00:00.000Z”. I tried using datetime_format() to no avail.
Am i able to create a custom text using the created date using this automation?