Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Message could not be converted to a string

1859 1
cancel
Showing results for 
Search instead for 
Did you mean: 
mhaveles
4 - Data Explorer
4 - Data Explorer

I have looked through a couple of the other posts about this and they didn't answer my question 😕

I have a forms to airtable automation that I am trying have send an email summary of the form responses. All of the steps of the automation are running successfully except the email message and I am getting the error "message could not be converted to a string." 

I tried having the data pulled into the email from both the google form and the second lookup function and both are giving the same error. Can someone help me out? 

1 Reply 1
Vic_Airtable
Community Manager
Community Manager

Hi there! 

This is most likely happening in the fields where you have multiple select options or a lookup in the message body.

 

However, there is a quick workaround for the current limitation – you can add a new formula field and use ARRAYJOIN() to convert the data in the lookup from an array to a string. Then, you can use that formula field in the automation instead of the multiple select field.