PDA

View Full Version : Create a dialogue prompt to filter down data?



Smeghead
04-01-2015, 03:42 AM
I'd like to create a button which I can press and it will bring up a prompt, which I can type stuff into and it will basically filter the data down to what I type in. This is what the spreadsheet looks like (the data starts on row 7), and I've included a mockup of what I'd like the prompt to roughly look like.

oi61.tinypic.com/14npmhk.jpg
oi61.tinypic.com/2vado9e.jpg


Ideally, I'd like the prompt to have the fields in that order, or at the very least have it so that each press of TAB will skip me to the same field as on the mockup.

All the fields could be a mix of numbers or letters, and vary in length with the exception of the FIT, which is either a dash (-), or a letter R,L or S.

The data returned needs to be exactly as typed in. Some styles could be very similar (e.g 2 styles might have all the fields the same except one might be S194, and the other just 194). If it doesn't match exactly what's typed in, it'd be nice to have an error message pop up (or some other kind of text which is displayed if a popup isn't possible).
Many thanks!