Adding fields from a dinamic table

[Former Member]

hi to all:

I am developing an adobe form that is filled up by information form a RFC. Some of these infomation needs to be displayed on tables; so these tables grow dinamically. The thing is that i placed a field at the end of each column to store the sum of the values of each column´s fields. I was thinking in using Javascript for this. I´ve been looking in forums for these specific topic but i haven´t find a guide for my problem. Can anyone give some help or code for this, i will apreciate it a LOT!

thanx,

Cesar R.

Honduras

[Former Member]

hello,

Is the number of fields in table grows dynamically or number ofrecords grows dynamically.

Could you please let us know the adobe designer version.

pavan meda

[Former Member]

Hi:

The records grows dinamically, and I´m using adobe designer 7.1.

thanxs,

Cesar R

[Former Member]

Hi,

Do as below.

Design the hierachy as below in the body page.

Table subform
   |---Header subform 
   |---Data subform
   |---Footer

In the table 3 fields (field1, field2, field3)are there and you have to calculate totals for field2 and field3.

Place 3 fields ( total1 , total2, total3 ) in the subform footer and give binding as none.Change the field type of total2 and total3 as of field2 and field3 respectively.

Write the below script on total2 and total3 on form ready and in the formcalc.

$ = Sum($record.table.data[*].field2) -

---

> on total2

$ = Sum($record.table.data[*].field3) -

---

> on total 3

<b>$record.table</b> is biding of table.

pavan

[Former Member]

HI:

Problem Solved!, Thanks a lot for your Help

Cesar R.

[Former Member]

hey,

Have you used the above logic or different one.

if you used different one, write that logic here.

Also set as "Answered" for this thread end give points.

pavan meda

[Former Member]

Hi Pavan,

I am facing the problem in data subform where it should loop and multipal records should get printed. The only first record get printed what could be the prob?

Setting for the form is below.

1) From -> Type list has been set to -> Flowed Content

2) From -> Flow Direction list has been set to -> Table Row

Please throw some light.

Regards,

Bhawanidutt

[Former Member]

Hi Bhawanidutt ,

I think you forget to flag the check<b>repeat subform min</b> in the object tab.

pavan meda

[Former Member]

Thanks Pavan,

I found that check in Object Tab -> Binding tab -> check box for "Repeat Subform for Each Data Item".

Regards.

Bhawanidutt