Smarter Smart Table Search

Completed

Comments

5 comments

  • Official comment
    Avatar
    Tony Ruth

    This has been implemented, and any table search that is setup will now show a list of available options to chose from. You can key in a few letters / characters to dwindle the choices and make your selection.

    Comment actions Permalink
  • Avatar
    Adam Rawlinson

    Is it possible to retrieve a list based on a date range? We have a process whereby we're advised of which records to expect based on a date. Therefore, we would like to do a lookup to choose from a list of items with a date of -2 days. (e.g. trucks leave port 2 days before our inspector sees them on site. When performing the inspection, he/she should just be able to pick off the trucks that left the mine 2 days before).

    0
    Comment actions Permalink
  • Avatar
    Tony Ruth

    Hey Adam, the list displayed to the user is not restricted until they begin to filter themselves using the search bar. Perhaps you could add some more data to the "key" field to allow searching by date.

    For example, if you have a value which has "Rock Truck 12345" currently showing in the list, perhaps you can modify that so it reads "January 18 2017 - Rock Truck 12345". This would allow them to search for items that left port 2 days prior by just typing in the date into the search.

    Do you think that might work?

    0
    Comment actions Permalink
  • Avatar
    Adam Rawlinson

    Hi Tony, 

    It works, we were just hoping to automate it so our inspectors could choose them from a list. We were hoping we could return many options and the inspector could choose the ones he/she is looking at, rather than re-entering some data which has been entered in a previous stage in the process. My idea was to use the date as the lookup and retrieve all trucks from that date, the inspector could then choose one off the list and complete it.

    It would also be good to retrieve the list using and/or conditions on the lookup. For example, retrieve trucks with (a date of -2days or -1day) and have not been inspected yet.

    This would be really neat, as the lookup could be automated and our inspectors could pick from a list rather than search for individual items which could require entering multiple fields of data.

     

    0
    Comment actions Permalink
  • Avatar
    Ben Ray

    Hi Adam,

    Take a look at what we have outlined in this link and provide any comments. Based upon what you have shared above I think what we are researching can work for you.

    https://iformbuilder.zendesk.com/hc/en-us/community/posts/360042756051-iFormBuilder-Smart-Table-Search-Updates-

    Thanks

    -Ben

    0
    Comment actions Permalink

Please sign in to leave a comment.

Powered by Zendesk