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