How to auto populate time zone according to location in the user table ???

Kristina2
Tera Contributor

How to auto populate time zone according to location in the user table ???

8 REPLIES 8

Yeah . That's right


venkatiyer1
Giga Guru

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.


Thanks Venkat


venkatiyer1
Giga Guru

Great Sree. Hope it answered your question.