AnsweredAssumed Answered

Loop trouble

Question asked by sdurante on Jan 2, 2018
Latest reply on Jan 2, 2018 by sdurante

I have steps in a loop that work fine--once. It doesn't loop.

I checked the step near the end,

"Go to Record/Request/Page

[ Next; Exit after last ],"

and it leaves me in the correct, that is next record in the correct layout for the loop-start, but it's not doing what it should do after the first pass.

Am I missing something?.

 

 

#go to waivers

Go to Layout [ “Waivers, member ID missing” (Waivers from iPad) ] Show All Records

 

#find waivers with no attached member ID

Go to Record/Request/Page

[ First ]

Perform Find [ Specified Find Requests: Find Records; Criteria: Waivers from iPad::Member ID: “=” ]

[ Restore ]

Go to Record/Request/Page

[ First ]

Commit Records/Requests

[ No dialog ]

Loop

Set Field [ Waivers from iPad::WFN; Waivers from iPad::First Name ] (Here, I tried a global field thinking maybe the variables were just not working, but no.)

Set Variable [ $WFN; Value:Waivers from iPad::First Name ]

Set Variable [ $WLN; Value:Waivers from iPad::Last Name ]

Set Variable [ $WRID; Value:Waivers from iPad::Record ID ]

Commit Records/Requests

[ No dialog ]

Go to Layout [ “Waivers with Signature box omitted and no ID” (Waivers with Signature box omitted) ] New Record/Request

Set Field [ Waivers with Signature box omitted::First Name; $WFN ]

Set Field [ Waivers with Signature box omitted::First Name; Waivers from iPad::WFN ]

Set Field [ Waivers with Signature box omitted::Last Name; $WLN ]

Set Field [ Waivers with Signature box omitted::Waiver ID; $WRID ]

Go to Layout [ “Waivers, member ID missing” (Waivers from iPad) ]

Go to Record/Request/Page

[ Next; Exit after last ]

End Loop

Exit Script [  ]

Outcomes