InfoPath Dev

If you set the query field in your Detention List data connection to the selected date, then execute the query, you should get back just the rows that match. No need to filter in your count formula. :)

I just tried this type of formula in a test form and it worked as anticipated. Offhand, I'd guess that @SPCurFYNum is not equal to SPNewFY - possibly because the data returned by the secondary data connection has decimal points or some other different. Can you drag your secondary data source data fields onto the form and take a look at the ...

Make sure your form is a filler form and it has to be full trust.

Yah, I think the expression needs to be modified manually. Can you open the filter dialog and set it up with Name = Name, then click the first drop down and set that to "The expression" then copy out the XPath that appears and paste it in a reply?

 I am sure that this is probably SO easy but I'm not a programmer and always have problems with syntax in a formula. (all is based on SharePoint Online and InfoPath 2013)  I have a field in a form with a display name of  "Detention Date Requested" (actual name: "DetentionDate"). I want the ...

 First, with what version of InfoPath are you working?

Hi MACWAYNE, To my understanding, you would like to update data from a SharePoint list using a different form aside from the one that is published to the SharePoint site. If so, then you may use code for this approach, or you may want to try qRules's SubmitToSharePointList which will make it a lot easier for you - assuming that you are not ...

Infopath 2013 is fine with 2007.

 Thanks for the response. I actually tried going with the simple 'me.print()' but it gives the following error: 'print' is not a member of 'TestForm.FormCode'.  I included those namespaces because it seemed like I did not have access to any print functionality.  Here's the entire code for my ...