- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 12, 2020 04:50 PM
Hi all,
First time poster so forgive me if I’m posting this incorrectly. I’m trying to create an automation where by an email is sent at creation of a new record (through a form). That task seems simple enough, but I’m struggling to connect a separate tab into the flow.
The desired flow is as follows:
- User submits a completed form which includes a division field (ie, business group)
- There’s a lookup to a separate tab which pulls that division contact(s) into the view automatically
- Automation then sends email notifying the division contact of the new record for their review.
Problem is, I can’t get the lookup reference to the division contact to pass the automation test. It continues to say that I’m not referencing a valid email address, which is true, as the lookup is not returning a value but a string.
Any help is appreciated. Glad to answer follow up questions.
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 12, 2020 05:31 PM
If you’re visually seeing a valid email address and you know that it’s a text string instead of an array (which is what you would get with a lookup field), it’s possible that the problem might be with the way that Airtable handles automations that are triggered by “new records”.
It seems like Airtable triggers the automation as soon as the new record is created — often before any data has populated the record. You might be better off triggering your automation with “new record in view”, so you can control when the record appears in that view.
Also, Integromat is probably the most powerful automation tool that you can use with Airtable — significantly more powerful than Airtable’s built-in automations — and you can even set it to run on a schedule every X number of minutes to check for new records to send emails to.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 12, 2020 05:05 PM
Try creating a new formula field that looks like this:
{Your lookup field} & ""
And then reference that formula field in your automation.
Does that solve the problem?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 12, 2020 05:15 PM
Unfortunately no this created problems and opportunities that both lead to failure.
First, the contacts being pulled through the lookup are “collaborators” so the email is contained within that field type which was removed through the formula.
It gave me the idea , however, that I could add a column in the division contact table listing the email and using the formula that way. That also failed by the test showing nothing in the “To” line.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 12, 2020 05:31 PM
If you’re visually seeing a valid email address and you know that it’s a text string instead of an array (which is what you would get with a lookup field), it’s possible that the problem might be with the way that Airtable handles automations that are triggered by “new records”.
It seems like Airtable triggers the automation as soon as the new record is created — often before any data has populated the record. You might be better off triggering your automation with “new record in view”, so you can control when the record appears in that view.
Also, Integromat is probably the most powerful automation tool that you can use with Airtable — significantly more powerful than Airtable’s built-in automations — and you can even set it to run on a schedule every X number of minutes to check for new records to send emails to.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 13, 2020 08:51 AM
SCOTT! You’ve done it! Moving it to “New Record in View” was the key. Appreciate your help SO much. I’ll look into Integromat too. Appreciate all of this.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 13, 2020 09:31 AM
Glad I could help! :slightly_smiling_face: If you don’t mind, could you please mark my comment above as the solution to your question? This will help other people who have a similar question in the future. :slightly_smiling_face:
Also, since this seems to be a problem with the way that Airtable’s automations handle the “new record” trigger, you may want to submit it as feedback to them here:
I don’t believe that you’ll have any of the same problems with Integromat, which is a very mature, very advanced, and very robust automation platform.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 14, 2023 05:33 AM
This solution worked in my case \o/