Back to Iteration Question

[RhinoSmith]

I'm returning to this question because it would make things so much more simple if there is an answer. I have conquered the overall problem using an ajaxcallback and another sql table. This just seems like overkill with hundreds of lines of code needed and multiple callbacks. However, all I want to do is iterate through a repeating section and set the value of one field into another. For instance, "Field A" has a value of "11" and I want "Field B" to have a value of "11". Both Field A and Field B are on the same line in the repeating section, though Field B is hidden. I need to loop through all the rows of the repeating section making "Field B" the same as "Field A" in each row, whatever the value of Field A is in that row. I cannot get this done with my understanding of the use of _A5INSTANCE though I suspect that is the key to making this happen.

Thanks

[Keith Hubert]

Re: Back to Iteration Question

Hi Chris,

I'm sure you have a very good reason but please forgive me for asking, why do you want to duplicate data in the same row of a repeating section?

[RhinoSmith]

Re: Back to Iteration Question

No problem Keith-
It's an inventory system with a field for units and then there are fields for intransit, sold, available, on ground, etc. When the user selects whether the Warehouse receipt has been "Received" or "Cancelled Receipt" then I want to update either the on ground, available, intransit, etc. Those same fields get updated if the user does some type of assembly or disassembly work or if the some are sold, etc. The field can be popluated when the user originally enters the order as that might be or might not be when the order is received or when it is actually received. Many users don't even put the line items in until the receipt is made. But not all, so I have to adjust to that.

Chris

Chris

Hi Chris,

I'm sure you have a very good reason but please forgive me for asking, why do you want to duplicate data in the same row of a repeating section?

[michaeldarby]

Re: Back to Iteration Question

Here is an example javascript function that you can call from wherever it makes sense. You will need to change CONTAINER_1 to your container name, and the names of the fields to match:

function SetFieldAtoFieldB() {
for (var i=0;i<={dialog.Object}._getRepeatingSectionRowCount('CONTAINER_1');i++)
{
var row = ':' + {dialog.object}._repeatingSectionLogicalToPhysicalRow('CONTAINER_1',i);
{dialog.Object}.setValue('FIELDB' + row,{dialog.Object}.getValue('FIELDA' + row));
}
}

[RhinoSmith]

Re: Back to Iteration Question

Michael-
That works GREAT! Exactly what I needed.

Thanks,
Chris

Here is an example javascript function that you can call from wherever it makes sense. You will need to change CONTAINER_1 to your container name, and the names of the fields to match:

function SetFieldAtoFieldB() {
for (var i=0;i<={dialog.Object}._getRepeatingSectionRowCount('CONTAINER_1');i++)
{
var row = ':' + {dialog.object}._repeatingSectionLogicalToPhysicalRow('CONTAINER_1',i);
{dialog.Object}.setValue('FIELDB' + row,{dialog.Object}.getValue('FIELDA' + row));
}
}