Skip to main content
Question

Automations Not Recognizing my Emails

  • January 26, 2026
  • 2 replies
  • 24 views
S
Forum|alt.badge.img+1

Hello Airtable Friends!!

 

I am trying to send automations to emails, but my automation field is not loving any of the formats I am using to store the email. I’ve got a lookup field, I’ve got a rollup field, I’ve got a formula field to put the lookup field into, and nothing!!! Can someone please point to where I’m going wrong?

For some (maybe?) useful background: these fields are connected to one that is “limited to last 1”, so I only see who checked out a piece of equipment most recently, the original emails are synced from another base, and I select the field name in the drop down list so the “Field ID” keeps coming up, regardless of which field I select (the ID’s vary, though).

 

 

2 replies

DisraeliGears01
Forum|alt.badge.img+21

the original emails are synced from another base

By this do you mean the email addresses or are you trying to reference other emails?

Regardless, you don’t want the Field ID (I rarely use the Base Structure options in automation builds), you want the record of whatever trigger you have (presumably, there are other workflows but this is the simplest implementation). 

    TheTimeSavingCo
    Forum|alt.badge.img+31

    Here’s screenshots of what DisraeliGears is talking about and you can find the base here

    Assuming the data looks like this:

     


    Then this is what the automation setup should look like:

     

    Adam, Airtable Consultant - thetimesaving.company
      Terms & ConditionsAccessibility statement