Skip to main content
Question

Highlighting stage gates

  • August 16, 2017
  • 0 replies
  • 48 views
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.
      
      This topic has been closed for replies.

      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.
      • ArshadKhwaja
      • Author
      • Quickbase Alumni
      • August 16, 2017
      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. 
      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.
      • ArshadKhwaja
      • Author
      • Quickbase Alumni
      • August 16, 2017
      Thanks a lot. 
      Terms & ConditionsAccessibility statement