Edit Record on Different Form Based on Field Value

  • 0
  • 1
  • Question
  • Updated 4 weeks ago
  • In Progress
I've got an application up that is managing the process flow for one of 6 products.  When you edit a record, obviously you see the form for the table.

However, I need to be able to create 5 more different forms, and route the 'edit' to that form, based on what value is in the 'product' field.

I started to use Form Rules, but it's a nightmare trying to hide everything and show everything for all 7 roles.

How can I click on a record in a report and be transported to the correct form, based on the Product field?
Photo of Kyle Chase

Kyle Chase

  • 70 Points

Posted 4 weeks ago

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

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
No, you cannot. 
I personally despise multiple forms as its a worse nightmare than form rules.

So, you choices are to associate your forms with which reports they should be used on (set that in Forms usage, once you have more than 1 form) or else use sections as much as possible and show hide rules on whole sections.  The issue will be to group your common fields data entry fields together if possible as you may only have a data entry field once on a form.