Form field is set to a report to select the "job number" that I want to select. The report filters out expired job numbers In grid edit, this field shows all job numbers.

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I only want non-expired job numbers to show up for selection while in grid edit. Please advise
Photo of Lynne8817

Lynne8817

  • 530 Points 500 badge 2x thumb

Posted 2 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 62,994 Points 50k badge 2x thumb
OK this is perhaps non well known, but to control the report which gets used in grid edit for a filtered drop down, you actually need to make a new dummy form with the fields on the form being the columns in the grid edit.

I always call my form a name like Grid Edit.

Then go to Forms usage and set that form to be used when used in gird edit in that report which is being used in the regular form.

What will happen is that when the report is being used in grid edit mode, you will not see the normal report columns, but the control will be done by that dummy Grid Edit form.