question Help with transform field map script in Developer forum

Help with transform field map script

Snowman15 — Mon, 16 Jun 2025 19:00:01 GMT

Hi all,

I am struggling with a field map script, and could use some guidance from the community.

Due to limitations, the source spreadsheet columns cannot be modified, so I need to handle everything via scripting.

One of the source fields, source.u_softwaretype, contains values formatted like:
"GH001 - Software Not found"

What I need to do is:

Extract just the code portion ("GH001") from the text.
Perform a lookup in the x_software_list_code_mapping table where:
- supplier = 'WILLIAMS'
- code = 'GH001' (the extracted value)
From the matched record, retrieve the serial_number field value.
Populate the target reference field with that serial_number field value.

This is the script I tried so far but is not working:

(function transformEntry(source) {

var match = source.u_softwaretype.match(/(GH\d{3})/);

if (!match) return "";

var extractedCode = match[1];

var gr = new GlideRecord('x_software_list_code_mapping');

gr.addQuery('supplier', 'WILLIAMS');

gr.addQuery('code', extractedCode);

gr.setLimit(1);

gr.query();

if (gr.next()) {

return gr.serial_number;

}

return "";

})(source);

Thank you

Re: Help with transform field map script

YaswanthKurre — Mon, 16 Jun 2025 19:45:25 GMT

Hi @Snowman15 ,

Try adding logs inside your script and where it breaks, if target is a reference field , try returning "

return gr.getUniqueValue(); // returns sys_id".

Thanks,

Yaswanth

Re: Help with transform field map script

palanikumar — Mon, 16 Jun 2025 19:46:18 GMT

Hi,

Sometimes you need to convert a field name to string to make it work. Try the below:

(function transformEntry(source) {

var match = source.u_softwaretype.toString().match(/(GH\d{3})/);

if (!match) return "";

var extractedCode = match[1];

var gr = new GlideRecord('x_software_list_code_mapping');

gr.addQuery('supplier', 'WILLIAMS');

gr.addQuery('code', extractedCode);

gr.setLimit(1);

gr.query();

if (gr.next()) {

return gr.serial_number.toString();

}

return "";

})(source);

Re: Help with transform field map script

Snowman15 — Mon, 16 Jun 2025 20:16:54 GMT

hi @YaswanthKurre thanks. Tried this but didn't work

Re: Help with transform field map script

Snowman15 — Mon, 16 Jun 2025 20:18:08 GMT

hi @palanikumar thank you, unfortunately this didn't work either.

Re: Help with transform field map script

Muhammad Salar — Tue, 17 Jun 2025 12:45:49 GMT

Hello @Snowman15 , try this,
gr.addQuery('code', extractedCode.toString());