Jul 22, 2024 10:55 PM
Hi,
I have a Table called Budget. Budget table has multiple fields like Product, Cost, Monthly cost(Jan-Dec), budget year dropdown field, Property list, etc,.
This is the form for creating a new budget in the budget Table.
I want to list the property name with existing budget data in the Budget Table. If I chose X property Name, That Property Name already has a budget in that table, So I want to list down the budget cycle values only(years 2024, 2025, 2026, etc.,) depending on Property Name.
For example, Property A has budget details with the budget cycle 2024 and 2025. So When I choose Property A in Property Name, Budget Cycle should list only 2024 and 2025. So that I can choose any one of these.
Is that possible?
Jul 23, 2024 02:20 AM
Hello Bharathy,
There is no straightforward solution to your issue to my knowledge, but I may be wrong.
One way to manage it is to add in your table a "Cycle" field for each property:
"A Cycle" has options 2024 and 2025
"B Cycle" has options 2025 and 2026
...
In you form, you first add the "Property" field and the all "Cycle" fields:
And you set visibility options for each "cycle field":
Finally, you can have a formula field in your table to have a common "Cycle" field for all records:
This solution is far from ideal because there is some maintenance when a new property is defined and it is not convenient if you have more that 10 properties.
I would be very interested to know if anyone had a better solution.
Regards,
Pascal
Jul 23, 2024 02:20 AM
Yeap, you can do this with dynamic filtering: https://support.airtable.com/docs/dynamic-filtering-in-linked-record-fields
Jul 23, 2024 02:15 PM - edited Jul 28, 2024 01:40 AM
You can do this with Airtable’s built-in dynamic filtering, but in my opinion, the much easier and more powerful way of doing this is to use Fillout’s advanced forms for Airtable, which gives you better control over filtering linked record fields.
Fillout is 100% free and offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update Airtable records from a form, display Airtable lookup fields & Airtable rollup fields & Airtable attachments & formulas on forms, dynamically & conditionally filter linked record fields by any values that you would like, perform math or other live calculations on your forms, accept payments on forms, create multi-page forms with conditional paths, create new linked records on a form, display as many fields as you want to see in a linked record selection list (including attachments), connect a single form to dozens of external apps simultaneously, limit the number of linked records that can be chosen, set advanced field validations & limitations, upload an unlimited amount of attachments simultaneously, add CAPTCHAs to your form, add choice matrixes to your forms, direct integration with hundreds of apps like Calendly & Google Maps on your forms, and so much more.
— ScottWorld, Expert Airtable Consultant
Jul 23, 2024 07:11 PM
Hi,
Thank you. But I can't see the filter option in single select field for dynamic filter 🥲.
Jul 23, 2024 07:41 PM
Try converting "Budget Cycle" to a linked field to a new table?
Jul 24, 2024 12:16 AM
Hello,
I did use Fillout for a project after reading one of your post and it is indeed a great tool for designing forms. This being said, I ended up doing the same process, ie replecating the "Cycle" field in the above example and showing field A, B or C depending on user's property selection.
Did I miss something with Fillout?
Thanks
Pascal
Jul 24, 2024 01:07 AM
You would need to switch to linked record fields to get dynamic record selections. Otherwise, your method works fine, too!