Hello All,

 

Form A = Form with Data that I want to retrieve from.

//Form A will have multiple records that are indexed by "Po_No"

 

Form B = Form that I want to pull data into.

//Form B will required the muliple records in Form A to be summed with the result being inserted into a record in Form B.

 

I am trying to use "for each r" to pull record specific data from Form A, sum specific fields, and take the total sum data and insert into a field within a new record.  I will need to repeat the "for each" and "insert into" scrips  for approximately 30 fields.

 

I created the script below, but it does not "insert into" the data into the field I have indicated in form B.

 

 

for each r in DBSP_1010___QA_Inspect_Data_Sub_Primals1  [PO_No == input.PO_Number]
{
    Total_Anterior_Measurement_Count_to_Claim = 0;
    if (r.Total_Anterior_Measurement_Count.toString()  ==  input.PO_Number)
    {
        Total_Anterior_Measurement_Count_to_Claim = (Total_Anterior_Measurement_Count_to_Claim  +  input.Total_Anterior_Measurement_Count);
        insert into KRG_Sub_Primal_Claim
        [
            Added_User = zoho.loginuser
            Total_Anterior_Measurement_Count = (Total_Anterior_Measurement_Count_to_Claim  +  input.Total_Anterior_Measurement_Count)
        ]
    }
    Total_Posterior_Measurement_Count_to_Claim = 0;
    if (r.Total_Posterior_Measurement_Count.toString()  ==  input.PO_Number)
    {
        Total_Posterior_Measurement_Count_to_Claim = =     

        Total_Posterior_Measurement_Count_to_Claim +  input.Total_Posterior_Measurement_Count);
        insert into KRG_Sub_Primal_Claim
        [
            Added_User = zoho.loginuser
            Total_Posterior_Measurement_Count = (Total_Posterior_Measurement_Count_to_Claim  +  input.Total_Posterior_Measurement_Count)
        ]
    }
}

Thanks,

Bartley