Skip to main content
Question

Record Picker in Grid Edit

  • Feb 14, 2025 9:48 PM UTC
  • 2 replies
  • 129 views

Forum|alt.badge.img+8

Has anyone found a way to improve how the record picker works in grid edit?

Say you are looking for the item that starts with CDV, When you type C it takes you to the beginning of the "C's" in the list and then when you hit D it jumps to the "D's" and so forth.  When even using the default record picker in a form it doesn't have that behavior.  I also tried creating a form for Grid Edit with a report for the picker and still reverts to single letter picking. 

Any ideas would be appreciated! 

2 replies

QuickBaseJunkie
Forum|alt.badge.img+15

I find you have to be very fast to get to include a second or third character. So CDV would need to be entered all together very fast to jump to that entry... but it is possible.

You are correct that you can't set a report to use for the record picker in Grid Edit or make it behave like forms where it searches the list. That may change when they release the new "Spreadsheet Edit" functionality (to eventually replace Grid Edit), but that isn't available yet. More on it should be shared at Empower at the end of the month.

-Sharon


Top Step
Forum|alt.badge.img+12
  • Observing
  • Nov 10, 2026 7:24 PM UTC

Sharon was right that Grid Edit couldn't use a report for the record picker, and that the newer spreadsheet-style editing might change that. It has since shipped: grid reports became generally available on May 21, 2026, replacing legacy table reports and Grid Edit, and they let you override the record picker for each report.

 

If your app isn't on grid reports yet, the switch is App Settings > App Properties > Advanced Settings > Use grid reports in this app. That applies to the whole app, so test it first.

 

Then open a standalone grid report from the Reports dropdown, open the More menu on the reference (or reference proxy) column, and select Column properties. Under Record picker, choose Based on report to show the filtered records from a report on the parent table, or Based on field to use a lookup field from the child table. Apply and save the report.

 

A filtered report keeps the list short, so there's less scrolling to reach the right item. Column properties can't be set from default reports, table home pages or embedded reports.

 

Release notes:

https://resources.quickbase.com/nav/app/bu9ax9c5r/table/bu9a2h65e/action/dr?rid=684&ifv=1

https://resources.quickbase.com/nav/app/bu9ax9c5r/table/bu9a2h65e/action/dr?rid=661&ifv=1

https://resources.quickbase.com/nav/app/bu9ax9c5r/table/bu9a2h65e/action/dr?rid=835&ifv=1

 

Want more detail? I wrote a full walkthrough here: https://www.topstep.tech/blog/quickbase-record-picker-grid-reports-forms