Skip navigation
(Drew_Nowak)
Currently Being Moderated

Addinstance TOTAL

Feb 24, 2009 7:11 AM

I am making an estimate sheet with an add/ remove instance subform labeled "Instance". I can add and remove the forms with no problem. Within the instance is a numerical field called "Price". I need to SUM total the Price field on every instance that I add. Also, if I remove one of the instances, I need it to deduct from the total (I read there were errors with this).

These are the scripts I have in each field:

---------------------------------
-Instance-
_Instance.addInstance(1);

xfa.form.recalculate(1);

// Verify at least one instance of the numAmount field exists.
if (exists(detail[0].numAmount) == 1) then
Sum(detail[*].numAmount)
endif

-Total-
Sum(Instance.#Price[0][*].rawValue)
----------------------------------
I might be off by a few characters. I am a beginner with javascript/ livecycle, so I pretty much Frankensteined this code. Addinstance isn't something I can accomplish with Acrobat Pro alone. So I'm thrown into the fire w/ Livecycle.

I have searched in and out of google, this forum and livecycle help. I can't figure this problem out. Help will be extremely appreciated!
3654 Views   2 Replies   Latest reply: Ratnesh Ranjan, Aug 29, 2012 4:31 PM
 
Replies
  • Alberto Pedroza
    Currently Being Moderated
    1. Alberto Pedroza,
    Mar 19, 2009 9:22 AM   in reply to (Drew_Nowak)
    Report
    Drew,


    It seems you're using Form Calc, and i think you should use JavaScript instead. You may have to do one of the following:


    (a) code the "click" event in your add/delete instance button

    (b) place your code in the "calculate" event for the sum field


    You can use both FromCalc or JavaScript (i prefer JavaScript).


    Refere to the "Purchase order" sample, use the "Dynamic interactive" variation. It has the same properties you want. The samples are on the LiveCycle Designer's installation directory.


    Hope this helps.
     
    |
    Mark as:
  • Ratnesh Ranjan
    Currently Being Moderated
    2. Ratnesh Ranjan,
    Aug 29, 2012 4:31 PM   in reply to (Drew_Nowak)
    Report

    Hi,

     

    Please download the sample form from here.  https://acrobat.com/#d=Xxh9tEdKkYuByNDdKR4Geg

     

    1. Place the below code  in the calculate event of your total field.

     

     

    TotalField.rawValue = Sum(instance[*].price)

     

    Make sure the script selected under language is formcalc.

     

     

     

    Also to  Verify at least one instance of the numAmount field exists.

     

    You can check the object panel of the subfom and under Binding TAb you can check the option "Repeat subform for each data item with Min count 1."

     

    instance.png

     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)