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
Meagin,
It looks like a simple change from what you have posted:
If(not(IsNull([Scheduled - Yes])) and [Checkbox]=false, $green, .....
In this example [Checkbox] is the field that your users have set.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
It looks like a simple change from what you have posted:
If(not(IsNull([Scheduled - Yes])) and [Checkbox]=false, $green, .....
In this example [Checkbox] is the field that your users have set.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
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
------------------------------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
------------------------------
