Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Dynamically filtering linked record

172 2
Showing results for 
Search instead for 
Did you mean: 

Looking to dynamically pull a specific record from Table 1 to Table 2 based on date. In other words

Table 1 has a list of names and dates.
Table 2 has the daily meal; what we’re eating everyday.
I want to pull what we’re eating everyday (Table 2) into Table 1 by date for each person.

I think linked records is the way to do it but I can’t tie the record it pulls from Table 2 into Table 1 by the date.

Is there a way around this? I’ve looked in the community but it seems like this is a missing feature of airtable and hasn’t been addressed by the devs yet.

Simply putting the daily meal from Table 2 into Table 1 isn’t possible due to other metadata in Table 1 that isn’t relevant to this; just simplifying the example for this post. TYIA

2 Replies 2

Hi @Alex_Ma ,

What you are referring to is a Junction Table or a Line Items table. You have to have Table 3 which is basically Table 2 (meals) with a date and then link this to Table 1

Thanks, I’ll have to play around with it but now I know where to look!