What started as trying to figure out how to copy a Location field value has turned into a rabbit hole of effort. It seems, based on previous threads here, that we cannot copy values from Location fields.
For that reason, and the fact that I have to import a bunch of addresses from CSV, I have been using standard Text fields for addresses.
But, then I needed to map those addresses. So, I figured I’d create a Location field and populate it based on the value in the Text field. But this doesn’t work because of a field type mismatch.
Does anyone know of a solution for either or both of these issues?
How to copy a Location field value as text?
How to automate the copying of a text field address into a Location field?
This part is harder, since the text you have needs to be geocoded, and right now fibery only does that one by one, via the UI. So what you’d need to do is:
Geocode the addresses yourself.
Populate the geocoded json into the location fields in Fibery.
You could probably use the MapBox API within a Script block to do this, but I have never tried it myself. You need to make an account with MapBox and get an API key, but then theoretically itll be possible. Then you can have it even be automated. Note that it would just pick the first from the list, so you can’t be 100% sure it’s the right location, and not always do the addresses match up perfectly, but I think this approach would get 90% of the way there.
Curious what you end with. If you need a hand, feel free to reach out.