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

[jennv]

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? 

[Collin Romeijn]

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

[jennv]

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

........

[Sandeep Rajput]

@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. 

[jennv]

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)