Forum Discussion
2 Replies
Sort By
- Quick_BaseJunkiQrew CaptainHi Akanksha, you could set up different forms with each of the reports you want to be able to display, then put a Formula URL button on your main form that dynamically chooses which form to display based on the value selected in X. Your users would then just need to 'press the button to display the report'.
var number FORMID = Case([X Value],"AAA",6,"BBB",7,"CCC",8,"DDD",9,1);
URLEncode(URLRoot() & "db/" & Dbid() &
"?a=er&dfid="& $FORMID &
"&rid="& [Record ID#])
You'll just need to update the Case formula with your field and values for both the value selected in X and the ID numbers from you different forms. Also, don't forget to select "Display as a button". - QuickBaseCoachDQrew CaptainI suggest a simple lookup field for the parent to the child. Then edit the report used for that embedded report on the parent to include a filter for that selection. You will need to save before the filter takes effect, so I suggest suppressing that report in Edit mode as it will confuse users.