We have created a report option to lookup a customer. Is there a way to have a search box that if you were to type FA all the records that the search name started with FA would come to the top of the list?
Date
Votes
6 comments
-
Jet Reports Historic Posts Official comment hi,
if the searchname is in the first column of your lookup-window, you can type in there, but only the first letter.
So with "FA" it will not work.
Did you look at my Suggestion? Give it a try…
regards
jetsetter -
Jet Reports Historic Posts You would need to have the user enter in "FA*". Not sure you can have a look up go to the database AND also supply values for the user to choose from.
For example, you may want to have custom items for the user to choose from which would be something like: NL("Lookup",{"Red","Green","Blue","Orange"}, "Colors").
Again, I don't think there is a way to say "lookup from this table in the database or these other values". -
Jet Reports Historic Posts We have created a report option to lookup a customer. Is there a way to have a search box that if you were to type FA all the records that the search name started with FA would come to the top of the list?
Type ahead will work. But only on the first letter!
So if you type FA it will try to select the first item that starts with F and then the first that starts with A. Not good…
But it will never filter the list to only items that start with what you type.
HTH
rmw -
Jet Reports Historic Posts hi,
what about another option for the filter in the lookup?
like attached file
does that work?
regards
jetsetter -
Jet Reports Historic Posts Type Ahead will work? how would that be set up .
-
Jet Reports Historic Posts thanks jetsetter. I finally got it to work. That is exactly what they needed
Please sign in to leave a comment.