question Re: auto populate values based on another field value in ServiceNow AI Platform forum

auto populate values based on another field value

Community Alums — Wed, 13 Sep 2017 03:42:23 GMT

I have a field which is referenced to "sys_user" table . If i select a value from user table then value of some other fields populate automatically . Below are the fields

Do i need to Business rule or client script to archive this ? How

Re: auto populate values based on another field value

prasadh — Wed, 13 Sep 2017 04:02:39 GMT

Hi Dinesh,

You can achieve this using scripting. You can use dot walking also.

Dot Walking: Dot-Walking - ServiceNow Wiki

Thanks,

Prasad

Re: auto populate values based on another field value

shrutityagi — Wed, 13 Sep 2017 04:55:12 GMT

Hi Dinesh,

I would recommend to use OnChange client script to auto populate these values on the basis of requested for field.

http://wiki.servicenow.com/index.php?title=Client_Scripts#onChange.28.29_Scripts

http://wiki.servicenow.com/index.php?title=GlideForm_(g_form)#setValue

Take example of OOB client script '(BP) Set Location to User' that sets location on the basis of caller:

https://your_instance.service-now.com/sys_script_client.do?sys_id=5e524025c0a80166004d1761e85e2058

Thanks

Shruti

If the reply was informational, please like, mark as helpful or mark as correct!

Re: auto populate values based on another field value

hvrdhn88 — Wed, 13 Sep 2017 05:02:38 GMT

Hi Dinesh,

Please try with script below.

function onChange(control, oldValue, newValue, isLoading) {

var caller = g_form.getReference('caller_id', doAlert); // doAlert is our callback function

}

function doAlert(caller) { //reference is passed into callback as first arguments

g_form.setValue('email',caller.email);

g_form.setValue('phone',caller.mobile_phone);

g_form.setValue('phone',caller.location);

}

Please change the variable name that you have exactly on your catalog form.

Re: auto populate values based on another field value

hvrdhn88 — Wed, 13 Sep 2017 05:37:19 GMT

Hi Dinesh,

please check with below updated script i tested and it's working.

Re: auto populate values based on another field value

Community Alums — Wed, 13 Sep 2017 13:28:02 GMT

Hi Harshvardhan , Thanks mate , its working . Cheers Regards, Dinesh

Re: auto populate values based on another field value

Sudhanva — Thu, 02 May 2019 08:07:42 GMT

Hi Harsh,

I need to know why variable caller got created?

Re: auto populate values based on another field value

Nitin Baijal — Tue, 20 Dec 2022 20:16:21 GMT

Hi Harsh,

When I try this, i just get the sys ID 3beaa790dbf9649045c73ce3399619c5 instead of the value 😞

what am I missing?

my problem statement is -

update mailbox owner (we have 4 different mailboxes )

(Based on a choice for these mailboxes, i display the selected mailbox)

The user should be allowed to select any active mailbox from any mailbox collection.

The previous user should be should on the screen when a mailbox is selected ("Current Owner" field, protected).

Re: auto populate values based on another field value

Nitin Baijal — Wed, 21 Dec 2022 02:42:24 GMT

I think i found the answer by changing the variable type to reference from single text and mapping it with the table you want the value of. In my case it was user table.

Re: auto populate values based on another field value

jyoti5 — Wed, 18 Jan 2023 11:50:30 GMT

Above script is working.. Thank you!

Re: auto populate values based on another field value

NAIDILE S — Fri, 10 Nov 2023 07:40:01 GMT

Hi @hvrdhn88
I have one requirement, where I have 'LIST' field and i want to populate the values of parent field's irm domain into the new record of irm domain. and also say while creating a new record i have already field the irm domain and later when i fill parent field it should populate the parent's irm doamin keeping the old once as well (old value + populated value) ,
How can i do this can u help me with this