Group by Field Value Automation or By Script

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?

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 :

image

In the view Groups by Region, you will see this :

image

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 :slight_smile: