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

Question

Question

Lookup Field with Free Text

Forms
Updated June 12, 2014
asked on June 11, 2014

Hey,

 

In Forms, is it possible to have a field mapped to a database, but with the option to type in free text values as well? I imagine it's probably the same as regular fields in Laserfiche but I was just curious :)

 

Thanks!

Dom

0 0

Answer

APPROVED ANSWER SELECTED ANSWER
replied on June 11, 2014

Yes, it's possible to do this. Just use a text field (or other field that allows typed input) as your source for the lookup.

0 0
View 1 previous reply
replied on June 11, 2014

Hi Aaron,

 

I did try this - I think the problem is the size of the list is quite big and therefore may be taking a long time to populate. Let me try again with some other data sources and get back to you

 

Thanks

0 0
replied on June 12, 2014

Hi Aaron,

 

It looks like there is some sort of limit to how many values the text field can deal with, and without a slider to navigate the options it wouldn't work with the amount of values I would be dealing with.

 

Thanks,

Dom

0 0
replied on June 12, 2014

How many values are in your database table? Are you saying that the whole lookup isn't functioning because of the amount of values being returned? If that's the case and you're using forms 9.1.1, you could try disabling the autopopulate behavior. This would, of course, restrict users to performing the lookup only by typing in the value.

 

"To disable the auto-suggest behavior, add the DisableAutoPopulateIn91 setting to the cf_options table in the Forms database and set it to true. You must restart IIS for this setting to take effect. Background: In Forms 9.0, drop-down fields auto-suggested but single-line fields did not. In Forms 9.1, both drop-down and single-line fields auto-suggested. In Forms 9.1.1, you have the option to turn off the auto-suggest behavior by adding the aforementioned setting to the database. (111262)"

 

Source: https://support.laserfiche.com/KB/1013414

0 0
replied on June 12, 2014

Just checked it now, just shy of 8000... ! Yeah it won't bring back the list with a single-line field. I tried the recommended solution with no luck. 

 

I will just add an extra single-line field alongside a drop down it's no problem!

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...