I am creating a form that uses a collection so that someone can attach information on multiple pieces of equipment to the same form. The issue I am running into is that the customer has the request that one of the dropdowns within the collection, filled from a SQL lookup, allow the user to select multiple values. I don't believe this functionality is available in Forms 9.1.1. Usually in this situation I would use a table so they could add multiple rows however tables within a collection are also not available in Forms 9.1.1. Does anyone have any good ideas on how to overcome these limitations?
Question
Question
Replies
Hey Beau,
Not the most elegant workaround, but if you create multiple dropdowns and perform a lookup to fill the values for each of them, you can then use field rules to hide the additional dropdowns until theymake a selection for the previous dropdown.
So for example, let's say you make dropdown fields A, B, and C. When A does not have a value selected, hide B. When B does not have a value selected, hide C. Once a value is selected in the initial dropdown, that will show field B, and the same will happen from B to C.
Let me know if this doesn't work for your situation, and I'll see if there's any other workarounds available.
Rob, thanks for the suggestion. I ended up doing that as the department agreed on a maximum # of values they would select, adding that many dropdown boxes (e.g. Option 1, Option 2 Option 3), and hiding the ones they didn't need. I would still love the option of allowing multiple selections from a dropdown, as well as being able to put a table inside a collection, but until then this will do. Thanks again for the help.
Laserfiche,
Any chances of getting the ability to select multiple values from a dropdown and/or ability to put a table inside a collection in the upcoming versions of Forms. I didn't see them in 9.2 but am hoping it is in a future rollout.
I just ran into this... do you know if this feature has been added?