Question

In Forms, how can I fill a Single line with suggested values and prevent submission unless the value matches something in the DB?

Forms

Updated August 8, 2016

asked on June 25, 2015

I would like to do the following:

Create a Single Line field
Tie that Single Line field to a database lookup so that as you start typing values in to it, it "suggests" values for you to click on and autocomplete
Disable the "Submit" button unless you actually typed in a value in the database

I definitely need Javascript to do all this. Any ideas?

2 0

Replies

replied on June 25, 2015

Does it have to be a single line field? Can you use a drop down field with a lookup rule tied to that database?

1 0

replied on June 13, 2016

Did someone make it works?

I want to enhance the look and fill of the drop down list create by a database lookup.

too much choices and the customer would like to be able to do a search or live search from that database list

Do you have suggestion

1 0

replied on August 8, 2016

guess not...

0 0

replied on June 25, 2015

If you can use a drop-down list as Alex questioned, you can implement chosen.js to add a filtering ability to your drop-down fields so as the user types it will filter options that match the values entered. See this post: https://answers.laserfiche.com/questions/73762/How-to-Add-CSS-Class-to-Select-Field

0 0

replied on June 25, 2015

Note that you can still type into drop down fields and it'll select a matching value without using chosen.js. However, using chosen.js might add more functionality and allow for a different UI if desired.

1 0

replied on June 26, 2015

I implemented chosen.js on a drop down. The field format changed but my LookUp Rule does not pull from the database with this UI only options I explicitly add to the Drop Down box.

0 0

replied on July 2, 2015 • Show version history

I am expecting there to be about 1000 possible values, so a drop down isn't necessarily preferred. I thought I saw something similar implemented with Single Lines before.

0 0

You are not allowed to follow up in this post.

Question

Question

In Forms, how can I fill a Single line with suggested values and prevent submission unless the value matches something in the DB?

Replies

Sign in to reply to this post.