Forum Discussion
QuickBaseCoachD
7 years agoQrew Captain
I'm not sure if this can be done with form rules directly, but you can always just make a regular formula field and hook the form rule on the formula field.
Put the formula field on the form in a hidden section to ensure that the form recalculates the formula as the data on the form is being edited.
Put the formula field on the form in a hidden section to ensure that the form recalculates the formula as the data on the form is being edited.
BalaAboki
7 years agoQrew Trainee
Hey Coach - how would you implement dynamic rule on workflow that is sequential. The workflow was 5 stages in total but not all steps needs to be completed i,e, some work can have only 3, 4 or 5 stages. For simplicity each workflow is on its own TAB.
Here is what i would like to be with getting this error "(Rules #3 and #4 are both 'show/hide' rules on the same tab (Reviewer 2)"
If the total # of workflow stage is 3, than show TAB 1-3
IF the total # of workflow Stage is 4 then show TAB 1- 4
If the total # of workflow stage is 5, then show TAB 1-5
Note I have a formula field that calculates the total stage.
Thanks
Here is what i would like to be with getting this error "(Rules #3 and #4 are both 'show/hide' rules on the same tab (Reviewer 2)"
If the total # of workflow stage is 3, than show TAB 1-3
IF the total # of workflow Stage is 4 then show TAB 1- 4
If the total # of workflow stage is 5, then show TAB 1-5
Note I have a formula field that calculates the total stage.
Thanks