General

Re: Multiple selection box + Substracting cascading dropdown list

little_ghost — Wed, 15 Oct 2014 14:36:14 GMT

I came to the conclusion that, what I want/need,is not going to work anyway because ... well... it's complicated.
Next to the raised question, the form had to post the values to separate columns in a library.
The values had to come from MSboxes and drop-downs and... that doens't work. The only values that got written in the columns where the actual ones that where filled in by hand.
Then there was the whole file attachment problem. I needed to have 1 (minimum, 2 maximum) file(s) attached to the form, uploaded and moved to the library.
Eventually you would have the library with filled columns and the 1 or 2 attachments. When clicked, it had to open/download the attachment instead of opening the form.
Almost all of this works in a library except for multiple attachments, hiding rows on the form depending on input and the whole "cascading intersecting" thing.

Not sure how I'm going to solve the problem now that I came to these conclusions... :(

P.S.
No, as far as I know there is no qRules license available but depending on cost, it might be possible to get it ... still, that would only take care of 1 of the current problems...

Re: Multiple selection box + Substracting cascading dropdown list

Jimmy — Tue, 14 Oct 2014 17:55:07 GMT

This is definitely possible if code is involved, but I'm having a very hard time thinking of any way it could be done with no code at all. There are just too many degrees of indirection.

One way to accomplish this would be to use qRules' Transform command (though it would still require a bit of tricky manœuvering). Would you happen to have a qRules license by any chance?

Re: Multiple selection box + Substracting cascading dropdown list

little_ghost — Tue, 14 Oct 2014 07:55:14 GMT

So far I think/am afraid, it is not possible.
Maybe with javascript, but that does not work in a form.
I can't believe that I am the only one who needs this sort of functionality though ... :S

Re: Multiple selection box + Substracting cascading dropdown list

Hilary Stoupa — Tue, 14 Oct 2014 00:09:52 GMT

Wow - that's a tough one. I've emailed a colleague to see if he has some suggestions. :)

Re: Multiple selection box + Substracting cascading dropdown list

Hilary Stoupa — Mon, 13 Oct 2014 15:57:45 GMT

I thought I was misunderstanding your previous explanation. Thanks for the details - I'll see if I can put together a sample that does this later today.

Re: Multiple selection box + Substracting cascading dropdown list

little_ghost — Mon, 13 Oct 2014 15:38:32 GMT

Not sure what it does though....
When I select something in the box,it just displays a linked item in the drop down (so it looks like); as in 1 item linked per option from box 1.
What I'm trying to accomplish is that every item in box 1 (MXB) has several options linked to it.
When selecting several options from box 1(MSB), only the options that occur in all selected options are displayed in box 2 (DD).

So, for instance:
box 1 (MSB) would have t-shirts, trousers, socks
box 2 (DD) would hold colors:
t-shirts: red, green, blue
trousers: blue, kaki, black
socks: white, black, blue

When selecting:
MSB: t-shirts, trousers
DD should display: blue

MSB: trousers socks
DD should display: blue black

MSB: tshirts trousers socks
DD should display:blue

The way it is now, is that, when selecting options from MSB, it will start to list all available coloroptions in the DD.
So in last case it will list: red, green, blue, kaki, black, white

The data is just to give an idea.

Re: Multiple selection box + Substracting cascading dropdown list

Hilary Stoupa — Mon, 13 Oct 2014 15:32:32 GMT

:) I knew by the error you were opening it in IP. Glad you found "design"!

Re: Multiple selection box + Substracting cascading dropdown list

little_ghost — Mon, 13 Oct 2014 15:18:36 GMT

That is what I tried/am doing :S
When opening it pops up with a security warning with the same location, even though it is saved somewhere else (since D is my dvd-drive).
Then, after clicking ok it gives me the error I previously mentioned.

--edit--

SORRY!!! I did not notice the design option in the right click menu!!! I used infopath to open!!!
Sorry! Sorry! Sorry! Sorry! Sorry! Sorry! Sorry! Sorry!

Re: Multiple selection box + Substracting cascading dropdown list

Hilary Stoupa — Mon, 13 Oct 2014 14:54:30 GMT

Save the file locally by right clicking the link in the header and selecting "Save target as". The right click the saved file and select Design to open in design mode.

Re: Multiple selection box + Substracting cascading dropdown list

little_ghost — Mon, 13 Oct 2014 12:17:10 GMT

I can't open the file. It give me the following error:
This form cannot be opened because it requires the domain permission level and it currently has restricted permission. To fix this problem, open the form from the locations it was published to.
Published location: file:///D:\Documents\Temp\sample.xsn

Re: Multiple selection box + Substracting cascading dropdown list

Hilary Stoupa — Fri, 10 Oct 2014 16:53:20 GMT

Hi - I'm attaching a sample from that does this (I think - if I am understanding correctly) and I just used a pretty simple filter on the drop down. Save the file locally, right click and select design to open in design mode and then you can preview.

Multiple selection box + Substracting cascading dropdown list

little_ghost — Wed, 08 Oct 2014 15:12:38 GMT

I have a multi-select boxe and a drop down but instead of ADDING the choices made in the multi select box to the list of selectable items in the drop down list, I want to SUBSTRACT them.

I'll try to clearify it: if in the multi-slection box you have:
Option A and option B and
in the drop down list, you (depending on you selection) have 2 4 6 8 (options for A) or 4 8 10 12 (options for B).

When selecting BOTH A and B, the drop down liast should ONLY display the values that overlap/exist in both A and B (e.g 4 8).

This would have to work for X number of options in both the multi select box and the drop down list.

Doess anybody know how to make that work?

Thanks in advanced and kind regards!