Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

"Agent Email" field cannot be converted to a string

Topic Labels: Automations
233 6
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

6 Replies 6

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.
Screenshot 2022-07-08 at 3.18.58 PM
Screenshot 2022-07-08 at 3.19.21 PM
Screenshot 2022-07-08 at 3.19.06 PM
Screenshot 2022-07-08 at 3.58.40 PM

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

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!