Building a budget form where I would like to pro-rate the budgeted amounts by calendar days in the year.  Rather than asking the user to specify the start and end date for each calendar year to which the budget applied, I have built in only the overall start date and end date.  The challenge has bee...

Is there a method, either in javascript or formcalc, for counting duplicate values from across a given repeating field.  AnI know this simple code generates a count of all non-null values.  Any help is greatly appreciated.$ = Count(PBE.Page2.SubFormEcho.SubformCharlie.TableA.RowX[*].DateTimeField1)

Have a dynamic table and am trying to validate the current row's date field (DateTimeField1 for i) against the previous row's date field (DateTimeField2 for i-1) and an event start date with a fixed field (PStart_Date).  var rowCountY = this.resolveNodes("RowX[*]");for (var i=0; i < rowCountY.length...

Anyone have any thoughts?  Still have not been able to get this working despite significant tinkering.

Have an expanding table nested in another expanding table.  Attempting to count the number of times:The value in the "DateTimeField2" field in the last row of the nested table on the previous row of the main table is equal toThe value in the "DateTimeField2" field in the first row of the nested tabl...

In my livecycle form, the dynamic table row values, except for the first row, are not being saved.  The rows themselves save, just not the values.  Have already set the "Preserve Scripting Changes to Form When Saved" to Automatic.  Not sure what is causing this one.  Any help is greatly appreciated....

Thanks Bruce, It was the instance manager - I used the exeCalculate( ) in another part of the form, and tested it with an app.alert to ensure the rows were then counting the number of instances correctly to perform the calculation properly. 

I am using the below code to sum a dynamic table.  Each time I add a second "Table1.Row1" row, and select the value that would render countU ==0 true, the Livecycle form will not re-calcuate the query correctly unless I re-select the first row "Table1.Row1" countU value.  In other words, the dynamic...

Was thinking perhaps using formcalc Max( ) and isoDate2Num( ) conditions may work, however I've had trouble wrapping my head around how it would work in a dynamic table. 

The form I am working with in ES4 has a dynamic table with the ability to (1) add rows  - lets call these master rows-  and (2) add rows within a subform on each of those master rows - lets call these child rows.  Each of the child rows within a master row contain dates.  I would like to calculate t...