T
Twenty•4mo ago
El Odve

Access to addressLat and addressLng fields in the GUI?

I see these fields in the database, but I can't find any way to set these in the GUI. These fields would be great to use for creating a report of the geographical distribution of leads and sales. I can always populate these fields manually and/or through a batch job, but it would be great if I could set them through the GUI as well...
2 Replies
Prastoin
Prastoin•3mo ago
Hello there, What you're looking for is creating an address field metadata That's what you can find/set within one field metadata address 
    addressStreet1: '',
    addressStreet2: null,
    addressCity: null,
    addressState: null,
    addressCountry: null,
    addressPostcode: null,
    addressLat: null,
    addressLng: null,
    addressStreet1: '',
    addressStreet2: null,
    addressCity: null,
    addressState: null,
    addressCountry: null,
    addressPostcode: null,
    addressLat: null,
    addressLng: null,
El Odve
El OdveOP•3mo ago
Thanks @prastoin, but that's not quite what I was looking for. I want to be able to set addressLat and addressLon specifically in the GUI. For now (and this is probably easier for my purposes anyway) I've written a small python script that I run on the server that grabs all (optional only those with NULL values in lat/lon) addresses from the database, fetches lat/lon from the openstreetmap api and then updates lat/lon fields. Once these are set, I can easily grab this and use in my visuals (though the map visuals in PowerBI are fairly limited, at least without some creative joining of tables - but I can always use a proper GIS tool to fix this).

Did you find this page helpful?