Newbie Questions

Re: Counting Number of Occurrences of Attachment Controls Where File Attached

angieong — Sat, 09 Nov 2013 06:13:54 GMT

My issue resolved. Thank you.

Re: Counting Number of Occurrences of Attachment Controls Where File Attached

angieong — Sat, 09 Nov 2013 02:30:48 GMT

Hi Jimmy, Can you guide me how to count the attachment step by step? Now i designing infopath with repeating attachment. I only want to validate at least one attachment make sure user has attached. If user click add attachment to insert extra attachment, then 2nd attachment is going to validate as well. Moreover, the empty attachment can ignore the validation?

Re: Counting Number of Occurrences of Attachment Controls Where File Attached

jeffkinzer — Thu, 13 Sep 2012 21:12:35 GMT

Great information, thank you!!!

Re: Counting Number of Occurrences of Attachment Controls Where File Attached

cbrown00 — Tue, 28 Oct 2008 04:06:10 GMT

Jimmy...worked liked a champ!...thanks

Re: Counting Number of Occurrences of Attachment Controls Where File Attached

Jimmy — Mon, 27 Oct 2008 05:10:56 GMT

Supposing you had a file attachment control bound to /my:myFields/my:group1/my:group2/my:fileField, where my:group2 is a repeating group, you can find the total number of file attachments in the group with

count(/my:myFields/my:group1/my:group2/my:fileField)

Note that this is only for explication and you don't have to type this all by hand. In the InfoPath expression builder, you would just click "Insert Function...", select count, double-click the underlined part and select the attachment's field.

This would also count the number of file attachments where a file isn't attached, so to count only the attachments that have a file attached, you can use:

count(/my:myFields/my:group1/my:group2/my:fileField[. != '']) <-- note these are two single quotation marks '', not one double quotation mark "

You could also apply the "cannot be blank" property to the fields to ensure that they all have a file attached. Now if you want to add up the counts of file attachment fields in several repeating groups, you can sum them all up in an eval function,

xdMath:Eval(., "count(my:group1/my:group2/my:fileField1[. != ''])+count(my:group3/my:group4/my:fileField2[. != ''])+count(my:group5/my:group6/my:fileField3[. != ''])")

Note that in this case, the node paths do not begin with a forward slash, because they are all relative to the starting node (just a dot here, indicating the root node.).

You won't need to worry too much about the details if you use the buttons and dialogs to insert the functions and nodes.

Counting Number of Occurrences of Attachment Controls Where File Attached

cbrown00 — Mon, 27 Oct 2008 04:08:27 GMT

I'm using 5 attachment controls scattered across a form. Each has a repeating group so multiple files could be attached at each attachment control. When a user completes the form, I would like a control to count how many of the files have been attached and use that ensure none of the files are missed.

How can I count the number of instances where a file has been attached? It should count the total number of files attached.

thanks