question how to auto populate (dot-walked fields in the table) variables in form in Employee Slate and Employee Center forum

how to auto populate (dot-walked fields in the table) variables in form

jennv — Mon, 23 Sep 2024 12:49:07 GMT

hey everyone,

i have a catalog client script where i autopopulate the fields, based on some conditions. i will do for example

g_form.setValue('notesVariable', myTableGlideRecord.notes);

but in my table i have a dot walked field and dont know what to do in this case. i tried g_form.setValue('requestorsEmail', myTableGlideRecord.requestor.email);

or in another case the field in my table would be company.supplier.product

How to do set field in this case?

Re: how to auto populate (dot-walked fields in the table) variables in form

Collin Romeijn — Mon, 23 Sep 2024 13:29:36 GMT

Hi jennv,

The dotwalk "company.supplier.product" is that from the ".requestor" related field ?

If so, then in most cases you can just use g_form.setValue('FIELDNAME', myTableGLideRecord.requestor.company.supplier.product); But to dotwalk the fields need to be reference fields. The last value you want to get can be any types of fields.

In some cases its beter to first use something like var xx = g_form.getValue('Full dotwalkstring); and then use the variable to set a value.

Let me know if this helps, if not please provide more info about the script in total.

Kind Regards,

Collin

Re: how to auto populate (dot-walked fields in the table) variables in form

jennv — Mon, 23 Sep 2024 13:45:04 GMT

Hi Cloin, thank you for your fast answer... Thats what i did but doesnt work.

let me give you more info :

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

if (isLoading || newValue == '') {

return;

}

var rda = g_form.getValue('scegli_la_riga_che_vuoi_duplicare');

var prlGR = new GlideRecord('sn_shop_purchase_line');

prlGR.addQuery('sys_id', rda);

prlGR.query(prlResponse);

function prlResponse(prlGR) {

while (prlGR.next()) {

g_form.setValue('u_priority', prlGR.u_priority); //this and other fields like this work

g_form.setValue('u_categoria_3_livello', prlGR.supplier_product.product_category); //these dont work

........

Re: how to auto populate (dot-walked fields in the table) variables in form

jennv — Mon, 23 Sep 2024 14:57:57 GMT

ok i think i understood better what you are saying , and no, im not trying to do that. the field i want to dot walk, is not in the form, but in a table, in the same table that this record producer submits the form. for context: i have a variable : do you want to duplicate an existing record?

if yes, another variable is shown : choose the record you want to duplicate.
here i do a gliderecord, query on the record that end user chose, and i get each field in the table (existing record that user chose) and fill the variables in the form with those values. I hope I was clear. (Im replying for the second time, sorry my replies are taking too long to get approved)

Re: how to auto populate (dot-walked fields in the table) variables in form

Sandeep Rajput — Mon, 23 Sep 2024 16:11:51 GMT

@jennv Instead of using a client script. You can use the Auto populate feature available on variable form in Service Catalog. For more information please refer to the blog https://www.servicenow.com/community/developer-articles/auto-populate-a-variable-based-on-a-reference-type-variable-utah/ta-p/2475511

Hope this helps.

Re: how to auto populate (dot-walked fields in the table) variables in form

Sandeep Rajput — Tue, 24 Sep 2024 02:41:06 GMT

@jennv

g_form.setValue('u_categoria_3_livello', prlGR.supplier_product.product_category); //these dont work

This multi-level dot walking won't work in client script. If your really want to extract this value then I recommend you to return this value from script include itself.

Re: how to auto populate (dot-walked fields in the table) variables in form

jennv — Tue, 01 Oct 2024 09:50:10 GMT

thank you very much for your answers, really appreciate it. I decided to use script include with glide ajax, as it seemed like the best approach.