I want to be able to create a dynamic type of filter based on a field in a table.

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

Example:

I have the following tables.

Model, Main Category, Sub Category1, Sub Category2, Parts List,  ControlNumber.

I have a general search which I can choose by selecting Model, then the various categories and this is fine.  However, the other type of search is when someone enters a Control Number.

This number is made up of sections which will break down to the correct Parts List.

12345xxxyyyzzzb1

12345- Model
xxx - Main Category
yyy - Sub Category1
zzz- Sub Category2
B1 - Parts List form

The idea is that when a user enters the Control Number, they get directed the Parts List pertaining to to only that Model with its connected categories and subcategories.

Any ideas how to start?

Thanks.

Photo of Michael Graham | Insight Global UK

Posted 3 years ago

  • 0
  • 1
Im guessing this might need someone with Javascript skills?
Photo of Rohit Agarwal

Rohit Agarwal

  • 552 Points 500 badge 2x thumb
Hi Michael,

I guess you want to create a search box with a button.
Steps-:
1- Get text box value once you click the button.
2- Hit doQuery API where use this text box value in qlist in order to filter.
3- so, once you click the button your actually hit an API that will give you the result base on your value.


I hope this will work. if not then will provide you the code. 

Thanks,
Rohit