Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Automation error Formula to text

Topic Labels: Automations
Solved
Jump to Solution
440 2
cancel
Showing results for 
Search instead for 
Did you mean: 
javisantacata
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

javisantacata_0-1727696965951.pngjavisantacata_1-1727696999458.png

 

1 Solution

Accepted Solutions
Pascal_Gallais-
9 - Sun
9 - Sun

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

See Solution in Thread

2 Replies 2
Pascal_Gallais-
9 - Sun
9 - Sun

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
5 - Automation Enthusiast
5 - Automation Enthusiast

Amazing!!! Thank you!