Copying data from one field to another
Hi wish to mass up date my billing address of my customers to a custom field address i have created. Can I right a script for this or, if so how do I go about it.
Something like ” IF Custom address field is blank then up date with Billing address information.”
On your user event script you can create a search load then perform update.
Actually i want the script to search the record based on criteria that the filed is empty and populate it with the data from the corresponding filed fro the record. For example I got 2 fields customer Name and Legal name. I want script to search all records where the legal name is empty and up date it with the customer name.
And Where do I write this script
search.create({type: 'customrecord_emproster',columns : [search.createColumn({name: 'yourcustomerrecord'}),search.createColumn({name: 'legalname'}//put your update field here})],filters : [search.createFilter({name: 'custrecord_legalname',operator:search.Operator.ISEMPTY,values: null})]}).run().each(function(result) {
You need to look into CSV Import of Custom Fields. The advanced settings on the CSV import lets you maps the fields.
