Coding Help
Hi everyone! I am asking for someone to help me with a formula - rich text code if possible to color code notifications. To clarify, there will be a start date and 7 days out from that date if the ...
Forum Discussion
Oana,
Thank you so much for your help! I greatly appreciate your help. The only question I have is - can there be a way for the notifications to not show if something is completed and/or checked?
------------------------------
Amy Tran
------------------------------
Thank you so much for your help! I greatly appreciate your help. The only question I have is - can there be a way for the notifications to not show if something is completed and/or checked?
------------------------------
Amy Tran
------------------------------
Yes! You can just wrap it in an if statement that shows nothing if a box is checked. The "" value is what tells it to leave the field blank.
The formula below says "If the checkmark is checked, show a blank value. Otherwise, show the colored message."
var number DaysLeft = ToDays(Today()-[Final Report Due]);
If([checkmark]=true,"",
If($DaysLeft<-7, "<div style=\"background-color:GreenYellow;\">"&Abs($DaysLeft) & " Days Remaining"&"</div>",
If($DaysLeft<-1, "<div style=\"background-color:Gold;\">"&Abs($DaysLeft) & " Days Remaining"&"</div>",
If($DaysLeft=-1, "<div style=\"background-color:Orange;\">"&"Report due Tomorrow"&"</div>",
If($DaysLeft=0, "<div style=\"background-color:Yellow; color:IndianRed;\">"&"Report due TODAY"&"</div>",
If($DaysLeft>0, "<div style=\"background-color:white; font-size:15px; font-weight:bold; color:red\">"&"Report OVERDUE"&"</div>")))))
)
------------------------------
Oana Toma
------------------------------
The formula below says "If the checkmark is checked, show a blank value. Otherwise, show the colored message."
var number DaysLeft = ToDays(Today()-[Final Report Due]);
If([checkmark]=true,"",
If($DaysLeft<-7, "<div style=\"background-color:GreenYellow;\">"&Abs($DaysLeft) & " Days Remaining"&"</div>",
If($DaysLeft<-1, "<div style=\"background-color:Gold;\">"&Abs($DaysLeft) & " Days Remaining"&"</div>",
If($DaysLeft=-1, "<div style=\"background-color:Orange;\">"&"Report due Tomorrow"&"</div>",
If($DaysLeft=0, "<div style=\"background-color:Yellow; color:IndianRed;\">"&"Report due TODAY"&"</div>",
If($DaysLeft>0, "<div style=\"background-color:white; font-size:15px; font-weight:bold; color:red\">"&"Report OVERDUE"&"</div>")))))
)
------------------------------
Oana Toma
------------------------------
- Oana,
You're an angel sent from above!! THANK YOU so much for helping noobs like me :) You are so awesome!!!!
------------------------------
Amy Tran
------------------------------- Oana,
Out of curiosity, how could I change the code above to inform when inventory is low if dates are not included if that is possible?
------------------------------
Amy Tran
------------------------------- Sure. You can replace the $DaysLeft in the formula with [Inventory Count] and have the conditions be the inventory thresholds, then change the message being displayed.
For example:
- The first line below checks if inventory is less than 5, and if so displays "Low Inventory."
- If Inventory is between 5 and 20, it would display "Only ## items remaining."
- If neither condition is met, it displays "In Stock."
If([Inventory Count]<5,<div .... > & "Low Inventory" & "</div>",
If(5<[Inventory Count]<20,<div ...> & "Only " & [Inventory Count} & " items remaining</div>",
"In Stock")
The structure here is If(Condition 1 is met, Do This, else If(Condition 2 is met, Do Something, else display default))
------------------------------
Oana Toma
------------------------------
