Scripting Syntax

Discussion created by peterfloyd on Mar 7, 2016
Latest reply on Mar 7, 2016 by keywords

I am trying to Replicate a record (keep all the same address information and NameLast, but replace the Title with blank, First Name with blank, etc. to add family members to a DB.  This is to make data entry easier so the person only has to change the Title, First Name, Phone Number, etc. for their spouse or child.


I have duplicated a record, and then used a script to replace some of the fields in the duplicated record with " " (i.e. blank space).


Everything works as expected except the fields that I want deleted have a "0" in them instead of nothing. When the script runs, it fills all the deleted fields with 0 instead of nothing.


Can someone help me?