form rule field

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

I would like to make a form rule that uses a dropdown field to determine what form is shown.  For example, add a new employee (use default form) but when status is "in training" it would switch to the form created specifically for "in training".   

Photo of Brad

Brad

  • 22 Points

Posted 3 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 65,422 Points 50k badge 2x thumb
My suggestion is to really try to use just one form, and have form rules to show and hide fields and sections, based on that drop down.  The challenge with multiple forms is that your users will likely find themselves on the wrong form and you would need to anticipate the form they need depending on how they access the record.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,044 Points 20k badge 2x thumb
My suggestion is to really try to use just one form, and have form rules to show and hide fields and sections, based on that drop down.  The challenge with multiple forms is that your users will likely find themselves on the wrong form and you would need to anticipate the form they need depending on how they access the record.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,422 Points 50k badge 2x thumb
Dan, I agree.  Couldn't have said it better myself.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,044 Points 20k badge 2x thumb
Photo of Brad

Brad

  • 22 Points
The problem i have is that this table has well over 300 fields that are all related to each person. I already have so many rules that conflict based on a number of pivots.  It works well to establish the forms by role, but would be so much better to be the same for all roles and pivot based off that one field.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,044 Points 20k badge 2x thumb
You can do it with script. I am about to shut down for the week so I will reply later with a solution.

BTW everything can be done with script.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,422 Points 50k badge 2x thumb
In native QuickBase the tool you have to work with are setting the default form by report and creating your own button to View with the &dfid=xx build into specify the form ID, and also to construct  "&nexturl=" & URLEncode( a URL which specifies a dfid)