Automation error Formula to text

[javisantacata]

Hello, I would like someone to help me. I have a date field that I want to change the format of in order to include it in an automation that sends an email informing about the appointment date. To format the date that appears in the email, I created a formula field and an automation so that the date (which is of the "date" field type) is converted into a more user-friendly format. However, when I link the email content with the formula field, it’s not retrieving the date. So, I created a new automation to transfer this date to a text field, but when I do that, the text field throws an error. I am attaching screenshots of everything.

[Pascal_Gallais- · Accepted solution]

Hello,

your automation is passing value "ERROR" to field "Fecha email texto" because as soon as you create a new record in the table the formula field returns ERROR until "Fecha Entrevista" is set. This value "ERROR" triggers you automation, which explains the result.

You can solve this issue by changing your trigger to "Fecha Entrevista" is not empty, insuring that the formula did return expected result before running the automation.

I guess it was the same problem in the first place with your automation to send the mail. It may be that this automation is triggered before a date is set.

Regards,

Pascal

[javisantacata]

Amazing!!! Thank you!