AnsweredAssumed Answered

Loop fails to advance to next record

Question asked by anothersmurf on Jul 24, 2013
Latest reply on Aug 1, 2013 by anothersmurf

Here is a script snippet:

 

Set Error Capture [On]

Loop

Set Field(Validated_field_with_override_allowed, value)

Go to Record/Request[Next]

End Loop

 

The problem is, if the value fails validation (which sometimes happens, but when running this script I always want to allow the value anyway, which is why Error Capture is on), the script fails to advance to the next record. Instead, it just loops through the Set Field step forever on the same record.

 

The user who will run this script doesn't have Manage Database privileges, so temporarily removing the validation is not an option. The user is allowed to override, but may have to do so a large number of times when running the script, so I really don't want to make the user respond to thousands of override dialogs...

 

Does anyone know how to make the loop advance to the next record even if validation failed?

Outcomes