Limit the Related Field on the Child Table, based on a value in the Parent Table

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • In Progress
I would like to be able to limit the related records from the Parent Table when choosing which parent on the Child Table.

Example: Audits in the Parent Table, and Audit Reports is the Child Table. When choosing which Audit to relate the Audit Report to, I only want to see the active Audits (based on the Status field on the Audits table).

Is this possible?
Photo of Jennifer Peterson

Jennifer Peterson

  • 438 Points 250 badge 2x thumb

Posted 2 months ago

  • 0
  • 1
Photo of Charlie

Charlie

  • 380 Points 250 badge 2x thumb
Absolutely! All you need to do is:

  1. Create a report in your audits table where status = active
  2. right click on the record picker for audits on your form
  3. pick your report from this dropdown:



Pro tip -- limit your report to 1 column if you only want to see 1 field to represent each record in the picker.
Photo of Jennifer Peterson

Jennifer Peterson

  • 408 Points 250 badge 2x thumb
Thank you!

Is there a way to make that work in Grid Edit as well?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 68,978 Points 50k badge 2x thumb
Yes indeed.
What you do is to make a new form called, perhaps,  Grid Edit form.  show the fields that you want to have on your grid edit report and also setup that report to filter the drop down list.

now that you have more than 1 form you will have a section for Forms usage and you can specify your "form" to be used for Grid Edit.  The form is really just used as a way to specify the fields to show in Grid Edit and to have more control over the drop down fields in Grid Edit mode.