Help

Message could not be converted to a string

1631 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.