how to script rows and columns for records in an email script?

patricksmithlat
Mega Contributor

Hi community,

I'm trying to create an email script that takes records received from a GlideRecord and shows a couple fields from the record in an email.  I can get the info, but formatting script so it looks right is proving to be challenging.  Here's my script:

 

find_real_file.png

 

and here's what it looks like in the email

find_real_file.png

 

what i want is a nice table look with columns that have "Number", "State", and "Summary" going horizontal, with the appropriate values shown beneath...kind of like a spreadsheet view, or even a typical ServiceNow list view.  

any help would be great...thanks!

1 ACCEPTED SOLUTION

Archana Reddy2
Tera Guru

Sure. Here it is,

find_real_file.png

 

find_real_file.png

Thanks

View solution in original post

9 REPLIES 9

patricksmithlat
Mega Contributor

thanks so much everyone!  All the input was very helpful...after tinkering with the suggestions I got what I was looking for with the script below.  I also needed to accommodate for 2 different ticket types...worked perfectly!

 

find_real_file.png

 

find_real_file.png

Glad you got it. Please mark the answer as Correct so that this thread will be removed from Unsolved questions of Community.

Thanks,

Archana

Hi Archana,

I don't see how to mark my own answer correct...if you'd like to copy and paste my solution and reply, I'll mark your message correct.  thanks again!

Archana Reddy2
Tera Guru

Sure. Here it is,

find_real_file.png

 

find_real_file.png

Thanks

Hi Archana,

I found this very helpful and have used this for my requirement and it's working fine.

Thanks

Srini