Newbie Questions

Re: Counting letters in a repeating table field.

Drewski — Tue, 31 Jan 2012 16:39:10 GMT

Stavi great post!

Re: Counting letters in a repeating table field.

sushrut87 — Tue, 28 Jun 2011 12:49:51 GMT

hey stavi,

it helped me.. thanks specially as you gave the steps.

Re: Counting letters in a repeating table field.

smeccy24 — Fri, 15 Apr 2011 05:20:21 GMT

Thanks Stavi this helped me too!

Re: Counting letters in a repeating table field.

ilse — Fri, 24 Nov 2006 11:13:38 GMT

Stavi !! You are amazing, it works like a charm. Thank you so much!

Re: Counting letters in a repeating table field.

Stavi — Fri, 24 Nov 2006 10:35:26 GMT

count(fieldname[fieldname = "A"])

To enter this formula double click the text box for the total, click the fx button by default value, click insert function, double click count, double click the insert field, choose your field from the repeating table, click filter data, add a filter to select the same field which equals the letter you want, click ok 4 times, make sure the "update this value when result changes" box is ticked, click ok. Repeat for each letter

Re: Counting letters in a repeating table field.

ilse — Fri, 24 Nov 2006 10:17:00 GMT

Thanks Patrick,

That would have been a good idea but the values change. It is a single character but it will change from day to day. Today it might be an A but it could be an H tomorrow. I am still no master of coding. I Google a lot a through trial and error and the occasional fatal error I sometimes accomplish what I was looking for. If you or anyone else can push me in the right direction with coding, again I would be most grateful.

Kind regards,
Ilse

Re: Counting letters in a repeating table field.

Patrick Halstead — Thu, 23 Nov 2006 19:45:49 GMT

Hi Ilse,
Is the field a single character or a string of characters? If it is a single character, just double click on the field in the designer and add 5 rules - 1 for each letter condition - that check the string (the condition) and then have an actino to set another field to it's existing value + 1. This won't support edits (since it will keep incrementing). For that, you'll need to have an OnBefore and OnAfter change event handlers. There's probably a way to prevent double increments using rules, but I need to go prepare for Thanksgiving holiday ...

Counting letters in a repeating table field.

ilse — Thu, 23 Nov 2006 15:26:30 GMT

I have a repeating table and I want another field to give me the sum of all the letter A#%92s for example are in that field.

We will only be entering an A, C, H, R or X and I need 5 different fields to count each letter. We used to have this in Excel and the formula in there was =COUNTIF(C8:C115,"a") but countif is not a function in IP. How can I make InfoPath count my letters?

Thanks.