Looping through cell in table

Hey Bruce!

I actually figured it out!  I used Loop Through Subform Instances  and used this code.

expenseReport.#subform[0].validate2::click – (JavaScript, client) 
var vItems = expenses.expense.all; 
for(i=0; i<vItems.length; i++) 
{ 
    if (vItems.item(i).description.rawValue == null) 
    { 
        xfa.host.messageBox("Missing description field"); 
        break; 
    } 

}

Took me a few tries to get it to work but it did Thanks!

Jodi

Hey Bruce!

Long time no talk! Hope you are doing well!  I have another repeating issue that I can't get to work

I once again am trying to validate through a repeating subform, but this is just the subform.  I have tried to manipulate the different code you sent me but I am just getting validation on the first subform not the repeated ones.  What am I missing?
Thank you for all your help!

Jodi

Gift Transmital Form_2.pdf - Google Drive

Hi Jodi,

Ok, I think I see what is happening, and each campus has a different Grants and Contracts?  Have a look at this update, https://sites.google.com/site/livecycledesignercookbooks/home/AwardPaymentAuthorization12_2015_2.pdf?attredirects=0&d=1, I've taken all the emails generation stuff out of the loop so it'll happen once all the mandatory checks have been made.

Hope it's getting closer.

Regards

Bruce

Hey Bruce!

You are awesome! 

What it is supposed to do is check the Fund field for each person that is added.  If any one of the people have a fund that has a 4 or 5 as the first number, then the whole form needs to be sent to the grants and contracts office first for approval.  when Grants and contracts approves it they will then sent to Payroll.

If none of the fund fields have a 4 or 5 then the form goes directly to payroll.

Right now it seems to want to send an email for each of the form fields, vs. emailing just once.

Does that make sense?

You help has been invaluable!

Thanks!

Jodi

Hi Jodi,

Have a look at this version, https://sites.google.com/site/livecycledesignercookbooks/home/AwardPaymentAuthorization12_2015_2_workingcopy.pdf?attredi…

Seems the repeating subform is Awardees (not PreApproved?), and then within that you need to repeat over Table2 (not Table1).

Also I assume GFY is meant to be row.Fund.rawValue (not GrantFund?)

Not sure I got all this right, if not give me a description of what the code is meant to do.

Regards

Bruce

Hi Bruce!  I know it has been a long time but things around here don't always  move fast    I am finally trying to put in this looping through subforms but I am not having much luck.  I have uploaded the doc to google docs.  Here is the link.  If you can help that would be awesome!  Thank you!

Jodi

AwardPaymentAuthorization12_2015_2_workingcopy.pdf - Google Drive

Hi Jodi,

Should be something like;

var tables = Main.resolveNodes("PreApproved[*]");

for (var j = 0; j < tables.length; j++) {

    var table = tables.item(j);

    var rows = table.Table1.resolveNodes("Row1[*]");

    for (var i = 0; i < rows.length; i++) {

        var row = rows.item(i);

        var GrantFund = row.Fund.isNull ? 0 : row.Fund.rawValue.charAt(0);

        if  (GrantFund == 4 || GrantFund == 5) {

            //...

        }

    }

}

Could be some changes you need to make depending on your form structure.  If you can't get it to work upload your form to Dropbox, or Google Docs (or somewhere) and post a link to it here.

Regards

Bruce

Hey Bruce,

Since you were so helpful last time.  Do you know how you would loop through the subform that the table is in?  I have a button that duplicates the subform so the users can add additional information.  So I need to look through each duplicated subform and also check the cell in the row.

Any ideas?
if you need more info let me know

Jodi

Hey Bruce,

Since you were so helpful last time.  Do you know how you would loop through the subform that the table is in?  I have a button that duplicates the subform so the users can add additional information.  So I need to look through each duplicated subform and also check the cell in the row.

Any ideas?
if you need more info let me know

Jodi

Bruce you are the man!!!  It worked!

Thank you so much for the help!
Have a great Thanksgiving!

Jodi