Get a first look at what's coming. The Developer Passport Australia Release Preview kicks off March 12. Dive in! 

Get Latitude Longitude on contact/user table

RenukaV_Extprz
Tera Contributor

Hello Team,

How can I fetch the Latitude Longitude on user table.

Can you help me with the complete steps to achieve this.

Also once I get the Latitude Longitude on the user table, I need to fetch the 3 nearest locations from the contact's location.

Thank you in advance.

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron

@RenukaV_Extprz 

those 2 fields are not auto-populated by instance.

Those fields are used in Field Service Management when field agent works on field.

If you want to populate those then check this link

Get Current Latitude Longitude 

Also if you want to set it based on User's location using the location field then check this link

To get latitude, longitude,timezone and UTC offset on the basis of location address 

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
Certified Technical Architect  ||  10x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

11 REPLIES 11

Ankur Bawiskar
Tera Patron

@RenukaV_Extprz 

those 2 fields are not auto-populated by instance.

Those fields are used in Field Service Management when field agent works on field.

If you want to populate those then check this link

Get Current Latitude Longitude 

Also if you want to set it based on User's location using the location field then check this link

To get latitude, longitude,timezone and UTC offset on the basis of location address 

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
Certified Technical Architect  ||  10x ServiceNow MVP  ||  ServiceNow Community Leader

@RenukaV_Extprz 

Hope you are doing good.

Did my reply answer your question?

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
Certified Technical Architect  ||  10x ServiceNow MVP  ||  ServiceNow Community Leader

Hi @Ankur Bawiskar ,

Yes, I am getting the Latitude Longitude on cmn_location table, but not getting on user table.

@RenukaV_Extprz 

so you can copy that on sys_user record associated to that location.

where are you stuck?

what did you try so far?

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
Certified Technical Architect  ||  10x ServiceNow MVP  ||  ServiceNow Community Leader