-
By unique type do you mean the type the user selects with a dropdown, not file type?
-
I may not be understanding. Is this a SharePoint List form? When you say "list view" do you mean the default view of the list in SharePoint? If so, I'd just add another column, default it to the value of the selected date / time, and format it to show only the date value. Modify the default view to show those columns (formatted as ...
-
Oh how weird. What are the advanced settings on the library? Do they match a library that works correctly?
-
Wonderful - glad that worked!
-
Thank you for the follow up - interesting work around for the issue, but glad that quotes around the 2nd param of the substring function make it behave. :)
-
Here's the template with my formula in place. I wonder if the issue you are experiencing is perhaps a difference due to the language on your OS?
-
My column names were changed when I created a list from your template - so the formula looks a bit like gibberish, but here is a screenshot of this formula working without an issue for me. I'll attach my copy of the template in another reply.
-
To be clear - once your formula is referencing a secondary data source, the relative path of "." is now relative to the secondary data source. I've not seen InfoPath change punctuation in a formula before. I'll take a look at your files.
-
I think you just need to use current instead of "."? Did you try that?
xdXDocument:GetDOM("sp-list-connection")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:list-column-requested[starts-with(../d:1st-column, "data-as-filter") and ../d:2d-column = number(substring(local-name(current()), 2. ...
-
Maybe they could also try updating their cached form? Open InfoPath Filler, under New, find the template, right click and select Get update or Remove?