Need help in email script

[nameisnani]

Hi Team , 

can anyone please help me on this 

Daily we are doing ServiceNow health check up -  data will capture in a xls . 

we have created a custom table 

and once the record submitted we need trigger a notification 

we want to add coloring format based on the value selected for exmple - mid server down means Red color - 

if UP green color

like below 

please help me how to do this 

please provide me the configuration steps 

[GlideFather]

Hi @nameisnani,

that's quite a complex thing.

Please share what have you already done and we can discuss the next steps.

If you are about to start, I recommend to create the notification record - decide whether it will be trigger per new creation in the custom table or by firing an event (even would need to be fired by BR or Flow or something else).

Once you will have triggerable notification record, then create a email script where there will be lots of difficult coding to populate the template as you want.

Let me know about your progress and how does the first draft looks 

[nameisnani]

@GlideFather 

example 

I submitted the record with below values 

If Mid server down - I need box in red color 

If Mid Server Up - field box in green color 

@GlideFather 

How to do this please provide me the configuration screenshots 

[Ankur Bawiskar]

@nameisnani 

wherever you want color, there please use email script

In email script check the value is UP or DOWN and accordingly give the color and print using template.print()

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[nameisnani]

@Ankur Bawiskar  could you please provide me email script