Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.
Mar 23, 2022 01:48 AM
Hello, I have a table that consist of region, and city, I would like to group the city by their respective region automatically, As i don’t have a proper idea how to do it. Should i go for automations or by airtable script?
Nov 26, 2022 07:06 AM
Hello @Marc_Justin_Rait ,
To group the cities by region automatically, you may create a new view Groups by region, then use the Group by field function and select the field Region. Every time you will input the city and the region, it will automatically group the cities by their respective region.
Initial view :
In the view Groups by Region, you will see this :
To learn more about the function, feel free to check this illustrated article :
https://support.airtable.com/docs/guide-to-grouped-records
I hope that helps :slightly_smiling_face: