I am trying to write a VBScript which checks whether the field "Address1_City" in "Contact" Table is already populated in previous job or not. If the field is not already populated I would like to populate the new value in the current job/stage and skip if it already has some value. I am trying to get the value from the destination field using - SmartLookUp("Contact", "Address1_City", ""). Please let me know the best practice with example to do this?
Login or sign up for our forums to connect to the user community.