Forum Discussion

KellyLyons's avatar
KellyLyons
Qrew Trainee
2 years ago

If checkbox is no/false highlight row?

I am trying to highlight a row if the Checkbox field "Confirmed Sent" is false/No.

We have 2 ways to send out invoices, send now or sent via email. I have 2 fields that are checkboxes, the first is "Send Now" and the other is "Sent via Email?".  I created the 3rd "Confirmed Sent" which looks at both these fields to confirm the invoice has been sent either way. 

Now I want to highlight any row where "Confirmed Sent" is not yes/true.  

I tried using the IsNull function in the report settings with no luck:  

If(IsNull([Confirmed Sent], "yellow"))

I also tried creating a formula field to do the same but I keep getting syntax errors.  

Any ideas???

 



------------------------------
Kelly Lyons
------------------------------
  • Try this

    If(not [Confirmed Sent], "yellow")



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------

    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend

      Or this is the same result but with slightly different syntax

      If([Confirmed Sent] = false, "yellow")



      ------------------------------
      Mark Shnier (Your Quickbase Coach)
      mark.shnier@gmail.com
      ------------------------------
    • KellyLyons's avatar
      KellyLyons
      Qrew Trainee

      Hi Mark, so I just tried this and it worked:

      If([Confirmed Sent]=false, "#ffff88")

      But I have another question now.  I also want to highlight/change background color to a light gray if the invoice status field equals "Reverse", "Duplicate Invoice (created in error)" or "Invoice Reversed"

      Can I also do that in the report setting if I already have the above formula in there?



      ------------------------------
      Kelly Lyons
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend

        ..... So QuickBase IF formulas are in fact much easier than Excel formulas as you can stack them vertically for readability and you can just list your conditions all in one if statement. It will evaluate the conditions in the order they are listed and take the first one which is true.  

        IF(

        [Confirmed Sent]=false, "#ffff88",

        Contains([invoice status], "reverse", "#A9A9A9"), 

        Contains([invoice status], "duplicate", "#A9A9A9")

        You have to decide what sequence to do the testing because once it gets coloured yellow in the first line it will never have a chance to be coloured gray so you have to decide which is more important.  

        Laura Thacker another Quickbase developer has a nice app here with all the row colours. https://laurahillier.quickbase.com/db/bhy8pumuk?a=q&qid=-1000006&dr=1  but also many of the rainbow color names work like red or pink or yellow or blue ...



        ------------------------------
        Mark Shnier (Your Quickbase Coach)
        mark.shnier@gmail.com
        ------------------------------