Pass Record Producer variables questions and answers to Description field

[Dazler]

Hi,

I have created a Record Producer form for our incident table.  They don't want the variable editor on the Incident form, so instead to retrieve the questions and answers I suggested we pass them into the description field.

I found this script and it sort of works.

var populatedList = '';
 
for (v in current.variables) { 
var question = current.variables[v].getQuestion(); 

if(question.getLabel() != '');
{
populatedList += question.getLabel() + ":" + question.getDisplayValue() + '\n';
}

}

But it is retrieving all the variables questions and answers, including those that are not answered and null fields.

Does anyone have a better script for this?

Any help would be appreciated.

[Dazler]

Hi @sachin.namjoshi

This script works, but with the some of my values are reference fields and are display at the sys_id.

Am I able to retrieve the display name or am I going to have to query the table to retrieve the display name of that sys_id?

[sachin_namjoshi]

If it's a referenced field to sys_user table, you just have to change one line in the code

var ciGR = new GlideRecord('sys_user');

Regards,

Sachin

[Anoja]

Hi,

current.description = 'Additional details : ' + producer.description +

'\n User ID: ' + producer.user_name.getDisplayValue() +

'\n Contact Info : ' + producer.u_call_back_number.getDisplayValue();

You can try this based on your requirement.

Thanks,

Anoja

[BiancaKerchhoff]

Thanks @Chekuri Anoja this was helpful. I just tweaked it slightly as per my fields.