Smarter Smart Table Search
CompletedIt would be good to have the smart tab search be able to do a lookup on keywords (partial text) to the lookup table and return a selection of matches to the user who can then pick a record.
Use case: list of equipment specs and associated details
Search based on description for example: "air wall" would search where the lookup field with the logic:
select * from lookup where field like %air% and field like "%wall"
The resulting list would then be displayed if matches exist for the user to select.
This would be extremely useful if the user does not know the exact text they are looking for, the result being to return appropriate details for a class of equipment
-
Official comment
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 -
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).
-
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?
-
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.
-
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.
Thanks
-Ben
Please sign in to leave a comment.
Comments
5 comments