Skip to main content
Question

Child table form based on parent's field value

  • November 12, 2021
  • 0 replies
  • 45 views
Hi,
I have a report link on a parent table. When the user clicks on a specific record of the report, I would like to open a specific child table's form depending on whether a checkbox field of the parent table is checked or not. In other words I would like to display different child forms depending on the value of a parent table field. Is there a way to achieve that? I know it is possible to set form rules, but that is not my goal, as each form that I created has competing form rules with the others.

Thanks.

------------------------------
Eleonora Ruffini
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24

You can make a button called View


var text FormOne =URLRoot() & "db/" & dbid() & "?a=dr&dfid=2&rid=" & [Record ID#];
var text FormTwo =URLRoot() & "db/" & dbid() & "?a=dr&dfid=10&rid=" & [Record ID#];

IF([My Checkbox]=true, $FormOne, $FormTwo)

Then you will probably need a duplicate of the field if you want to edit.  But change the dr to er. 

If you want to stop users to not use the native view and edit buttons, then you put these on the report and deselect the report configuration checkboxes to Allow View and Allow Edit. 

 



------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement