I'm wanting to write a script that will go down each portal row (which btw has only 1 field) and take that information and put it into a text field. For some reason I can't get it to work.

Go to Portal Row [First]

Loop

Insert Calculated Result ["Test", "ActiveMembers::LaosName & "[Paragraph Symbol]"]

Go to Portal Row [Exit after last, Next]

End Loop

What happens is that the content from the field "LaosName" inserted into field "Test" in an endless loop.

Any suggestions would be helpful.

-Dave

Hello Dave,

The reason that your script goes into an endless loop is that the Insert Calculated Result [ ] script step (as with all the Insert steps) acts like a paste command, and actually places the cursor into the target field. In so doing, it removes 'focus' from the portal row, so that the subsequent Go To Portal Row [ ] command takes the script back into the first row of the portal, rather than on to the subsequent row. This would result in the script appearing to get 'stuck' on the first row of the portal.

A simple solution to your problem would be to use the Set Field [ ] command instead, since Set Field [ ] operates without any change of focus or 'context'.

Thus an alternative script sequence that would do what you were trying to achieve, using the Set Field function, would be:

Go to Portal Row [select, First]

Loop

Set Field ["Test", "Case(not IsEmpty(Test), Test & "