Help

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.

Group by Field Value Automation or By Script

Topic Labels: Automations
285 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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?

1 Reply 1

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