Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Automation error Formula to text

Topic Labels: Automations
Solved
Jump to Solution
145 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

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

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!