Skip to main content

Message could not be converted to a string

  • May 23, 2023
  • 1 reply
  • 5 views
M

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

Vic_Airtable
  • Vic_Airtable
  • Participating Frequently
  • 102 replies
  • May 25, 2023

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.

Reply


Most helpful members this week

Terms & Conditions