Multi select with thousands of records

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • In Progress
I have a mutli-select field referencing about 32,000 records. Any tips on how to make it go faster? 
Photo of Jake Klinvex

Jake Klinvex

  • 70 Points
  • excited

Posted 1 year ago

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

QuickBaseCoach App Dev./Training, Champion

  • 59,768 Points 50k badge 2x thumb
You could rework the app to have that be a proper child table where users would add multiple child records. It could be the join table in a Many to many relationship.

If you describe the business purpose maybe there is a more traditional approach which would thus have b enter performance.
Photo of Kipp

Kipp

  • 258 Points 250 badge 2x thumb
My understanding was that multi-select fields are limited to having a maximum of 100 choices, is that no longer the case? (I ask with hope!)
(Edited)