Hello,
I am looking to concatenate my address, city, state, zipcode columns and then turn that concatenated column into a location column. Is there an app that can help with this? I do not know of a way to turn the Formula column into another column type and you cannot copy the formula column information into another column.
Thanks,
Charlie
Hi @Charlie_F - in order to update the location column in monday you need the geographic coordinates.
We have completed these kinds of updates in the past for clients through a simple make.com script utilizing the Google Maps module, passing in the street address, city, state, zip. The coordinates are returned which can be updated back in monday to populate the location column:
This is something we can assist with or offer additional guidence.
Feel free to reach out any time!
Mark
Hello, thanks for sharing. But, this is to only update a specific item, correct? This does not update an entire column, right? This would require some type of array logic.
Hey @Charlie_F - it depends on how you want it handled. Is it a one-time update for all items on a board or should it be triggered as needed? Either situation can be managed via make.com easily.
Mark
It’s a one time action. So the 4 columns would populate the Location 1 column via the make.com automation for each item
@Charlie_F You could just loop through all the items on the board via make.com (List Board Items) and have it update the location column for each.
The other option is to set a webhook on the board (on status change), when you change the status it triggers the make scenario to update that row.
Thanks!
Mark
Hi there! You can easily concatenate your address, city, state, and zipcode columns in Excel using the CONCATENATE function or the & operator. Here’s a quick formula you can use: compass dollar tree
=A2 & ", " & B2 & ", " & C2 & " " & D2
This will combine the values from columns A, B, C, and D into a single location column. After that, you can copy the concatenated results and use “Paste Special” to paste them as values into a new column.
If you’re looking for an app, Excel or Google Sheets are great tools for this task.
Best Regards,
James Henry