-
I think you maybe are trying to open the file instead of downloading, right clicking and opening in design mode? https://www.infopathdev.com/forums/p/28565/98301.aspx has a discussion on this. https://support.office.com/en-us/article/create-a-cascading-list-box-1702993d-d670-4d9b-8063-acabacb76605#bm3_2 has info on how to create an XML file - ...
-
Completely possible - just need to add a filter to the dropdown. So that means the values will have to move from being hard coded (entered manually) to a secondary data source - but that can be an XML file in the form, so it isn't like you have to set up a SharePoint list for them. See attached sample - save locally, right click and select ...
-
Wonderful - glad you were able to find and fix the issue!
-
How frustrating! Do you mind attaching a copy of the form? I'll try it on my machine and see what happens - I've been running Windows 10 for a while now. You can attach your template to a reply under Options.
-
I used it for the default value for Journal Accounting Date? Sorry - I thought that was where you needed it?
-
Right, it has to have the month data connection - did you try the version of your form I posted to my last reply? It has the formula as a default and already has the data connection added.
-
-
In my form there is a secondary data connection to an XML file that has the Month names. If you look at the formula with the XPath showing, you'll see:
xdXDocument:GetDOM("month")/Months/Month/Name[../Number = substring(xdXDocument:get-DOM()/my:myFields/my:field1, 6, 2)]
Attach a copy of your form to a reply if you'd like ...
-
I am not sure I understand this question - that's why I've hesitated to respond. :-) What are the things that change in the form? Fields are re-positioned every year? Or maybe just labels in the form change? If it were just labels, those could be made dynamic and pulled in from a secondary data source to cut back on required form ...
-
I'm using a substring formula to get back just the month from the date so that I can match that to the month number in my XML data source to return the name of the month. If I want to get the year from a date field, I can do that with a formula like this:
substring(field1, 1, 4)
So, if I wanted the Month name and the ...