How to auto populate time zone according to location in the user table ???
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-04-2016 11:41 AM
How to auto populate time zone according to location in the user table ???
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-04-2016 12:11 PM
Yeah . That's right
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-04-2016 12:25 PM
If that is a import table then you can populate the timezone while creating user by using transform maps. In transform map while field mapping map that time zone field of user.location.u_site.u_time_zone to sys_user timezone field.
Also you need to ensure the format of the incoming is same what is there in ServiceNow. If not you would need a onbefore script to transform the value accordingly.
That would ensure the timezone while creating the user. Even if the user were to change the value later it would update the value as long as you are not ignoring the row transformation on update. So by default it will update the value if new from source to target table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-04-2016 12:26 PM
Thanks Venkat
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-04-2016 01:05 PM
Great Sree. Hope it answered your question.