question How to add the timezone to Service Catalog? in ServiceNow AI Platform forum

How to add the timezone to Service Catalog?

Byron Plant — Mon, 04 Apr 2022 17:32:20 GMT

Hi everyone,

I am trying to add the timezone field from the user table going to our Service Catalog, but I am not sure how exactly I should reference the timezone?

Please refer to the screenshot below. I need all the timezone that is available on the user table to be also available in our Service Catalog.

Re: How to add the timezone to Service Catalog?

sachin_namjoshi — Mon, 04 Apr 2022 18:10:20 GMT

You can configure a reference variable like below for your catalog item

Regards,

Sachin

Re: How to add the timezone to Service Catalog?

OlaN — Mon, 04 Apr 2022 18:12:12 GMT

Hi,

Create a variable that is a reference to the sys_choice table, and a reference qualifier with at least:
element = time_zone
inactive = false

Re: How to add the timezone to Service Catalog?

Byron Plant — Tue, 05 Apr 2022 13:35:13 GMT

Hi @sachin.namjoshi thank you so much for answering my question. I tried doing your solution but it did not provide me the same time zone options compared to what we have in sys_user table. See screenshot below

Re: How to add the timezone to Service Catalog?

sachin_namjoshi — Tue, 05 Apr 2022 15:45:00 GMT

@Byron Plant This means you don't have sys_user records with all these timezones. If you still want to provide all available timezone options, then solution provided by @OlaN will work.

Regards,

Sachin

Re: How to add the timezone to Service Catalog?

Byron Plant — Tue, 05 Apr 2022 16:43:45 GMT

Hi @OlaN thank you so much for answering my question, however the solution you provided did not work. As you can see in my screenshot below, we only have 28 timezones available but when I did your configuration, the outcome provided more than 28 timezone

Re: How to add the timezone to Service Catalog?

OlaN — Tue, 05 Apr 2022 19:44:56 GMT

Looked at it in more detail, and I would suggest that you add additional filters to narrow the results.

Try these:

language = en

sequence > 0

Re: How to add the timezone to Service Catalog?

Byron Plant — Wed, 06 Apr 2022 20:16:22 GMT

Hi @OlaN thank you, I was able to find the correct filter. I have another question though is there a way I can to auto populate the user's timezone from the sys_user table to the timezone field of Service Catalog?

As you can see in the image, the default timezone of Annabelle Coger in sys_user table is America/Los_Angeles. If she creates a request in a Catalog Item, the "Please select your timezone" field must auto populate to America/Los_Angeles timezone as well.

Re: How to add the timezone to Service Catalog?

Byron Plant — Wed, 06 Apr 2022 20:20:37 GMT

Hi @sachin.namjoshi

I have another question though is there a way I can to auto populate the user's timezone from the sys_user table to the timezone field of Service Catalog?

Re: How to add the timezone to Service Catalog?

sachin_namjoshi — Wed, 06 Apr 2022 20:54:45 GMT

yes, you can configure a on load client script, glide ajax for your catalog item to set default value of timezone from sys_user record.

Regards,

Sachin

Re: How to add the timezone to Service Catalog?

Hitoshi Ozawa — Thu, 07 Apr 2022 00:17:48 GMT

Give OlaN the credit because this is a different question.

To set the default timezone, set the default value as follows:

javascript:  gs.getSession().getTimeZoneName();

Re: How to add the timezone to Service Catalog?

OlaN — Thu, 07 Apr 2022 06:10:58 GMT

Just like Hitoshi said, this is an entirely different question, and you have been given two possible solutions, to answer that one.

Please close this thread by marking my (previous) answer as correct, as it will help future readers find a correct answer to their questions.

Re: How to add the timezone to Service Catalog?

Byron Plant — Thu, 07 Apr 2022 17:54:08 GMT

Thank you so much everyone for helping me with my questions @sachin.namjoshi @OlaN and @Hitoshi Ozawa