Case Statements
CASE WHEN {source} is “x”
AND WHEN {createdby} = “John”
THEN ‘<div> 🚨 </div>’
ELSE ‘<div> ✅</div>’
END ||
CASE WHEN {source} is “y”
AND WHEN {createdby} = “Jane”
THEN ‘<div> ⚠️ </div>’
ELSE ‘<div> ✅</div>’
END
CASE WHEN {source} is “x”
AND WHEN {createdby} = “John”
THEN ‘<-–!1–-> <div style=”color:white;backgroundcolor:red;padding:3px;text-align:center”
> 🚨 Error </div>’
ELSE ‘<-–!3–-><div style=”color:white;backgroundcolor:Green;padding:3px;text-align:center”
>✅ Approved </div>’
END
‘<style>
.alert {
color:white;
background-color: darkred;
padding: 3px;
text-align:center;
border-radius: 6px 6px 6px 6px;
box-shadow: 0px 0px 0px 1px lightgray, 0px 1px 2px 0px
gray, 0px 1px 3px 0px gray;
width:100px;
}
</style>‘
