Page 1 of 1
autosuggest in 3 different fields
Posted: Fri Sep 30, 2022 1:18 pm
by konfuzion
[ORDER] table
Field1, Field2, Field3
itemcode, fruit, quantity
Using autosuggest, if type in itemcode "12423", autosuggest will enter "apple" in fruit and "5" in quantity
Currently the functionality is almost there since there are 4 Display Fields that could be used as values, but just need to put into the correct different fields.
Any hint on how to do this? Or should I start to study the autosuggest function in the php and build my own solution?
Re: autosuggest in 3 different fields
Posted: Fri Sep 30, 2022 2:08 pm
by konfuzion
actually I meant SELECT & LOOKUP table
after selecting "12423", the display views will insert "apple" in fruit field and "5" in quantity field
Re: autosuggest in 3 different fields
Posted: Fri Sep 30, 2022 2:10 pm
by arbei
You may enable Force Selection and AutoFill, see Edit Tag and Lookup Table for details.
Re: autosuggest in 3 different fields
Posted: Fri Sep 30, 2022 2:45 pm
by konfuzion
Thank you, AUTOFILL is the solution THUMBSUP