InfoPath Dev

Looks like you aren't filtering the data in your sum function. You are hiding rows on the form, but the data is still present in the secondary data connection. The sum function needs to have the field filtered in the same way as you are filtering your repeating table. You may want to change that total_inspected field to a decimal, so you ...

The search form may not pull data properly for external users, but here is the file.

So - can you attach a copy of your form under the Options tab? I can take a look.

I think that would likely be simplest.... I've not done this w/ SharePoint workflow, but I'd think MS Flow would make quick work of it. Are you using an On-Prem SharePoint server? Or Office 365 / SharePoint online?

Just following up, screenshot of the inspected cell. The actual value here should be 117. In the field's default value I have "sum(inspected)", where inspected is the field's name under datafields in the Secondary Data Connection fields.

I am using Office 2016. But I am assuming my best option would be SharePoint workflow (or MS Flow, if on Office 365) to parse the semi-colon delimited info into individual items. Correct?

I'm currently working on a form for a department supervisor. Product is inspected and submitted to a sharepoint library via a different form, and this current form will pull the data between two specified dates and show the supervisor monthly totals such as how many pieces inspected, how many rejected, % rejected, etc. I currently have a ...

Thank you I will give this a shot and report back.

I think the challenge here is going to be creating the rules in such a way that you don't end up with an error about rules looping. Instead of allowing multiple people to be selected in the person / group picker, I'd probably put the person / group picker in a repeating section, so each section only had one person, then I'd add a field ...

The node for the checkbox needs to go inside the choice group. May I ask why you are creating your schema outside of InfoPath? It would be much simpler to start with a blank form and design the schema inside IP instead.