I have done this before but don’t know how to set it up.
I have a select/dropdown field where I select a product. But since the list can be very long, I would also like the user to be able to just enter the number
How do I do this?
The simplest way might be to use a select 2 with search and concatenate the product name and number in the field.
Untested code:
Automatic lookup: Select productID, sc_concat(ProductName, ’ - ', ProductNumber) from products order by ProductName
With the ProductNumber displayed next to each ProductName, if the user types the number into the select2 search box, it will filter to that entry.
It could probably also be done with another field where the user could select the product number, then use AJAX events to update the other field when either one is changed, but the first option of concatenating the number with the name seems a lot simpler.
TY it works… (I need 20 characters)