Expand my Community achievements bar.

Dive into Adobe Summit 2024! Explore curated list of AEM sessions & labs, register, connect with experts, ask questions, engage, and share insights. Don't miss the excitement.

Need some help in LiveCycle Designer ES 8.2

Avatar

Former Community Member

Hi i need help with tables in livecyckle.

Example. I create one table with 32 rows and 8 numretic cells, and another table below with 1 row and 8 numretic cells.

In the big table i can input numbers and working fine.

now to my problem. Ex, i want to input number 12 in row 1 cell 3.and then again same number 12 in row 2 cell 3 and i want the result (24) in table 2 row 1 cell 3. is there anyboby who can help me with that See below

Header 1Header 2Header 3Header 4Header 5Header 6Header 7Header 8
1235
1279
4

Header 1Header 2Header 3Header 4Header 5Header 6Header 7Header 8
4241014

Best regards    Stig

4 Replies

Avatar

Former Community Member

Sig,

Consider a table called 'costs' in the sub-form 'budget' on 'page1' of 'form', where the table row is called 'row' and a column is called 'beer'. I add a second table called 'totalCosts' in the sub-form 'budget' on 'page1' of 'form', where the table row is called 'totals' and a column is called 'beer'.

I then add the FormCalc sum function to the calculate event of the 'beer' variable in the 'totalCosts' table, 'totals' row.

///////////////////////////////////////////////////////////////////////////////////////////////////////

form.page1.budget.totalCosts.totals.beer::calculate - (FormCalc, client)

$.rawValue = sum(form.page1.budget.costs.row[*].beer);

///////////////////////////////////////////////////////////////////////////////////////////////////////

Take a look at the attached. I forgot this new fangled forum allows attachments.

Steve

Avatar

Former Community Member

Hi again Steve and thanx for the reply..send you a coupie of my file.

All text on it is in swedish so i can explain a little for you.

Text Veckodag is Weekday,Tim is hours. Frånv. is a shortname for sickness,

Dagtid is daytime Kväll is evening, Helg is weekends, Afton is Big weekend

like christmas day, s-helg is a shortname for big weekendsdays like day

after christmas day, Jour is jour. The field to the left with numbers is

date. Totalt is total

The only fields i need some help with is the field from Tim to Jour. And the

result should apear in the last fielt Totalt

Can also tell that im not so good in english but im learning. And the last

thing of all :Happy easter to you and thanxs again.

Stig in sweden My E-mail adress is stig1@stigberg.com

Avatar

Former Community Member

Happy Easter to you too!

I have attached my version of your form. It includes a table with ten rows and ten columns and a table that totals columns 3-9.

Steve

Avatar

Former Community Member

Hi again Steve and Many thanx to you. It was all i wanted, it worked great

So again Many thanx for your help...Stig from sweden