Consolidated Table

[Former Community Member]

Hi,

I have a form with multiple tables on it. The tables are all exactly the same, customer info such as names, addresses and items purchased are captured into these tables. At the end of the form there is one table which consolidates all the info. We have to manually copy the data from all the tables and paste it into the consolidated table. Is there a way (by script or other) to have the data from all the tables copied to the consolidated table? Perhaps a button at the bottom of each table that when clicked, all the data in that table gets sent to the consolidated table?

Thanks.

[Bibhu_Bikash_Na]

Hi,

Assuming that your table structre remainsa the same, i.e no. of coulms remain the same. Lets say you have Two table Table1,Tabble2 and one consolidated Table as Table3.

You can use Global databinding to accomplish the task easily. All you have to do is to maintain the same Field name in table1 and correspong Table 3.

That means lets say there is cell in table one who field name is Table1.Row1.Column1. You want to habe the same data in the Table3. So ,you have to name that field as Table1,Row1.Column1. Now go to that cell in either Table1 or Table 3. Then select Object > Binding > Data Binding > Use global data. So it will reflect the same data accross table in the corresponding cells.

Thanks,

Bibhu.

[Former Community Member]

Thanks for the reply, I did initially use Global databinding and this worked perfectly except that the data entered into Table1 then also reflected on Table2 and all the other Tables. Each Table is specific to certain product types, only the consolidated table must show everything together.

[Bibhu_Bikash_Na]

So, in that case make Global Data binding for Tables with the consolidated lable only. Here Table1 should be made global with the consollidated table not with Table2.

Thanks,

Bibhu.