Mar 05, 2024 06:41 PM
Hi All. Longtime reader, first-time poster. I'm having a logic issue that I can't wrap my head around and I'm hoping the hive mind can help.
I am building an automation in a base that tracks travel. The goal of the automation is to send an email to travelers with a summary of all of the logistics of their trip. One category I'm really struggling with is listing contact information for other people going on the same trip. Right now, the traveler profiles are in one table, the individual trips are in another table, and the parent events that those trips are connected to (conferences, etc) are in a third table, and they are all linked. The email automation is being triggered by the trip data, and ideally, I'd like to pull the contact information of all of the travelers who are linked to the same parent event as trigger record. It feels like it should be simple, but my brain is not working this one out. Do you have ideas?
Solved! Go to Solution.
Mar 05, 2024 08:43 PM
I think you could do this with an automation that would look for the records in the "People" table that are linked to the same Event record that the triggering Trip record is linked to?
Link to base
I'm not sure if I've correctly understood your problem though, apologies in advance!
Mar 05, 2024 08:43 PM
I think you could do this with an automation that would look for the records in the "People" table that are linked to the same Event record that the triggering Trip record is linked to?
Link to base
I'm not sure if I've correctly understood your problem though, apologies in advance!
Mar 05, 2024 09:26 PM
This is what I've been trying to do but unfortunately, I can't link to the Events in the automation. It's greyed out and I can't figure out why.
Mar 05, 2024 09:42 PM
The answer to this was that I made a really basic mistake. I had an old hidden field that had been converted to a single line entry instead of a linked field, and chose that one in the record lookup instead of the correct linked field. Your solution was the right one!