AnsweredAssumed Answered

Moving data between fields in same record with script

Question asked by StefanSaeys on Sep 11, 2014
Latest reply on Sep 11, 2014 by StefanSaeys

Title

Moving data between fields in same record with script

Post

I have the fields "street" and "postal_code" in the same record.
If field "Street" is empty", I would like to move the content of field "Postal_code" into it. So far my script is working, but when I add Loop or end if I get stuck. Either it doesn't go the the next empty field or it simply gives a script error.

I have no need for adding goto layout or goto first record since I am using this once in table view. Probably the first line in the script is also not needed.

Go to Field [contacts::street]
If [IsEmpty (contacts::street)]
Cut [Select; contacts::postal_code]
Paste [Select; contacts::street]
Go to Record/Request/Page [Next; Exit after last]
Else
Go to Record/Request/Page [Next; Exit after last]
End If

 

Outcomes