Auto-convert Text Column to Location for Map View

Hi there! I have a board with a column that stores the city each person is from, but it’s currently set as text. I’d like to display these entries on a map, so I need this column to be in a location format instead.

However, I can’t change the original column type because it’s used in another automation. What I’m looking for is a way to automatically convert the text from the “City” column into a location field whenever a new item is added to the board.

3 replies