Mar 06, 2024 03:37 PM
Hello, I have a problem. I have a client table, a sector table, and a date time table. So I'm linking a client with one sector and some dates. What I need to do is another table to set meetings. I need a form where a company can write the company name, and then choose a sector but only show those dates from a specific sector and the company needs to be able to choose one date from those dates from the sector.
Solved! Go to Solution.
Mar 06, 2024 04:36 PM - edited Mar 06, 2024 04:36 PM
Here you go:
How to select and filter Airtable linked records in a dropdown
p.s. If your company has a budget for your project and you’d like to hire an expert Airtable consultant to help you with any of this, please feel free to contact me through my website: Airtable consulting — ScottWorld
Mar 06, 2024 03:43 PM
This is not possible with Airtable's forms, because Airtable doesn't offer dynamic filtering yet. But you can get this functionality from Fillout's advanced forms for Airtable.
Mar 06, 2024 03:51 PM
Well, I tried, and I see it has the same functionality. because what I need to do is when the user picks a sector I need to only show the dates set for that sector. Not all dates. Is that possible with Fillout?
Mar 06, 2024 04:21 PM
Yes, that is correct. You can dynamically filter linked record fields in Fillout.
Mar 06, 2024 04:30 PM
How can i Do that.
table 1: companies
company 1 - sector 1
company 2
table 2: sector
sector 1
sector 2
table 3: dates.
date 1 -- sector 1
date 2 -- sector 1
date 3
I want to pick sector 1 and only see company 1. and choose only date 2 or 3 .
Mar 06, 2024 04:36 PM - edited Mar 06, 2024 04:36 PM
Here you go:
How to select and filter Airtable linked records in a dropdown
p.s. If your company has a budget for your project and you’d like to hire an expert Airtable consultant to help you with any of this, please feel free to contact me through my website: Airtable consulting — ScottWorld
Mar 06, 2024 07:33 PM
Awesome! the tutorial Helped a lot! Thanks.