Need to populate all fields in single field type HTML line by line when insert or update record

[Brahmi Pandla]

Hi

I have requirement   populate all fields data into single field type HTML when the record insert or update

For example I have category, subcategory, description fields  and need populate all fields into  artilcle body(html type) field like below shown

Category : Hardware

subcategory: CPU

Description: This is hardware issue

[Peter Bodelier · Accepted solution]

Hi @Brahmi Pandla,

You could use something like this, depending on where you where planning of using it of course:

var body = '';

body += '<p>Category: ' + current.getDisplayValue('category') + '</p>';
body += '<p>Subcategory: ' + current.getDisplayValue('subcategory') + '</p>';
body += '<p>Description: ' + current.getDisplayValue('description') + '</p>';

current.body = body;

Edit: Adjusted to show the right answer.

[Peter Bodelier · Accepted solution]

Hi @Brahmi Pandla,

Just tested it. Seems that </br> get removed.

It works like this:

var body = '';

body += '<p>Category: ' + current.getDisplayValue('category') + '</p>';
body += '<p>Subcategory: ' + current.getDisplayValue('subcategory') + '</p>';
body += '<p>Description: ' + current.getDisplayValue('description') + '</p>';

current.body = body;

[Brahmi Pandla]

Hello Peter,

Could you please help on above query  Thanks

[Peter Bodelier · Accepted solution]

Hi @Brahmi Pandla,

Did you try the last script I provided?

It's working as expected for me.

var body = '';
if (current.getDisplayValue('category')){
body += '<p>Category: ' + current.getDisplayValue('category') + '</p>';
}
if (current.getDisplayValue('subcategory')){
body += '<p>Subcategory: ' + current.getDisplayValue('subcategory') + '</p>';
}
if (current.getDisplayValue('description')){
body += '<p>Description: ' + current.getDisplayValue('description') + '</p>';
}

current.body = body;

[Brahmi Pandla]

Yes Peter I tried same script  getting like below

Category: Hardware

Subcategory:

Description: This is hardware issue

[Brahmi Pandla]

Hello peter

The below is used script

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

    var body = '';

    body += '<p>Regulators and Enforcement Priorities: ' + current.getDisplayValue('reg_en_prior') + '</p>';

    body += '<p>Key data privacy laws and regulations: ' + current.getDisplayValue('kd_prilaw_reg') + '</p>';

body += '<p>Territorial Scope: '  +current.getDisplayValue('territorial_scope') + '</p>';

    current.article_body = body;

    current.update();

})(current, previous);

[Peter Bodelier]

Ah, but that is very different from what I provided...

(function executeRule(current, previous /*null when async*/ ) {
    var body = '';
if(current.getDisplayValue('reg_en_prior')){
    body += '<p>Regulators and Enforcement Priorities: ' + current.getDisplayValue('reg_en_prior') + '</p>';
}
if(current.getDisplayValue('kd_prilaw_reg')){
    body += '<p>Key data privacy laws and regulations: ' + current.getDisplayValue('kd_prilaw_reg') + '</p>';
}
if(current.getDisplayValue('territorial_scope')){
body += '<p>Territorial Scope: '  +current.getDisplayValue('territorial_scope') + '</p>';
}
    current.article_body = body;
    current.update();
 
})(current, previous);