I've created a simple app that will allow our Order Entry team to select a customer and then retrieve their pricing.
At the moment I have a dropdown box linked to the Customer SharePoint List with the dropdown items set to Customer Name.
They select the customer from the dropdown list and press "get pricing" button and a data table linked to the Price SharePoint list is filtered based on the corresponding Price Group.
Customer | ||
Customer Name | Price Group | |
ABC Customer | QM | |
ABCD Customer | BB | |
EFG Customer | QM | |
HIJ Customer | CC | |
Price | ||
Price Group | Product | Price |
QM | Product A | 1.00 |
QM | Product B | 2.00 |
QM | Product c | 3.00 |
BB | Product A | 1.20 |
BB | Product B | 2.20 |
BB | Product c | 3.20 |
CC | Product A | 1.50 |
CC | Product B | 2.50 |
CC | Product c | 3.50 |
It works ok except the Customer SharePoint list contains 500+ customers which makes the dropdown list very long.
I'd like to have a dropdown where the user can type the customers name and the options in the dropdown box filter by what they are typing.
For example if they typed "ABC" then they would see customers ABC Customer & ABCD Customer in the drop down. Or, if they typed "IJ" they would see HIJ Customer in the dropdown.
Please can someone point me in the right direction on how to achieve this?