Forum Discussion

RajHelaiya's avatar
RajHelaiya
Qrew Captain
7 years ago

Hide and show multiple fields on a form based on conditions using Java Script.

Below is my scenario: I have 2 tables Course and Enrollment.  Course table contains Course name, number of activities, assessment method(total 10 text fields) and course description.  Enrollment co...
APIs and custom code
App builders
Discuss the community
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
You could use 20 formula checkbox fields.

The formula for [Show Assessment method 1]

would be

IF([# of activities]=3, true)
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
6 years ago
Here 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.