Creating a search box on a form

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered

I have a table called line items that is linked to inventory and I select the inventory by either its supplier part #, company part # or its description. Is there a way to create a box that will search for any of those value in an inventory item and populate some suggestions. I know I can do it for reports but I need it on my form. Any help would be appreciated.

Photo of Adam

Adam

  • 0 Points

Posted 5 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 69,814 Points 50k badge 2x thumb
This is a native feature.

You can check the checkbox on the [related item] field Properties

Use a record picker instead of a drop down menu

Then I suggest that you specify a report to use for that record picker so that it will search the fields that you want it to search. Set the standard Record Picker fields for the item table to be those fields that you want to search on.