PlantReport.Run({file:{name:"Plants", contentBytes:PDF(Container5, {ExpandContainers:true})}})
HTML Text:
"<div style='max-height:600px; overflow:auto; padding-right:10px;'>"
& (
"<table style='font-family:Arial; border-collapse:collapse; width:100%; margin-bottom:20px;'>
<tr>
<td style='background-color:#FFD700; color:black; padding:10px; text-align:center;'>Sunflower<br><b>" & SunflowerCount & "</b></td>
<td style='background-color:#FFD700; color:black; padding:10px; text-align:center;'>Rose<br><b>" & RoseCount & "</b></td>
<td style='background-color:#1E90FF; color:white; padding:10px; text-align:center;'>Daisy<br><b>" & DaisyCount & "</b></td>
<td style='background-color:#800080; color:white; padding:10px; text-align:center;'>MorningDew<br><b>" & MorningDewCount & "</b></td>
<td style='background-color:#228B22; color:white; padding:10px; text-align:center;'>Other<br><b>" & OtherCount & "</b></td>
<td style='background-color:#228B22; color:white; padding:10px; text-align:center;'>Tree<br><b>" & TreeCount & "</b></td>
<td style='background-color:#FF8C00; color:white; padding:10px; text-align:center;'>Ginger<br><b>" & GingerCount & "</b></td>
</tr>
</table>"
// Daisy
& "<h3 style='font-family:Segoe UI, Arial, sans-serif; color:#228B22; margin-bottom:8px;'>Daisy Summary</h3>"
& Concat(
Daisy,
If(
Label = "Summary",
// Add incident header + normal label/value block
"<div style='margin-top:20px; border-top:2px solid #228B22; padding-top:10px; font-weight:700; color:#228B22; font-size:16px;'>"
& "<div style='font-family:Segoe UI, Arial, sans-serif; margin-bottom:12px;'>"
& "<div style='font-weight:600; color:#333; margin-bottom:2px;'>" & Label & "</div>"
& "<div style='color:#666; font-size:14px;'>" & Value & "</div>"
& "</div>",
// All other label/value pairs
"<div style='font-family:Segoe UI, Arial, sans-serif; margin-bottom:12px;'>"
& "<div style='font-weight:600; color:#333; margin-bottom:2px;'>" & Label & "</div>"
& "<div style='color:#666; font-size:14px;'>" & Value & "</div>"
& "</div>"
)
)
& "<hr style='border:none; border-top:1px solid #ddd; margin:10px 0;' />"
// MorningDew Section
& "<h3 style='font-family:Segoe UI, Arial, sans-serif; color:#228B22; margin-bottom:8px;'>MorningDew Summary</h3>"
& Concat(
MorningDew,
If(
Label = "Summary",
// Add incident header + normal label/value block
"<div style='margin-top:20px; border-top:2px solid #228B22; padding-top:10px; font-weight:700; color:#228B22; font-size:16px;'>"
& "<div style='font-family:Segoe UI, Arial, sans-serif; margin-bottom:12px;'>"
& "<div style='font-weight:600; color:#333; margin-bottom:2px;'>" & Label & "</div>"
& "<div style='color:#666; font-size:14px;'>" & Value & "</div>"
& "</div>",
// All other label/value pairs
"<div style='font-family:Segoe UI, Arial, sans-serif; margin-bottom:12px;'>"
& "<div style='font-weight:600; color:#333; margin-bottom:2px;'>" & Label & "</div>"
& "<div style='color:#666; font-size:14px;'>" & Value & "</div>"
& "</div>"
)
)
& "<hr style='border:none; border-top:1px solid #ddd; margin:10px 0;' />"
// Other Status Section
& "<h3 style='font-family:Segoe UI, Arial, sans-serif; color:#228B22; margin-bottom:8px;'>Other Summary</h3>"
& Concat(
Other,
If(
Label = "Summary",
// Add incident header + normal label/value block
"<div style='margin-top:20px; border-top:2px solid #228B22; padding-top:10px; font-weight:700; color:#228B22; font-size:16px;'>"
& "<div style='font-family:Segoe UI, Arial, sans-serif; margin-bottom:12px;'>"
& "<div style='font-weight:600; color:#333; margin-bottom:2px;'>" & Label & "</div>"
& "<div style='color:#666; font-size:14px;'>" & Value & "</div>"
& "</div>",
// All other label/value pairs
"<div style='font-family:Segoe UI, Arial, sans-serif; margin-bottom:12px;'>"
& "<div style='font-weight:600; color:#333; margin-bottom:2px;'>" & Label & "</div>"
& "<div style='color:#666; font-size:14px;'>" & Value & "</div>"
& "</div>"
)
)
& "<hr style='border:none; border-top:1px solid #ddd; margin:10px 0;' />"
// Rose
& "<h3 style='font-family:Segoe UI, Arial, sans-serif; color:#228B22; margin-bottom:8px;'>Hazard Summary</h3>"
& Concat(
Rose,
If(
Label = "Summary",
// Add incident header + normal label/value block
"<div style='margin-top:20px; border-top:2px solid #228B22; padding-top:10px; font-weight:700; color:#228B22; font-size:16px;'>"
& "<div style='font-family:Segoe UI, Arial, sans-serif; margin-bottom:12px;'>"
& "<div style='font-weight:600; color:#333; margin-bottom:2px;'>" & Label & "</div>"
& "<div style='color:#666; font-size:14px;'>" & Value & "</div>"
& "</div>",
// All other label/value pairs
"<div style='font-family:Segoe UI, Arial, sans-serif; margin-bottom:12px;'>"
& "<div style='font-weight:600; color:#333; margin-bottom:2px;'>" & Label & "</div>"
& "<div style='color:#666; font-size:14px;'>" & Value & "</div>"
& "</div>"
)
)
& "<hr style='border:none; border-top:1px solid #ddd; margin:10px 0;' />"
// Sunflower
& "<h3 id='Sunflower' style='font-family:Segoe UI, Arial, sans-serif; color:#228B22; margin-bottom:8px;'>Sunflower Summary</h3>"
& Concat(
Sunflower,
If(
Label = "Summary",
// Add incident header + normal label/value block
"<div style='margin-top:20px; border-top:2px solid #228B22; padding-top:10px; font-weight:700; color:#228B22; font-size:16px;'>"
& "<div style='font-family:Segoe UI, Arial, sans-serif; margin-bottom:12px;'>"
& "<div style='font-weight:600; color:#333; margin-bottom:2px;'>" & Label & "</div>"
& "<div style='color:#666; font-size:14px;'>" & Value & "</div>"
& "</div>",
// All other label/value pairs
"<div style='font-family:Segoe UI, Arial, sans-serif; margin-bottom:12px;'>"
& "<div style='font-weight:600; color:#333; margin-bottom:2px;'>" & Label & "</div>"
& "<div style='color:#666; font-size:14px;'>" & Value & "</div>"
& "</div>"
)
)
& "<hr style='border:none; border-top:1px solid #ddd; margin:10px 0;' />"
// Treed
& "<h3 style='font-family:Segoe UI, Arial, sans-serif; color:#228B22; margin-bottom:8px;'>Tree Summary</h3>"
& Concat(
Treed,
If(
Label = "Summary",
// Add incident header + normal label/value block
"<div style='margin-top:20px; border-top:2px solid #228B22; padding-top:10px; font-weight:700; color:#228B22; font-size:16px;'>"
& "<div style='font-family:Segoe UI, Arial, sans-serif; margin-bottom:12px;'>"
& "<div style='font-weight:600; color:#333; margin-bottom:2px;'>" & Label & "</div>"
& "<div style='color:#666; font-size:14px;'>" & Value & "</div>"
& "</div>",
// All other label/value pairs
"<div style='font-family:Segoe UI, Arial, sans-serif; margin-bottom:12px;'>"
& "<div style='font-weight:600; color:#333; margin-bottom:2px;'>" & Label & "</div>"
& "<div style='color:#666; font-size:14px;'>" & Value & "</div>"
& "</div>"
)
)
& "<hr style='border:none; border-top:1px solid #ddd; margin:10px 0;' />"
// Ginger
& "<h3 style='font-family:Segoe UI, Arial, sans-serif; color:#228B22; margin-bottom:8px;'>Ginger Summary</h3>"
& Concat(
Ginger,
If(
Label = "Summary",
// Add incident header + normal label/value block
"<div style='margin-top:20px; border-top:2px solid #228B22; padding-top:10px; font-weight:700; color:#228B22; font-size:16px;'>"
& "<div style='font-family:Segoe UI, Arial, sans-serif; margin-bottom:12px;'>"
& "<div style='font-weight:600; color:#333; margin-bottom:2px;'>" & Label & "</div>"
& "<div style='color:#666; font-size:14px;'>" & Value & "</div>"
& "</div>",
// All other label/value pairs
"<div style='font-family:Segoe UI, Arial, sans-serif; margin-bottom:12px;'>"
& "<div style='font-weight:600; color:#333; margin-bottom:2px;'>" & Label & "</div>"
& "<div style='color:#666; font-size:14px;'>" & Value & "</div>"
& "</div>"
)
)
& "<hr style='border:none; border-top:1px solid #ddd; margin:10px 0;' />"
)
& "</div>"