Forum Discussion
QuickBaseCoachD
7 years agoQrew Captain
You could use 20 formula checkbox fields.
The formula for [Show Assessment method 1]
would be
IF([# of activities]=3, true)
The formula for [Show Assessment method 1]
would be
IF([# of activities]=3, true)
- QuickBaseCoachD7 years agoQrew CaptainIf there are additional considerations as to when to show [Assessment method 1], you just make the formula More complex._
- RajHelaiya6 years agoQrew CaptainHello, I need to show assesment menthod 1 field when n=#of activities is from 1 to 10 similarly show assesment method 2 when # of activities from 2 to 10. Tried using case statement , I am not able to properly define the formula
- QuickBaseCoachD6 years agoQrew CaptainHere is a formula which will be true of the # of Activities is between 1 and 10.
[# of Activities] >=1 and [# of Activities] <=10
Use that in the rule to control if Assessment method 1 is shown.
You will need a separate formula to control if you show Assessment Method 2.
If the rules are as simple as this, then you do not need to have a formula though, just a form rule specifically and only dealing with Assessment Method 1. - RajHelaiya6 years agoQrew CaptainThanks that actually worked, you are a savior