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

Brahmi Pandla
Tera Guru

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

 

 

3 ACCEPTED SOLUTIONS

Peter Bodelier
Giga Sage

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.


Help others to find a correct solution by marking the appropriate response as accepted solution and helpful.

View solution in original post

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;

Help others to find a correct solution by marking the appropriate response as accepted solution and helpful.

View solution in original post

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;

Help others to find a correct solution by marking the appropriate response as accepted solution and helpful.

View solution in original post

15 REPLIES 15

Vishal Birajdar
Giga Sage

Hi @Brahmi Pandla 

 

Can you let us know, on which table these Category, subcategory and description field OR these fields are on KB article table.?

 

 

 

Vishal Birajdar
ServiceNow Developer

I know one thing, and that is that I know nothing.
- Socrates

Hi Vishal,

 

For example, purpose I given those name randomly.

Peter Bodelier
Giga Sage

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.


Help others to find a correct solution by marking the appropriate response as accepted solution and helpful.

Brahmi Pandla
Tera Guru

Hi Peter,

 

Thanks for responding, is it not working getting same line as below.

 

Regulators and Enforcement Priorities: testing5678piuuKey data privacy laws and regulations: testing1234