How to get reference field values in another field.

[shravani6]

On the catalog request form, I have 3 reference fields and those fields' values should display in the 4th field with (,) comma-separated and 4th filed is a single-line text.

also tried this catalog client script it is displaying sys_id in the 4th field.

[Jaspal Singh]

Can you use

var avzone1=g_form.getDisplayBox('subnet_1_av_zone').value;

var avzone2=g_form.getDisplayBox('subnet_2_av_zone').value;

var avzone3=g_form.getDisplayBox('subnet_3_av_zone').value;

Also, ensure Isolate script (not available on Form OOB but can be added or edited from List Layout) field on the Client script is set to True. 

[RaghavSh · Accepted solution]

Try:

g_form.getDisplayBox('variable_name').value instead of g_form.getValue

[Ankur Bawiskar]

@shravani 

this should work in both native and portal

    if(window == null){
		var avzone1 = g_form.getDisplayValue('subnet_1_av_zone');
        var avzone2 = g_form.getDisplayValue('subnet_2_av_zone');
        var avzone3 = g_form.getDisplayValue('subnet_3_av_zone');
		var zone = 	avzone1 + "," + avzone2 + "," + avzone3;
        g_form.setValue('subnet_availability_zone', zone);
	}
	else{
		var avzone1 = g_form.getDisplayBox('subnet_1_av_zone').value;
        var avzone2 = g_form.getDisplayBox('subnet_2_av_zone').value;
        var avzone3 = g_form.getDisplayBox('subnet_3_av_zone').value;
        var zone = 	avzone1 + "," + avzone2 + "," + avzone3;
        g_form.setValue('subnet_availability_zone', zone);		
	}

Regards
Ankur

[shravani6]

Thanks, Ankur it is working as expected.