question Re: I want to map Question- Answer tables value with custom table fields in Developer forum

I want to map Question- Answer tables value with custom table fields

Supriya Waghmod — Tue, 09 Feb 2021 07:52:15 GMT

Requirement : I want to add the record producers variables to custom table(business case).

Approach : 1.Created a BR on insert -request

2. getting variables values from Question answer tables

Question: How to map name: value pair with custom tables fields ?

Below script: i have written to get variables values

Re: I want to map Question- Answer tables value with custom table fields

Sai Kumar B — Tue, 09 Feb 2021 08:38:58 GMT

You would like to map those values to another custom table other than the Record producer target table?

If yes then you can use the script section in Record producer, Glide to custom table map your record producer values to that custom table.

Sample Script:

var custom = new GlideRecord('custom_table');
custom.intialize();
custom.field_name1 = producer.variable-name1;
custom.insert();

Please mark my answer as helpful/correct, if applicable.

Best regards,

Sai Kumar

Re: I want to map Question- Answer tables value with custom table fields

Ankur Bawiskar — Tue, 09 Feb 2021 08:50:22 GMT

@Supriya Waghmode

No need to query the question_answer table

You can do it directly like this

(function executeRule(current, previous /*null when async*/) {

	// Add your code here

	var arr = [];
	var variables = current.variables.getElements();
	for (var i=0;i<variables.length;i++) {
		var question = variables[i].getQuestion();
		var label = question.getLabel();
		var value = question.getDisplayValue();
		if(label != '' && value != ''){
			var obj = {};
			obj[label] = value.toString();
			arr.push(obj);
		}
	}

	gs.info(JSON.stringify(arr));

})(current, previous);

Regards
Ankur

Re: I want to map Question- Answer tables value with custom table fields

Supriya Waghmod — Tue, 09 Feb 2021 10:32:27 GMT

1.How can I send the request number through this??

2.multiple values of array - to add one field

if(producer.aua==true){
arr.push("AUA").toStrin();
}
if(producer.eur==true){
arr.push("EUR").toString();
}
if(producer.soa==true){
arr.push("SOA").toString();
}
if(producer.noa==true){
arr.push("NOA").toString();
}
gs.log("TEST-SW"+arr);

need set att custome table field

Re: I want to map Question- Answer tables value with custom table fields

Ankur Bawiskar — Tue, 09 Feb 2021 11:14:06 GMT

@Supriya Waghmode

Did you get a chance to check the script I shared?

Regards
Ankur

Re: I want to map Question- Answer tables value with custom table fields

Supriya Waghmod — Tue, 09 Feb 2021 11:20:51 GMT

Thanks for reply.

Ankur I am trying another approach- scripting through producer

currently stuck @

1.How can I send the request number through this??

2.multiple values of array - to add one field

if(producer.aua==true){
arr.push("AUA").toString();
}
if(producer.eur==true){
arr.push("EUR").toString();
}
if(producer.soa==true){
arr.push("SOA").toString();
}
if(producer.noa==true){
arr.push("NOA").toString();
}
gs.log("TEST-SW"+arr);

need set att custome table field

Re: I want to map Question- Answer tables value with custom table fields

Ankur Bawiskar — Tue, 09 Feb 2021 12:04:37 GMT

Hi,

you are referring to record producer then it won't have any Request number

Can you explain your business use-case

I have already shared script on how to generate the JSON array of objects for the variables

Regards
Ankur

Re: I want to map Question- Answer tables value with custom table fields

Sai Kumar B — Tue, 09 Feb 2021 17:49:44 GMT

@Supriya Waghmode In Record producer post insert script you send number via current.number(current table request number), you have to use post insert script because number will be generated in target table upon insertion of the record.

Re: I want to map Question- Answer tables value with custom table fields

anirban300 — Tue, 31 Jan 2023 17:59:04 GMT

Hello Ankur,

Thank you for the code. It was indeed helpful. I want to ask one additional request in this if you could help me. If I want to make each Label and Value in new line then how can I do it?

Regards

Anirban

Re: I want to map Question- Answer tables value with custom table fields

Ankur Bawiskar — Wed, 01 Feb 2023 03:06:04 GMT

@anirban300

you can join the array with new line i.e. \n while setting the value in some field

but remember that field should support new line character