I am working on a project of automating sending emails based on html template from google sheet data using Appscript.
Below code worked for me
<td class="<?= r1 == "No" ? 'red-bg' : 'green-bg' ?>"><?= r1 ?></td>
I want to add another color parameter. If r1 is equal to "Partial" turn to amber color.
Appreciate your help
I'm not sure if you can chain the conditional but you could try this:
<td class="<?= r1 == "No" ? 'red-bg' : r1 == "Partial" ? 'amber' : 'green-bg' ?>"