I have drop list which use lookup table to get list, my Q. how to make search to reduce this list depend on my search ... thanks
When using a drop-down field, when the list is pulled up, the submitter can type a letter to jump to options that begin with that letter, but that's the only option for moving through the list faster there.
Alternatively, you can use a Single Line field and populate it from your data source (via Lookup Rules), and it will have a drop-down type of functionality too. Then, submitters can type multiple characters into the field, and the drop-down list should be filtered to those options that contain the characters they typed.
The Single Line field is a little more risky, however, because submitters don't HAVE to select from the drop-down (they'd have the ability to just type whatever they want in the field and submit).
If you have some way to group your lookup values, then you could use a combination of multiple fields to trim down the options, while still using a drop-down type of field and requiring a selection from there (no ability to type anything else).
For example, if I have a lookup list of 300 vendors, I could perhaps group them by State. Then, the submitter would select the state in one field, then the vendor field could be a drop-down that only shows vendors for that state (instead of ALL vendors). I could also group them alphabetically, and in one field the submitter could select the first letter of the vendor name, then the other field could only show vendors that start with that letter (instead of ALL vendors).
Thanks ... working better now
Hello,
Please is there a way to create that Dynamic Listfield that displays options based on the content of another field.
For instance, Select Department and have all Names in that Department populate the List Field
Can someone kindly provide a step guide on how to achieve this.
Thanks in advance
Hi Adeyemi,
Are you talking about Lookup rules? It's configurable in the form very easily.
Yes i think. I want to be able populate a dropdown field with list of LF Users (Repository Users etc) just so i can select them.
I have a form that We use to generate Internal Memos and part of the field is Send To. That Send To field is supposed to be a drop down list of all Laserfiche users so we can select and then route the form to that person.
Then I think lookup rules is what you are looking for.
ThabKS Zhiyong.. yes I know it's ok up rules but I need guidance on how to set it up with Lookup rules. What expression to use or token etc.
Thanks.
Sorry for that, we have official documentation how to use Forms features, e.g. the lookup can be found here https://doc.laserfiche.com/laserfiche.documentation/11/administration/en-us/Default.htm#../Subsystems/Forms/Content/Lookup-Rules.htm?Highlight=lookup%20rule, you can also find other features from left menu.