Switc code from date to checkbox
Hello,
I currently have this wonderful code that color codes cells based on the due date and the actual date. However, we are now chaging this to be a due date and a checkbox if the appointment wa...
Forum Discussion
Don,
Thank you so much for your response. I replaced the field with [Checkbox] but it says that the field is not identified.
Here is a snip of the table itself.
Any assistance you could provide would be greatly appreciated.
Thank you!
------------------------------
Meagan McOlin
------------------------------
Use the name of the actual checkbox field. For example if your field is called
[Due Date Set]
Then that is what goes into your formula.
It could just as easily be any other name that has meaning to your users.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
[Due Date Set]
Then that is what goes into your formula.
It could just as easily be any other name that has meaning to your users.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
Don,
That is what I tried orginally, but I get the error below.
Here is the full code again if you need it:
var text red = "<a style=\" text-decoration: none; background: #ea4335; border-radius: 5px; color: #fff; display: inline-block; width: 160px; text-align: center; padding: 8px 20px; font: normal 700 14px/1 \"Calibri\", sans-serif; text-shadow: none; \">"&ToText(ToDays(Today()-[Appointment Needed By]))&" Days Overdue</a>";
var text green = "<a style=\" text-decoration: none; background: #34a853; border-radius: 5px; color: #fff; display: inline-block; width: 160px; text-align: center; padding: 8px 20px; font: normal 700 14px/1 \"Calibri\", sans-serif; text-shadow: none; \">Complete</a>";
var text yellow = "<a style=\" text-decoration: none; background: #fbbc05; border-radius: 5px; color: #fff; display: inline-block; width: 160px; text-align: center; padding: 8px 20px; font: normal 700 14px/1 \"Calibri\", sans-serif; text-shadow: none; \">"&ToDays(Today()-[Appointment Needed By])&" Days Due</a>";
If(not(IsNull([Scheduled - Yes])),$green,
If(IsNull([Scheduled - Yes]) and [Appointment Needed By] >= Today(),$yellow,
If(IsNull([Scheduled - Yes]]) and [Appointment Needed By] < Today(),$red)))
------------------------------
Meagan McOlin
------------------------------Don,
Thank you for your continued help. I fixed the color-coding issue (I needed a true/false statement instead of Null) but now I am trying to code it so that the field turns yellow if the "Appointment Needed By" is coming up in 2 weeks or less. Right now it turns yellow if the date is any date less than today. We don't need it to be yellow all the time though, just when the "Appointment Needed By" date is drawing near.
------------------------------
Meagan McOlin
------------------------------