Unfortunately, that is not natively possible with Airtable.
You would need to set that up with an external portal tool, such as Noloco or Fillout. These are the only 2 apps that I currently know of that offer this functionality for Airtable.
Noloco is a powerful portal, and Fillout is free and offers the world’s most advanced forms for Airtable, including the dynamic/conditional dropdowns that you’re looking for.
I gave a brief tutorial of Noloco on this episode of the BuiltOnAir podcast. And I also presented a full one-hour webinar on Noloco called Building a Client Portal on Noloco powered by Airtable.
I gave a brief demo of Fillout on this episode of the BuiltOnAir Podcast.
p.s. If you have 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