"Agent Email" field cannot be converted to a string

[Saurav_Singhal]

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.

[ScottWorld]

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.

[Saurav_Singhal]

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.

[ScottWorld]

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?

[Saurav_Singhal]

Oh Yes. Its from Step 1.

[ScottWorld]

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} & ""

[Saurav_Singhal]

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!