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

Rookie Asked on September 30, 2020 in Administration.
Add Comment
2 Answer(s)

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.
search.create({
                    type: 'customrecord_emproster',
                    columns : [search.createColumn({
                        name: 'yourcustomerrecord'
                    }),
                    search.createColumn({
                    name: 'legalname'
                    })],
                    filters : [
                        search.createFilter({
                            name: 'custrecord_legalname',
                            operator:search.Operator.ISEMPTY,
                            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

You need to look into CSV Import of Custom Fields. The advanced settings on the CSV import lets you maps the fields.

Rookie Answered on October 6, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor