Hi i had designed an infopath form which uses a repeating table. Now there ia a text box in the table. I need to show the Repeating table count in the Text box
Like the Qs number and the Questions are Repeating so the text box becomes the Qs Number
Please Help
KalyanGReddyMVPGGKTec wrote:
Hello Petka,I believe you are using a repeating table for this.
10-Jul-07
Hello Petka
I believe you are using a repeating table for this.
Open the text box properties and use the count function for this
Add a filter when you are adding the fiel
The filter should be when the field is not blan
The formula should look something like <count(field11[. != ""])> where field
11 is the Field in the repeating table which has the responses
Hope this helps yo
Let me know if you are able to do this else I can give more specific steps
--
Kalyan G Reddy - INFOPATH MVP 200
http://www.ggktech.com
:
Previous Posts In This Thread:
Calculated Field
Hello
I would like to create a calculated field with using the function sum or
count, but I cannot find out how to do this.
I have about 5 text fields where the values are inserted and one text field
where the result of sum or count function should be displayed.
Could you please let me know how should I set up these text fields
Thank you in advance
Petra
HelloDouble click on the Text box where you want the Sum/Count of Click on
Hell
Double click on the Text box where you want the Sum/Count of
Click on the Fx button at the end of Value field under default Value in the
data Ta
Click on the Insert Function and select Sum and then Insert the fields you
want to add/Coun
The Formula should look like this ...<sum(field1) + (field2) + (field3)
Click OK two times to save the change
Hope this will help yo
--
Kalyan G Reddy - INFOPATH MVP 200
http://www.ggktech.com
:
Hi,thanks a lot, it works fine for sum function now.
Hi
thanks a lot, it works fine for sum function now
What about the COUNTA function? I didn't find this function within InfoPath.
What I would need to do is to count how many responses where applied e.g. for
column YES and for column NO
So, the example
YES NO N/A
x
x
Total 2 2
Any thoughts
Thank you so much for your help
Petr
:
Hello Petka,I believe you are using a repeating table for this.
Hello Petka
I believe you are using a repeating table for this.
Open the text box properties and use the count function for this
Add a filter when you are adding the fiel
The filter should be when the field is not blan
The formula should look something like <count(field11[. != ""])> where field
11 is the Field in the repeating table which has the responses
Hope this helps yo
Let me know if you are able to do this else I can give more specific steps
--
Kalyan G Reddy - INFOPATH MVP 200
http://www.ggktech.com
:
Hi Kalyan,I am totally confused by repeating table.
Hi Kalyan
I am totally confused by repeating table. If I want to insert this table,
it's just allowed me to insert a specific number of columns, but not the
number of rows. But ok, I just set up the number of columns. I have got two
rows, the first row is something called "header row" and under this row is
another row with a fields. I am able to add footer row and header row, but
how can I add the row with the fields
What I have just tried is that I have added footer row, and insert text
boxes into this row. I have repeated this step till I got the number of rows
which I need. But if I have been trying to set up the count function for the
Total field (the one, which was inserted automatically by inserting repeating
table), it doesn't allow me to do this after I set up the filters. It always
says: "A filter cannot be applied to the currently selected field. Select a
different field." If I select a different field it says: "A filter is
specified on the selected field or group. Changing the selection will remove
the filter".
What's wrong?
Petra
:
HelloThere is no reason to get confused with the repeating table.
Hello
There is no reason to get confused with the repeating table. It allows you
to add any number of columns. Also You need not add the required number of
rows in the design view. You can add while filling out the form using Insert
Link .
and You cannot add the filter on the field you have selected. You have to
add the filter on the field where you want the count. and you have to select
the fields from where you are actually counting. In your case I guess you
have to set filter on the Total field as you have shown in the Example.
Hope I have cleared your confusion. Let me know if it helped you
--
Kalyan G Reddy - INFOPATH MVP 2007
http://www.ggktech.com
:
Submitted via EggHeadCafe - Software Developer Portal of Choice
0x80005000 Exception IIS and Windows 2008 Server
http://www.eggheadcafe.com/tutorial...a9-8847b82a7ae4/0x80005000-exception-iis.aspx