Skip to main content

Hierarchial multi-select option creation for territories

  • September 18, 2023
  • 0 replies
  • 7 views

Forum|alt.badge.img+2

Hi! I'm working on a project for collating legal contracts and their details. The contract covers different territories, so I need a good way to represent territory data in an airtable column.

Our contracts sometimes combine different countries into different groupings such as 'Latin America' or 'Caribbean Islands', etc. While I don't need to get too granular, I would like to at least divide the territories based on Continent for easy data entry. Ideally selecting a continent will select all the countries in that continent as well. 

What I want essentially looks something like the below screenshot, but I am not sure if this can be implemented on Airtable directly or not.

I wonder if I could integrate airtable with some other software? or add some extension? or if there is some creative script or formula that could implement this?
Any advice is appreciated.