Copy field contents script stops if field empty
My second post in a couple hours - I am not having a good day. This question is in two parts and kind of relates to my last issue with relationships.
I have a portal, that links to an external table. I am trying to write a script that sequentially copies the contents of one of the portal fields into another table. I have had it working but the issue is I the script to stop if one of the fileds it is copying is empty.
My questions are;
1). Does the script sit and run within the file that the portal relates to or can it live in the file that the portal is part of?
2). My script doesn't seem to stop at a blank field. Please see attached image for the steps.
Once again any help would be fab.