Set timezone based on user location
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-08-2022 08:36 AM
Hello folks,
Is there any way to set the time zone in user table based on the location. Any thoughts on this.
(When a new user is created, I want to set time zone based on the location selected. Is there any way to find the related time zone based on location.)
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-08-2022 08:51 AM - edited 11-08-2022 08:56 AM
On the location table, there is a time zone field. Populate that
Then just create a business rule or flow on the sys_user table to set the time zone in the user profile equal to time zone on location
Sample BR:
current.time_zone = current.location.time_zone;
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-24-2022 02:25 AM
OOTB all time zones are empty for location table. How to populate time zones for all locations.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-24-2022 02:27 AM
OOTB there is a BR which is populating Latitude and Longitude. Is there any way to populate time zones similarly.
We can use GOOGLE API, but it involves costing.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-24-2022 02:27 AM
You first need to understand how are you loading the users in sys_user? Are you using LDAP for this?
What's the process?
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader