This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Email sender - Change table row color based on value

Go to solution
SL12345
New Contributor III

‎10-05-2022 03:00 AM

Hi snaplogic experts,

is it possible to change table row in email body based on current value ? in my example i retrieve email with values - but is it possible to mark whole row as green, if revenue is higher as e.g. $5000?
just to make email readable

my example:

<!DOCTYPE html><html><head><style type="text/css"> </style></head>
<body>
<table>
<tr>
<th>Branch</th>
<th>City</th>
<th>Revenue</th>
</tr>
<tr>
<td>$branch</td>
<td>$city</td>
<td>$revenue</td>
</tr>
</table>
</body>
</html>

thank you

0 Kudos
Reply
1 ACCEPTED SOLUTION

Go to solution
bojanvelevski
Valued Contributor

‎10-05-2022 04:56 AM

Hi @SL12345,

Yes, it’s possible by using apache velocity.

I’m sharing a code I used in one of my pipelines. I believe you’ll be able to tweak it per your requirements:

<tr>
            <td>Actual Values</td>
            #foreach($key in $line.thresholds.keySet())
                #if($line.stats.get($key) > $line.thresholds.get($key))
            <td style="background:tomato">$line.stats.get($key)</td>
                #else
            <td>$line.stats.get($key)</td>
                #end
            #end
        </tr>

This one colors the background in red if a specific condition is fulfilled , if not, than no color is used.

View solution in original post

Reply
1 REPLY 1

Go to solution
bojanvelevski
Valued Contributor

‎10-05-2022 04:56 AM

Hi @SL12345,

Yes, it’s possible by using apache velocity.

I’m sharing a code I used in one of my pipelines. I believe you’ll be able to tweak it per your requirements:

<tr>
            <td>Actual Values</td>
            #foreach($key in $line.thresholds.keySet())
                #if($line.stats.get($key) > $line.thresholds.get($key))
            <td style="background:tomato">$line.stats.get($key)</td>
                #else
            <td>$line.stats.get($key)</td>
                #end
            #end
        </tr>

This one colors the background in red if a specific condition is fulfilled , if not, than no color is used.

Reply