RE: 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.”

ganeshsk Rookie Asked on September 30, 2020 in Administration.
Add Comment
2 Answers

On your user event script you can create a search load then perform update.

Rookie Answered on September 30, 2020.

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

on September 30, 2020.
                    type: 'customrecord_emproster',
                    columns : [search.createColumn({
                        name: 'yourcustomerrecord'
                    name: 'legalname'
                    filters : [
                            name: 'custrecord_legalname',
                            values: null
                }).run().each(function(result) {
//put your update field here
You can put this aftersubmit or beforeload. Or using a mapreduce script then put this in map.
on October 11, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.