-
If you set up the filter using the UI - select @SPCurFYNum and "is equal to" and SPNewFY, then change the first drop down to "The expression" you can manually add the substring-before bit.
-
max(@ReqNum[substring-before(@SPCurFYNum, '.') = SPNewFY])
-
Would that be "substring-before(max(@fieldname, ".")" -OR- max(substring-before(@fieldname, ".")
-
Well - you don't have to do anything for the Request Number, just for getting that Fiscal Year filter to match. So you could use substring-before on the "." in the FY from SharePoint.
-
Hello,
I have a sharepoint list which has categories and subcategories as columns. I am trying to create the infopath form to show the category. The based on whether or not the category has a subcategory, I want to populate the drop down list for the subcategory list.
For ...
-
Hillary,
Hello. I followed your suggestion and dragged the FY and Request number columns data in from the secondary data connection SharePoint 2007 site library into the form template. I ran a preview and the data in these columns comes in with ".000000000" after the actual number data, so the Fiscal ...
-
I noticed just today that the person group picker control was not available when I tried to create a template part for reuse. Is this by design?
Thanks!
-
Hi Everyone,
I joined this board because I've seen a lot of good tutorials and tips here that have helped me overcome some obstacles when I build my forms, however, I am stumped on this one issue so I am a first time poster.
SCENARIO:
A user submits an infopath browser filled form. The form gets submitted into our form library. We have ...
-
Right, that returns the items that match. Then you use the count function to count them....
-
That returns each item but not a count. I only need to know how many records/list items currently exist with that date.