Testing various Field successively

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered

I have six date fields which signify a successive progress on a project.  I am trying to categorise the progress textually by by selecting first date, then first and second date, then first, second and third date etc. Is there a better option to achieve this where I check the fields filled in?    As an example I am using following formula which likely to increase in length once I add more. 

If(

[Store Walk Not Required]<> true and IsNull([Store Walk Date]), "Store Walk Stage",

[Obj Validation Not Required]<> true and IsNull([Obj Validation Date]) and not IsNull([Store Walk Date]), "Validation Stage",

not IsNull([Store Walk Date]) and not IsNull([Obj Validation Date]), "Sign Off Stage",

[Pre FGCC Not Required]<> true and IsNull([Pre FGCC Sign Off Date]) and not IsNull([Store Walk Date]) and not IsNull([Obj Validation Date]) and [Latest Design Stage] = "GM Sign Off Plan", "Pre FGCC Stage")

Photo of Arshad Khwaja

Arshad Khwaja

  • 3,142 Points 3k badge 2x thumb

Posted 2 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 62,438 Points 50k badge 2x thumb
re: "categorise the progress textually". Can you give an example of the result you are looking for when various of these dates are filled in?
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,142 Points 3k badge 2x thumb
Thanks.  I just edited my question with an example of formula I am trying to simplify. .
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,438 Points 50k badge 2x thumb
There is not a more elegant way.  

The only problem with a long formula is your ability to read it and keep it tidy and in the proper sequence as QuickBase walks down each test looking for the first one that is true.  

While there is a limit to how long a formula can be it is an insanely large limit,  which believe me, you will never hit.
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,142 Points 3k badge 2x thumb
Many thanks for your help.