How do I make the PC (Project Condition) buttons clickable, so that I can select the condition I would like for each project?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
I have the following formula for PC, but would like to make the buttons clickable. Can anyone please help me edit my formula?



Case([Status],"Not Started", "https://images.quickbase.com/si/16/226-rect_gray.png\" title=\"Not Started\">", "In-Progress", 

If([Actual End Date]>[Est End Date],"https://images.quickbase.com/si/16/227-rect_red.png\" title=\"Project Overdue\">",

If(ToDays([Total Days Overdue])>0,"https://images.quickbase.com/si/16/229-rect_yellow.png\" title=\"Task Overdue\">",

"https://images.quickbase.com/si/16/228-rect_green.png\" title=\"On Time\">")), 

"Completed", "https://images.quickbase.com/si/16/226-rect_gray.png\" title=\"Completed\">", 

"On Hold", "https://images.quickbase.com/si/16/226-rect_gray.png\" title=\"On Hold\">", 

"Canceled", "https://images.quickbase.com/si/16/226-rect_gray.png\" title=\"Canceled\">")
Photo of GeekEye Graphix

GeekEye Graphix

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,096 Points 50k badge 2x thumb
What do you mean by clickable?  When you click what is it you want to have it do?
Photo of Blake Harrison - DataBlender

Blake Harrison - DataBlender, Champion

  • 100 Points 100 badge 2x thumb
This formula is intended to show a single PC icon based on the existing status. What you'll need to do is have an Icon Key that shows at the top of your form, with each possible option. Most of the ABC Project Manager derivative apps in Exchange has this setup at the top of the Projects form. To have them setup as "clickable", however, would require that you incorporate the API into each possibility. My suggestion would be to have a separate formula-text field for each possible status that would utilize your icon of choice and then replace the Icon Key at the top of the form with these fields.