Forum Discussion

YehudahGreenber

Qrew Assistant Captain

8 years ago

Task Condition html for Date Completed

In Project Manager, I'm using HTML to link the Task Condition buttons to Start and End Dates, as opposed to the manually updated "status" menu. This way, the "inactive" button will appear automatical...

Ask about Quickbase functionality

YehudahGreenber

Qrew Assistant Captain

8 years ago

Sorry for not being clear, here is the whole script:

If (ToDate([Start])>(Today()), "<img src=\"https://images.quickbase.com/si/16/049-clock.png\"; title=\"Delayed Start\">",

If (Today()=ToDate([Start]) and (Today()<=ToDate([Projected Finish])), "<img src=\"https://images.quickbase.com/si/16/222-point_green.png\"; title=\"On Time\">",

If (Today()>ToDate([Projected Finish]) and (Today()<ToDate([Date Complete])), "<img src=\"https://images.quickbase.com/si/16/221-point_red.png\"; title=\"Overdue\">",

If ([Status]="Issue", "<img src=\"https://images.quickbase.com/si/16/223-point_yellow.png\"; title=\"Issue\">",

If (Today()>=ToDate([Date Complete]) and ToDate([Date Complete]) >= (ToDate([Projected Finish])), "<img src=\"https://images.quickbase.com/si/16/220-point_gray.png\"; title=\"Inactive\">",
"<img src=\"https://images.quickbase.com/si/16/220-point_gray.png\"; title=\"Inactive\">",

)))))

Every task has an "inactive" button, regardless of the other attributes.