Grid Edit - Browse Choices Workaround?

Question

Hi everyone! I'm wondering if anyone knows at what # of records does the grid edit field decide to display 'browse choices' vs being able to search directly within the cell? I'm guessing 1000 but I'm hoping there's a way to bypass this issue...

For example, we process invoices for multiple customers with each customer having it's own app. Based on the rule that a store has many invoices, I can enter all invoices directly into a grid edit report for the customer with ~900 locations and the store number will autopopulate in the field just as it would when I add a new invoice through the form itself. I wanted to recreate this with a customer with ~1600 locations as I was super excited to streamline the process even more (currently entering invoices into excel then uploading into the invoices table) but when I created the same report in the app it will not autopopulate the store number. Instead gives me one option to 'Browse choices' then search for the store number in a new window.

Is this because there are too many related stores to populate in the dropdown menu or could it be that I need to adjust some options in the field itself?

------------------------------
Marissa Zepeda
------------------------------

MarkShnierYou · Answer

Yes, the cut off is 1,000 records. Above that they force the dreaded record picker. They have to have some limit as what if you had 1 million records, that is too much to populate to a drop down list.

A possible work around is to make this a conditional drop down where you first enter the first letter of the store name, and then the dropdown list would be much smaller. Or select a range like A-L or M-Z. This would take some easy setup, but might be worth it.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community