Skip to main content

Hi,



All my automations are throwing error when selecting a lookup field.



The error says “Agent Email cannot be converted to a string”



The trigger is when a new record is created in a table.



action is to send gmail.



in cc i am using a value of the field “agent email” which is looked up from a different table.



The error comes on running any automation.

If your records aren’t being created through the API nor through a form, then you’re trying to trigger an automation on a blank record, so you’ll need to change your trigger to something else.

If your records aren’t being created through the API nor through a form, then you’re trying to trigger an automation on a blank record, so you’ll need to change your trigger to something else.


Hi Scott,



Thanks for pointing this out.



The data however is coming through a form only. I have attached some of the screenshots for your reference.











Unfortunately, screenshots from Airtable Automations don’t provide enough information for troubleshooting purposes, because Airtable ridiculously decided to make a change that doesn’t show where any steps are pulling from.



So I can only guess that you’re pulling the agent email from step 1 instead of step 2?

Unfortunately, screenshots from Airtable Automations don’t provide enough information for troubleshooting purposes, because Airtable ridiculously decided to make a change that doesn’t show where any steps are pulling from.



So I can only guess that you’re pulling the agent email from step 1 instead of step 2?


Oh Yes. Its from Step 1.

I would try reselecting the email again. If it still doesn’t work, then it seems like Airtable can’t handle lookup fields properly, and I would report this as a bug to support@airtable.com. You can force that lookup field to be a string of text by creating a formula field like this: {Lookup Field} & ""

I would try reselecting the email again. If it still doesn’t work, then it seems like Airtable can’t handle lookup fields properly, and I would report this as a bug to support@airtable.com. You can force that lookup field to be a string of text by creating a formula field like this: {Lookup Field} & ""


Hey Scott,



I think i found the problem.


It was a simple error, someone deleted the old field and made the new lookup one. It’s working after reselecting the field.



Appreciate the quick response man!

Reply


Terms & Conditions