[Resolved] Latitude & Longitude Fields

[Author]

Posts

[afrielY]

I have this same question (https://toolset.com/forums/topic/latitude-longitude-fields/)

A Support member has suggested using save_post hook to store the lat/lon coordinates.

But I couldn't any way to Latitude & Longitude. It is on text field (name attribute) called "toolset-extended-form-wpcf[test-google-map-address-01][latitude]" & "toolset-extended-form-wpcf[test-google-map-address-01][longitude]"

But I don't know how to access it from inside save_post or whatever suitable hook. Could you help me?

[Shane]

Hi Afriel,

I'm a bit unsure what you want to achieve.

Is it that you want to be able to store the longitude and latitude in a field ?

Please let me know.
Thanks,
Shane

[afrielY]

Yes, I want to store the longitude and latitude in two custom field in the database.

[Shane]

Hi Afriel,

The best thing you can do is to create 2 single line fields, one for Longitude and one for Latitude.

You can also use these fields to populate the map as well if you choose to do so.

Thanks,
Shane

[afrielY]

Sorry Shane, I didn't understand, You mean create 2 fields and manually add Latitude & Longitude? I am just looking way to save Latitude & Longitude in the database when publish/update the post. Currently, toolset saved only the location address/

[Shane]

Afriel,

The Latitude & Longitude values are being stored in the database but not as post meta. They will need to be retrieved from the wp_options table which would require a manual query.

The better option is to store your Latitude & Longitude as separate custom meta from the address itself so you can retrieve the values like regular custom fields.

"You mean create 2 fields and manually add Latitude & Longitude?"

Essentially yes thats what i'm saying.

Thanks,
Shane

[afrielY]

---------------------
"You mean create 2 fields and manually add Latitude & Longitude?"

Essentially yes thats what i'm saying.
---------------------

Is there any way to make automatic it? It is little time-consuming work to manually copy/paste Latitude & Longitude each time when updating post.

[Shane]

Hi Afriel,

It is possible to do it with JS manipulation, however is it that you want the values to be stored in separate fields?

Reason is because we can get the value of the data-coordinates attribute from the address. We will get the value as you see it in my screenshot.

Would you want them to be separated and then added to the longitude and latitude field ?

Please let me know.
Thanks,
Shane

[afrielY]

Thanks Shane. I created two toolset custom fields called "wpcf-latitude" and "wpcf-longitude". I am trying to store those values on "wpcf-latitude" and "wpcf-longitude". Could you give a help to store them? Any sample code or link is much appreciated.

[Shane]

Hi Afriel,

Ok so I came up with a solution for this using Javascript.

You will need to install the plugin plugin here
https://wordpress.org/plugins/custom-css-js/

Then add a new JS custom js and set the "Where in site" option to "In Admin". Finally add the following to the editor and save it.

jQuery(".editor-post-publish-button").click(function() {
  var cords = jQuery("input[name='wpcf[address]']").attr("data-coordinates");
  var splitcords = cords.split(',');
  jQuery("input[name='wpcf[latitude]']").val(splitcords[0].replace("{",""));
    jQuery("input[name='wpcf[longitude]']").val(splitcords[1].replace("}",""));

});

Note you will need to replace "wpcf[address]" with the appropriate value. Lets say your field is called "Location" then the slug will be "wpcf-location". To add this to the code it will become "wpcf[location]"

I bind the code to the update button on the post, so it will fire when the button is clicked.

Please let me know if this helps.
Thanks,
Shane