Expand my Community achievements bar.

Growing table with rows that are added and calculated

Avatar

Level 4

Hi,

I need to create a table in my pdf that grows and will cross over to other pages if it gets big enough.

The table with look like this:

          

Header 1Header 2Header 3Header 4
Heading 1Total of all sub heading values under heading 1
     sub heading 1value 1
     sub heading 2value 2
     sub heading 3value 3
     (more sub headings need to

      be added if applicable

So, what I need to figure out is how to allow the user to add more sub headings under heading 1  and still calculate the total values for all the sub headings under heading 1.

Is this possible?  Any help is greatly appreciated!!!

Thanks in advance!

6 Replies

Avatar

Level 6

Hi,

I made some simple example for you. It could be start point for your form.

BR,

Paul Butenko

Avatar

Level 4

Thank you so much for the example, that is wonderful!

Now, is there a way to say hide the sub heading row, and have the add row button under heading 1?

Because sometimes there might not be a subheading so I would like to have no subheading rows and

have the user just add them if they are needed if possible?

Also, can I set the value of the numeric field to 0 initially?

Thanks again!!!

Avatar

Level 4

Is there a way to move the subform on the page? I wanted to create a header for each page on the master page, but I need to move the subform down the page.  When I select it and drag it, it doesn't seem to move. How do you reposition it?

Avatar

Level 6

Thank you so much for the example, that is wonderful!

>>Now, is there a way to say hide the sub heading row, and have the add row button under heading 1?

to hide something use FieldName.presence = "hidden"

>>Also, can I set the value of the numeric field to 0 initially?

two ways:

1) on initialise event put this.rawValue = 0 - JS, $.rawValue = 0 - FormCalc

2) Object palette - Value tab - Default field put 0

>>Is there a way to move the subform on the page?

You can use page breaks:

Click on subform , Object palette - Pagination tab

>>How do you reposition it?

To put header on master page you will have to create separate table there.

BR,

Paul Butenko

Avatar

Level 4

Hi Paul,

I've attached the file I am working with.

Regarding your responses, you said to use use FieldName.presence = "hidden"....

Where do you put that script.  When I select the first row under heading 1 and in the object pallete

click chance presence to invisible, it just hides that columns, then when you click on "add row",

it duplicates the row without the columns.

I just want to hide the row under heading one and have the "add subrow" button under heading 1.

Is that possible?

2nd question....where is the initialize script to put this script you provided: "this.rawValue = 0 - JS, $.rawValue = 0 - FormCalc"

Also, when I select that cost field in the heading 1 row, there is not a default field in the value tab.  The only thing in the value tab

is type:  calculated - read only, and calculation script is selected...?

I appreciated your time!

Thanks again.

Avatar

Level 4

Here is the .pdf I forgot to attach, thanks!