Forum Discussion

KellyBianchi's avatar
KellyBianchi
Qrew Assistant Captain
8 years ago

How can I put 2 conditions (text and numeric) as independent conditions, and then combined?

I am using row colorization formulas, mostly based on a date/time field, which works. However, I need to add a condition regarding a text field, which would need to override the colorization rule based on the date formulas. I have attempted to create a line item for each date formula combined with the text formula. It doesn't seem to be working. Here is what I have so far:

If(
not IsNull([Time Complete]), "",
([ETA:])>Now(),"#08ef08", 
([ETA:])<Now() and ToDays([ETA:]-Now())>-1, "#f9fc03",
ToDays([ETA:]-Now())<0,"#fd3110",
IsNull([ETA:]),"#00f6ff",
(Trim([Van Driver]))<>"" and ([ETA:])>Now(),"#00f6ff")

The last line is the only one not working.
App builders
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    Are your conditions listed in their priority?
    The IF statement evaluates the tests in the order they are liste and stops at the first one which is true.
  • KellyBianchi's avatar
    KellyBianchi
    Qrew Assistant Captain
    8 years ago
    I just moved it around, and it still isn't showing the blank value in blue over the ETA condition in green.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    Can you post you current formula, and tell me which line of the IF is not triggering and what the values are in each of the fields in that line?
    • KellyBianchi's avatar
      KellyBianchi
      Qrew Assistant Captain
      8 years ago
      I started to get closer. I changed to this, but now the blue is overriding the green:
      If(
      not IsNull([Time Complete]), "",
      (Trim([Van Driver]))<>"" and ([ETA:])>Now() or (([ETA:])<Now() and ToDays([ETA:]-Now())>-1) or ToDays([ETA:]-Now())<0,"#00f6ff",
      ([ETA:])>Now(),"#08ef08",
      ([ETA:])<Now() and ToDays([ETA:]-Now())>-1, "#f9fc03",
      ToDays([ETA:]-Now())<0,"#fd3110",
      IsNull([ETA:]),"#00f6ff")

      The line that was not triggering until I moved everything into one string was this one:
      (Trim([Van Driver]))<>"" and ([ETA:])>Now() 

      I was going to create a separate line for each, but then I decided to string it all together with 'or'. I am trying to make the rows green, red, or yellow based on the time in the 'ETA' field. However, I need the row to display blue if there is no ETA or if the van driver has not been assigned. I can't get the part to work to show blue when the van driver has not been assigned.
    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      8 years ago
      i suggest not using the ORs, as for debugging, its best to just list the conditions and results separately.

      For the blue when the van driver is blank, is there also an eta condition too? Or is it enough to be blue when the van driver is blank. Right now you have an additional test for the eta.