duplicateRepeatingSectionRow

[bob9145]

I wanted to perform a calculation on a control in a row when the row is duplicated within a repeating section container.

See: http://www.ajaxvideotutorials.com/V1...licateRows.swf

For example I have a control within the duplicated row called number. I want this field to increase by one every time the row is duplicated.

Can I do this in the onclick event for the duplicate button?

If so what would this code look like?

[Davidk]

Re: duplicateRepeatingSectionRow

I have to say... Javascript numbers and dates drive me crazy! Anyway... Have a look at this. It seems to work... but randomly it coughs up with NaN for the value that is being incremented... maybe it's just me.

There are a few assumptions here and a few oddities.

1. I've assumed that the last row in the repeating section will carry a field that has the value to increment for the new row.
2. I created a variable to go and Set a value in the last row - the new row. This row is based on the length of the Array and for some reason I have to add 2 to the length to get things to work.
3. When {dialog.Object}.duplicateRepeatingSectionRow('CONTAINER_1'); is used, the new row is usually made the current row, but I've noticed it is not always. So, I don't rely on it. I'm still not sure about this one.

I've had to parseInt until I'm blue... but that's life. Bascially, go and get the data for a column, put it into an Array and figure out how many rows we're dealing with. Grab your field that you want to increment from the last row, duplicate your row, and set the incremented value in the new row. You'll need to change stuff for your Field... hope it helps get you going.

var prodStr = {dialog.Object}.harvestRepeatingSectionColumn('PRODID');
var prodArray = new Array();
prodArray = prodStr.split(',');
var lenArray = parseInt(prodArray.length);
lastVal = parseInt({dialog.Object}.getValue('PRODID:'+lenArray));
var nextVal = parseInt(lastVal+1);
newRecPos = parseInt(lenArray+2);
//alert('prodStr = ' + prodStr + ' prodArray = ' + prodArray + ' lenArray = ' + lenArray + ' lastVal = ' + lastVal + ' nextVal = ' + nextVal + ' newRecPos = ' + newRecPos);
{dialog.Object}.duplicateRepeatingSectionRow('CONTAINER_1');
{dialog.Object}.setValue('PRODID:'+newRecPos,nextVal);

[bob9145]

Re: duplicateRepeatingSectionRow

David,
Thanks for your time and effort. I will give it a try its a little over my head. I was hoping for a simpler fix. Sound like a great opp for a Rabin's Jinger!
Thanks Again,
Bob

[Davidk]

Re: duplicateRepeatingSectionRow

It's not too bad actually. If you follow Selwyn's video for adding the Duplicate Row button you just need to add in the code above.

Where it reads "PRODID" change it to your field name. Where it reads "CONTAINER_1" change it to your container name.

The tough part was getting the number to ADD and not CONCATENATE! Then, figure out the Javascript for arrays, and getting values etc. It's all new to me so it takes time... but fun!

[bob9145]

Re: duplicateRepeatingSectionRow

Dave,

Can not get the control to increase in value on the duplicated row.

My Control name is NUMBER and my container is Container_2. I substituted NUMBER throughout the script to replace PRODID and changed the single instance of Container_2. The row duplicates but the number field does not increase. I get the text NaN. It appears in the last row when a row is duplicated.

I am using dbf and my field type is Numeric.the control is bound to the dbf table.



var prodStr = {dialog.Object}.harvestRepeatingSectionColumn('NUMBER');
var prodArray = new Array();
prodArray = prodStr.split(',');
var lenArray = parseInt(prodArray.length);
lastVal = parseInt({dialog.Object}.getValue('NUMBER:'+lenArray));
var nextVal = parseInt(lastVal+1);
newRecPos = parseInt(lenArray+2);
//alert('prodStr = ' + prodStr + ' prodArray = ' + prodArray + ' lenArray = ' + lenArray + ' lastVal = ' + lastVal + ' nextVal = ' + nextVal + ' newRecPos = ' + newRecPos);
{dialog.Object}.duplicateRepeatingSectionRow('CONTAINER_2');
{dialog.Object}.setValue('NUMBER:'+newRecPos,nextVal);

[Davidk]

Re: duplicateRepeatingSectionRow

I was getting NaN sometimes too... then it stopped... let me try it with your fieldname and a dbf table. The table shouldn't matter... we'll dealing with all Javascript here... but who knows...

If you try to duplicate one row, you get NaN. But if you then try another row during the same session... still NaN?

[Davidk]

Re: duplicateRepeatingSectionRow

One cause of the NaN is that we may have the Repeating Row count set to more than the number of records displayed. Blank records will still take up a position in the Array. So... we get rid of them. And... incrememting the newRecPos by 2 doesn't seem to work any more. So, just increment by 1, which is supposed to make sense. Try this code. The new stuff - the filter - gets rid of unwanted Array items... Nulls, Undefined, etc. So cool.

var prodStr = {dialog.Object}.harvestRepeatingSectionColumn('NUMBER');
var prodArray = new Array();
prodArray = prodStr.split(',');

prodArray = prodArray.filter(function(val) {
	return !(val === '' || typeof val == 'undefined' || val === null);
});

var lenArray = parseInt(prodArray.length);
lastVal = parseInt({dialog.Object}.getValue('NUMBER:'+lenArray));
var nextVal = parseInt(lastVal+1);
newRecPos = parseInt(lenArray+1);
{dialog.Object}.duplicateRepeatingSectionRow('CONTAINER_1');
{dialog.Object}.setValue('NUMBER:'+newRecPos,nextVal);

[bob9145]

Re: duplicateRepeatingSectionRow

Tks again Dave,
Getting some wierd stuff. It works partially. I think it must have something to do with the number of rows you set it for. I also have a hidden auto incremented field in the mix. Doesn't seem so simple.
Tks
Bob

[Davidk]

Re: duplicateRepeatingSectionRow

Yes... the number of rows is a factor. What weird stuff is happening?

[bob9145]

Re: duplicateRepeatingSectionRow

Dave,
Trying to start with something simpler. Can't get this to work. Trying to set the value of a control with the submit button with the current time and then save the value.

var time = Time();
{dialog.Object}.setValue('END',time);
{dialog.object}.submit()

Tks
Bob

[Davidk]

Re: duplicateRepeatingSectionRow

I don't think there is a Time() function. Just to be tidy, make sure of that semi-colon on every line that needs it. Depending on what you want you could do something like...

var currDate = new Date();
var time = currDate.toLocaleTimeString();
{dialog.object}.submit();