Selector multi-conditional

I think I figured out a hacky methodology for this inside Airtable, but just for the record this would probably be infinitely easier using Zite/Fillout Forms… Anyhow, on to the wonkiness…

What I came up with to solve for this is using one additional table (I called it Project Terms) where I copied in your screenshot above. Then I create three linked record fields to that table, one for each term level (Approval, Lifecycle, and Operational). Using the fairly new option to show Display Names instead of Primary Field, I set each of those linked record fields to focus on it’s specific term. Then I added a lookup field for the Approval lrf and the Lifecycle lrf (these are necessary to grab the terms). Finally I added dynamic conditions to the Lifecycle and Operational lrfs, so it limits the selectable options. Specifically for the Lifecycle lrf I filtered record selection by condition where “Approval” in the Project Terms table= “Approval Lookup” field. For Operational you need to do double conditions. 

I just put this together so some tweaks are probably necessary, and maybe I’m missing something, but would this get at what you’re trying to do?

EDIT: And I just realized the problem, you’re using a form wherein all the data flows in together. This would work for an interface where users are editing the record, but not as a one shot data entry for a form submission. Airtable won’t apply the dynamic filtering logic until after it’s submitted. Tbh Fillout is the way. I’m leaving this up though because someone might find it an interesting application 🤷‍♂️

​@luismi 

As ​@DisraeliGears01 mentioned above, the only way to do this is to use linked record fields.

As he mentioned above, if you stick with Airtable’s forms, you can use Airtable’s dynamic filtering feature to set this up. 

However, as ​@DisraeliGears01 also mentioned, it is significantly easier to use Fillout’s advanced Airtable forms for this.

With Fillout, you can use their feature to select and filter Airtable linked records in a dropdown, which is significantly easier to setup than Airtable’s filtering feature.

Fillout is 100% free and it also offers hundreds of advanced features that you can’t get with Airtable’s forms, such as the ability to update Airtable records with a form, along with hundreds of other advanced features.

Hope this helps!

If you have a budget and you’d like to hire the best Airtable consultant to help you with this or anything else that is Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

Thanks @DisraeliGears01 and @ScottWorld for the info and help. I’ll give dynamic filtering a try—I can see (at least in my head) how I might be able to make it work or adapt it to the process here.