Highlighting stage gates

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
I have a set of dates which need to be filled in on or before a target date (that I am calculating).  I would like to have an arrow or a question mark appear next to the field where the date is missing.  I have seen icons but can these change colour triggered by a formula?  What approach can I take?

Another question,  is it possible to grey out dates (Target, Planned, Actual) where the target dates are not due yet and these could be greyed out.  So a long list of dates will be available for editing progressively for editing.
      
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,132 Points 3k badge 2x thumb

Posted 1 year ago

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

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
There are 502 icons on 5 sizes available here to all users https://login.quickbase.com/db/9kaw8phg?a=ShowPage&pageid=134


Here is an example of a formula text field with html enabled to show an icon.


and here 
Case([Record ID#],
1, "<img src=https://images.quickbase.com/si/24/280-user_0.png>";, // "Morpho Help Desk",
5,  "<img src=https://images.quickbase.com/si/24/403-up.png>";, //"Morpho Escalate"
3, "<img src=https://images.quickbase.com/si/24/410-prev_0.png>";, // "Waiting on Client"
4,  "<img src=https://images.quickbase.com/si/24/047-undo.png>";, //"Waiting on Vendor"
2,  "<img src=https://images.quickbase.com/si/24/211-check_all.png>";, // Closed 
6,  "<img src=https://images.quickbase.com/si/24/200-add.png>";, //"New",
7,  "<img src=https://images.quickbase.com/si/24/512-tools.png>";, // 3rd Party Field Tech
8,  "<img src=https://images.quickbase.com/si/24/442-charges.png>";, //Quote given to Customer
9,  "<img src=https://images.quickbase.com/si/24/440-dollar_1.png>") //Customer Provided PO



.... as for graying out dates, do you mean how you can to make them read only in edit mode, or just appear in a different font color in view mode.
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,132 Points 3k badge 2x thumb
Thanks Mark. Appreciate your detailed response.  I did manage to figure out to some extent but your solution is as elegant as ever.  Any idea if I can get a left arrow in red colour? 


Re second section of the question, different colour will be good. 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
Well as a look a,t the link to all 502 icons which I had posted, I do see three icons that include a red left arrow, in their image.

The other choice is to just google search for

Red arrow left images

And you will get a whole bunch of hits. You can then save one of those locally in your images app and link to that instead of the std icons.
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,132 Points 3k badge 2x thumb
Thanks a lot.