Retrieving linked records with Integromat

1580 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I am trying to retrieve linked records from multiple tables with integromat. My database is set up for a vet like this:
Table 1: owner
Table 2: pet
Table 3: treatment

1 owner can have multiple pets and one pet can have multiple treatments.

With integromat I look for a criteria in the “treatment” table to retrieve certain records but this only returns data from the “treatment” table and I don’t know which pet or owner it is related to.

I tried feeding doing something like this in my formula: “pet’s name = pet’s name” where Integromat should return records where the pet’s name equals the other pet’s name field from the “treatment” table where they are linked. Unfortunately I get errors, Airtable can’t seem to use any criteria I throw at it to somehow return the linked records.

How should I go about retrieving the data linked to the record in other tables?

2 Replies 2
7 - App Architect
7 - App Architect

Hi Zsolt – I’m less familiar with Integromat than Zapier, but could you simply add lookup fields to the treatment table to pull in any relevant information from other tables?

Or, is this thread on finding linked records in Zapier helpful (Zapier: Find Linked Records)?

Any additional details on your setup/integration would be helpful.

Thanks and I hope we can help!

11 - Venus
11 - Venus

Hi @Zsolt_Marcsev

You could also post a copy of this on Integromat’s Facebook page, they might be able to help.

Mary Kay