You are viewing limited content. For full access, please sign in.

Question

Question

lookup matching from beginning instead of anywhere

Forms Version 10
Updated November 29, 2018
asked on November 27, 2018

Is there a way to get the forms (single line) lookup to match what the user inputs from the beginning of the value instead of matching anywhere in value? Example:

User types "Mi" and the lookup shows matches for "Mitchell", "Mindy", and "Smith" but we only want it to show "Mitchell" and "Mindy".

0 0

Answer

APPROVED ANSWER SELECTED ANSWER
replied on November 28, 2018

You can change the filter option to filter with starts with instead of contains by modifying following file:

C:\Program Files\Laserfiche\Laserfiche Forms\Forms\lib\awesomplete\1.1.1\awesomplete.js

search for "filter: _.FILTER_CONTAINS" , change it to "filter: _.FILTER_STARTSWITH“

3 0
replied on November 29, 2018

Nice tip.

I was going to suggest creating a stored procedure.

0 0

Replies

replied on November 29, 2018

Worked perfectly - Thanks!

0 0
replied on September 4, 2019

Is there a way to get the dropdown list acts the same as a single line field , so the filtering will be filter: _.FILTER_CONTAINS

I know using single line field in place is working fine but would like to have the arrow also and start the filtering again by clicking the arrow in place to have to delete the value to get back the list as single line does

You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...