-
For those interested - the solution was:
Set all date formats to yyyy-mm-dd (you may need to change the format saved when using Access DB tables)
Convert
date to integer in a second field using :
number(concat(substring(string(xdDate:AddDays(xdDate:Today(), -365)), 1,
4), substring(string(xdDate:AddDays(xdDate:Today(), -365)), ...
-
For those interested - the solution was:
Set all date formats to yyyy-mm-dd (you may need to change the format saved when using Access DB tables)
Convert date to integer in a second field using : number(concat(substring(string(xdDate:AddDays(xdDate:Today(), -365)), 1, 4), substring(string(xdDate:AddDays(xdDate:Today(), -365)), 6, ...
-
Hello everyone,
I have created a infopath which will contain attachments(single/multiple) for a custom list. And created a document Library with Document Set Content Type enabled.
I need to have a workflow which will create a document set every time a new item is added in the infopath list. and the attachments need to store in the document set ...
-
Hi,
I am trying to get Multiple Values in my "Activities" _Multiple-Selection_ look up field pre-selected - based on the value choosen in the "Role" look up _Dropdown_
Example:
Chose ValueA in the "Role" Dropdown and Values One, Two will be selected in the "Activities" _Multiple-Selection_ ...
-
Is not blank is written like:
!= ''
You can learn what the actual expression looks like by first using the drop downs, then setting the first drop down to "The expression" and you'll see the actual XPath in the field next to the drop down. :)
-
I was stumped by the limit of 5 conditions as well. I have a requirement to fire an error if the string in a text box doesn't start with P, A or Q.
Of course I also need a "is not Blank" operator as well to prevent the error after populate. That would total 6 conditions.
Is there an operator for "in not Blank"?
-
Is an operator for the does not begin with function?
-
Hi All
Sorry if I'm covering old ground for you guys but I've been banging my head on wall with this and I'm beginning to think it's not possible.
The situation is: I have an Infopath form attached to a list with custom columns in SharePoint 2010 that contains various fields to populate new items in to ...
-
on a user's machine, we removed INFOPATH. since that time, when he clicks on the LINK in a task email (to view a submitted InfoPath form), it opens in IE but just displays the XML and does NOT render. When I log into his machine and click the exact same link, it renders fine. if I add ?OpenIn=Browser after the link, he ...
-
Just wanted to update this thread - we got this squared away - just needed to add the conditional formatting to the table row to hide the preceding-sibling if the they were the same category, and set the formula for the summary of expenses to use the absolute XPath to the cost.