AnsweredAssumed Answered

Auto-populating fields with loop script

Question asked by DanielKwon on Feb 4, 2011
Latest reply on Feb 4, 2011 by philmodjunk


Auto-populating fields with loop script


I am having some problems trying to auto-populate fields using a script. 

I have a two tables Cases and Calculation. I am using a local variable to as a counter. Then I use the counter to compare it's current value versus values in a field in Cases. Values are numerical. 

Set Variable [$count; Value:0]


If[$$count = Cases::_LocationID]

Set Field [Calculation::_LocationID = Cases::_LocationID]

End If

Goto Record [Next; Exit after last]

Exit Loop If [$count = $count + 1]

End Loop

Unfortunately, loops once and quits. It populates only 1 field