Skip navigation
Pixels77
Currently Being Moderated

My interactive form is a hot mess (multiple problems with javascript and formcalc)

Aug 6, 2012 12:41 PM

I have been working on a dynamic expense report form for our company but have run into a number of problems. I would appreciate help with any of these!

 

Problem 1:

Last subform: Table 4 (Miscellaneous Expenses) - This subform does not force down the footer section (signature, comments) like the other subforms do. The table is located in a positioned subform inside a flowed subform. The other 3 tables have no problem pushing the data down.

 

Problem2:

The minus button on the tables (to subtract a row) USED to work but now do not.The minus button on EVERY table is broken.

 

Problem 3:

The add row button still works fine on most of the tables (with exception of the last table, MISC Expenses). If I add a few lines to the last subform it seems the buttons stops working altogether past row 3. you have to add 2 rows to the final table (Misc Expenses) to see what I mean. It seems to me that this problem is probably related to Problem 1 somehow.

 

Problem 4:

Can't get GRAND TOTAL working no matter what I try.

 

I uploaded my work in progress here: www.essential-equipment.com/pdf/ExpenseReport.pdf

If anyone is able to help me I would greatly appreciate it.  Also, would it be hard to make this form able to carry over to a new page?

 

Thanks in advance to anyone that helps

 
Replies
  • Currently Being Moderated
    Aug 6, 2012 1:05 PM   in reply to Pixels77

    Hi.

     

    Problem 1:

    The sourrounding subform "Table4Subform" is not set to fit the hight automatically.

     

    Problem 2.

    The remove script is way to complex, use this script instead:

    if (this.parent.parent.instanceManager.count > 1) {
              this.parent.parent.instanceManager.removeInstance(this.parent.parent.index);
    }
    

     

    Problem 3:

    Remove the Grouping "Body", then the subform flow crrectly to the next page.

     

    Problem 4:

    The reference to the total fields are not correct, that's why the grand total script fails.

    Change it into:

    Sum(Table1Subform.Table1.FooterRow.Total1, Table23Subform.Table2.FooterRow.Total2, Table23Subform.Table3.FooterRow.Total3, Table4.FooterRow.Total4)
    
     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points