General

Re: Dropdown with Headers

Hilary Stoupa — Tue, 24 Nov 2015 18:51:37 GMT

Sorry, I don't understand the question. InfoPath Forms Services (browser forms) are notoriously less amenable to this kind of manual file modification than filler forms. Is your question about how to get the form to open in Filler?

Re: Dropdown with Headers

Hilary Stoupa — Tue, 24 Nov 2015 18:50:15 GMT

Yeah, this working is going to have a reliance on things being sorted by the column you are grouping on when you run the query.

Re: Dropdown with Headers

sovietbiker — Tue, 24 Nov 2015 16:21:42 GMT

It sure would be nice to figure out how to get this to work in the browser version. What is a solution for users to open it from SharePoint 2013 in other browsers besides IE?

Re: Dropdown with Headers

sovietbiker — Tue, 24 Nov 2015 16:17:31 GMT

HI, Yes it was a casing issue. Did you notice on your datasource, if you change resume to the first record before invoice and leave the list with that modification. Job application and Commendation show up under Finance.

Re: Dropdown with Headers

Hilary Stoupa — Tue, 24 Nov 2015 00:58:28 GMT

Oh! I see the issue, I think. You have a casing issue. You sometimes have it cased "iuji" and other times "Iuji". Which is it in the data source?

Re: Dropdown with Headers

Hilary Stoupa — Tue, 24 Nov 2015 00:56:31 GMT

Can I take a peek at your form? attach it under the Options tab... it may be tomorrow before I have a chance to look tho.

Re: Dropdown with Headers

sovietbiker — Tue, 24 Nov 2015 00:41:32 GMT

It doesn't seem to want to group the drop downs. It adds a header over each selection instead of grouping them and adding a header. Following the same code.

Re: Dropdown with Headers

sovietbiker — Thu, 19 Nov 2015 00:45:11 GMT

You are amazing!!!!!

Re: Dropdown with Headers

Hilary Stoupa — Thu, 19 Nov 2015 00:39:28 GMT

P.S. > Thanks for the fun challenge! :)

Re: Dropdown with Headers

Hilary Stoupa — Thu, 19 Nov 2015 00:35:12 GMT

Here is my sample form.

Re: Dropdown with Headers

Hilary Stoupa — Thu, 19 Nov 2015 00:34:22 GMT

Okay - here's a screenshot of my form and list. I got this to work in Filler. My "header" column is named "Target Library". My value column is title. I'll post again w/ my sample (which, of course, won't preview for you because you don't have access to my SharePoint site, but you can look at the secondary data source schema and at my XSLT).

Re: Dropdown with Headers

sovietbiker — Wed, 18 Nov 2015 23:47:23 GMT

Yes, I would make a SharePoint list with a header column and subheader column. I believe could go back to the form to only use the infopath filler as we have an enterprise microsoft license throughout the company.

Re: Dropdown with Headers

Hilary Stoupa — Wed, 18 Nov 2015 23:34:21 GMT

How would you know what options from the SharePoint list had what option group? Would it be another column in the list? You'll be using this form in InfoPath filler?

Re: Dropdown with Headers

sovietbiker — Wed, 18 Nov 2015 23:31:33 GMT

Wow! Very Cool! I wonder how you would do this if you're populating the drop down from a SharePoint list? Thanks for the help! jason

Re: Dropdown with Headers

Hilary Stoupa — Wed, 18 Nov 2015 15:46:58 GMT

One more thing - I was still curious, so I tested in the browser. I'm attaching a screenshot - in IE, Chrome & MS Edge browsers, the optgroup did not display correctly. But it worked in preview & filler, so it depends how you'll be using the form.