Help

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

Filtering Linked record according to Main record

Topic Labels: Base design
288 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi, I’m trying to create a base to record the lead generated through multiple funnels.
I’ve 2 tables.
Table 1
Screen Shot 2021-06-21 at 1.15.50 PM
Table 2
Screen Shot 2021-06-21 at 1.16.03 PM

How can I filter the second table according to the dates?
Let’s say I just need to see the record from June only.

If I filter the dates in Table 1, it would have been great that will reflect in table 2.

Something like ‘Dynamic’ Limit record selection to view.

1 Reply 1

Lookups, Rollups, and Count fields allow you conditionally show returned dates. Edit the Lookup field’s settings to turn on the “Only include linked records from …” switch and the necessary filters.