question Re: How to set default value for a reference field on Catalog Item in Developer forum

How to set default value for a reference field on Catalog Item

depa — Thu, 09 Jul 2020 12:32:59 GMT

Hi,

i have a reference field service and it has always one record. My question is how can i preselect this value so as a default value on the portal? That i dont need to select it always?

Update: Its not a static value.

Thanks for your help.

Re: How to set default value for a reference field on Catalog Item

Dhananjay Pawar — Thu, 09 Jul 2020 12:37:15 GMT

Hi,

Open that reference variable and set default value there.

Check attached screenshot.

Thanks,

Dhananjay.

Re: How to set default value for a reference field on Catalog Item

Ashley Snyder1 — Thu, 09 Jul 2020 12:38:24 GMT

There should be a Default tab on the variable, you should be able to place the sys_id in that tab for it to find the correct record if you're always defaulting to a static value, if that value changes you can call a script include in that field by using something like javascript: [YOUR SCRIPT INCLUDE HERE]

Re: How to set default value for a reference field on Catalog Item

depa — Thu, 09 Jul 2020 12:44:16 GMT

Thanks for reply, this is not a static value.

Re: How to set default value for a reference field on Catalog Item

depa — Thu, 09 Jul 2020 12:45:29 GMT

Thanks for your reply, this is not a static value. Thats why i asked iam new and dunno the code to preselect the record.

Re: How to set default value for a reference field on Catalog Item

Allen Andreas — Thu, 09 Jul 2020 12:49:20 GMT

Hello,

Based on your reply to others...I'm a bit confused.

You are saying this is not a static value, correct? Then what is the filter condition on this reference field to result in only one value showing, dynamically? Which is what sounds like is going on here.

We can't really give you much more help or a script (because you're new...) without more information as to how this field is being dynamically set anyway. Because however it's being set, you really could just use that same logic/script (if applicable) to set the default value instead of just only filtering it to one result. You could do both.

So let's start there...?

Please mark reply as Helpful/Correct, if applicable. Thanks!

Re: How to set default value for a reference field on Catalog Item

Dhananjay Pawar — Thu, 09 Jul 2020 12:52:09 GMT

Hi,

If not static then what value you want to set there.

What is your business requirement?

Re: How to set default value for a reference field on Catalog Item

Ankur Bawiskar — Thu, 09 Jul 2020 12:53:44 GMT

Hi Depa,

Are you saying the table being referred has only 1 value always & you want that to be auto populated?

Regards
Ankur

Re: How to set default value for a reference field on Catalog Item

depa — Thu, 09 Jul 2020 12:57:58 GMT

@Ankur Bawiskar

yes you are right.

Re: How to set default value for a reference field on Catalog Item

Ankur Bawiskar — Thu, 09 Jul 2020 13:05:39 GMT

Hi Depa,

use this then in the default value section

Note: I assume there is only 1 record in that table

Give your table name in the query of GlideRecord

javascript: getValue(); function getValue(){var gr = new GlideRecord('your_table_name'); gr.query(); if(gr.next()){return gr.sys_id;}}

Regards
Ankur

Re: How to set default value for a reference field on Catalog Item

Randall Arnold — Tue, 20 Oct 2020 15:38:00 GMT

I tried that approach: the sys_id never populates in my reference variable...

Re: How to set default value for a reference field on Catalog Item

TT3 — Fri, 09 Apr 2021 02:56:35 GMT

How to get logged in user detail?

Re: How to set default value for a reference field on Catalog Item

Murthy Ch — Fri, 09 Apr 2021 03:37:44 GMT

Hi @TT

write this script to get loggedin user details:

javascript:gs.getUserID();

Thanks

Re: How to set default value for a reference field on Catalog Item

Lucas3594 — Fri, 08 Jul 2022 11:12:32 GMT

Hello @Ankur Bawiskar

This is exactly what I need aswell, however I get the 'invalid function definition' error.

Do you have any idea what this could be?

I'm on Rome by the way.

Thank you so much

Re: How to set default value for a reference field on Catalog Item

AJ2025 — Tue, 28 Jan 2025 20:04:41 GMT

This is exactly what I was looking for... if a sys_id could be used... and it worked very well for me. You don't need quotes surrounding sys_id either.