Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Re: Lookup or Rollup fields do not appear in email automation

326 1
cancel
Showing results for 
Search instead for 
Did you mean: 
rrusmin
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi, I've created a simple email automation that sends volunteers a record of their contact info (people table), plus their assignments from previous years (assignments table). The assignment details appear fine as lookup or rollup fields in the people table, but when I try to run the automation the assignment details are blank.

Does it have to do with the fact that it's a one-to-many relationship (one person, multiple assignments)?

People table with rollup and lookup fields:

rrusmin_0-1737409101604.png

Automation email fields:

rrusmin_1-1737409144118.png

Automation preview (contact info not shown but appears correctly):

rrusmin_2-1737409174657.png

Thanks for any insights; I've been struggling with this for hours!

 

2 Replies 2

As a data point, I'm able to get the lookup fields to show up in a 'Grid of records' display like so:

Screenshot 2025-01-21 at 9.46.22 AM.png

Screenshot 2025-01-21 at 9.46.26 AM.png

You mentioned the preview doesn't display stuff; could I confirm that it also doesn't work when you do a 'Test automation' on a record that you've confirmed should display data?

Screenshot 2025-01-21 at 9.48.15 AM.png

If so, that sounds like a bug and you may want to open a support ticket!

rrusmin
5 - Automation Enthusiast
5 - Automation Enthusiast

OK, oddly enough when I went back to working on the automation again, both the rollup and lookup fields showed up! I can't explain it because I didn't change anything in the airtable. I was working with Fillout on an "update records" form, and when I went back to the automation I was testing, the fields displayed!

rrusmin_0-1737431922684.png

🤔Honestly I don't know what it could be, but I appreciate your reply Adam, thanks very much!