Skip to main content
Question

Set up a dynamic filter on a report in Parent table based on content in Child records

  • March 18, 2019
  • 0 replies
  • 127 views
My child table has ~50 possible values for a required text field. Each parent record has children representing some combination of these text values. Is there a way to set up a dynamic filter for a report on the parents table that would list all these possible values and enable users to filter by parents which are related to child records that contain specific values?
Thanks, Alex

    I don't have a way to allow a Dynamic Filter, but I do know a way to search / filter via the filter box at the top of the report, if that is useful.
    • KingslySamuel
    • Quickbase Alumni
    • March 18, 2019
    I am sure you must have thought of it and that you wanted this report to be on the parent table, but just from a report perspective, you can achieve the same result (report with these dynamic filters) in a child table, can't you?
    .. building  on what Kigsly said above, you van use a Summary Report on the child table to get the result you are looking for.  It is also possible to provide a link in the summary report which will take you to the Parent record instead of the children, as your goal is to get to a Parent, I believe.
    • AlexGale
    • Author
    • Quickbase Alumni
    • March 18, 2019
    I do like the suggestion of putting the report on the child table instead. Ideally this would have been combined with an existing report I have on the Parents table but I knew that might not be possible. 
    Thanks, Alex
    Terms & ConditionsAccessibility statement