Discussions

Expand all | Collapse all

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

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

    Posted 08-26-2016 10:47

    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.



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

    Posted 08-30-2016 09:33
    Im guessing this might need someone with Javascript skills?


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

    Posted 04-11-2017 23:49
    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