Profile: scottL-3

Problem:

We built partner records with separate single line text fields for street, city, state and zipcode (in repeating field groups for multiple locations per partner). We also have latitude and longitude fields for each location that represent the center of the zipcode but not sure we need those going forward.

We now want to use Toolset Maps to find and sort partners by distance. We don't necessarily need to show them on a map but may want to.

Can I just run an update query that adds a wpcf-partner-address postmeta row for each partner and assembles a # street, city, state zip code string to place in there from the separate existing fields?

Solution:

There isn't existed "update query" to achieve what you want, it needs custom codes.

And if there aren't too much record, you can just update the address field value manually.

Relevant Documentation:

https://toolset.com/documentation/customizing-sites-using-php/functions/#address