question Create a new entry in a customer table from a catalog items in ITSM forum

Create a new entry in a customer table from a catalog items

steveturley — Fri, 13 Sep 2024 14:33:05 GMT

Hi. I'm trying to create a new entry in a custom table from the value in a catalog item.

My table name is 'u_cmdb_ci_whitelisted_url' the field name I want to populate on the is 'name'

The field in my variables is called 'external_party_organisation_url'

Can someone advise if my script is correct please? (spoiler - it's not working currently!)

(function() {

var server = new GlideRecord('u_cmdb_ci_whitelisted_url');

u_cmdb_ci_whitelisted_url.initialize();

u_cmdb_ci_whitelisted_url.name = current.variables.external_party_organisation_url;

u_cmdb_ci_whitelisted_url.insert();

}

}();

Re: Create a new entry in a customer table from a catalog items

Gangadhar Ravi — Fri, 13 Sep 2024 14:52:56 GMT

You need to use your server for calling function. The server variable holds the GlideRecord for your custom table u_cmdb_ci_whitelisted_url. please refer below.

(function() { var server = new GlideRecord('u_cmdb_ci_whitelisted_url'); // Use 'server' as the variable name server.initialize(); // Initialize the new record server.name = current.variables.external_party_organisation_url; // Set the 'name' field with the variable value server.insert(); // Insert the new record into the table })();

Re: Create a new entry in a customer table from a catalog items

steveturley — Fri, 13 Sep 2024 15:25:55 GMT

Fantastic! That works. Thank you. I didn't know that about 'server'. Is that because it's a custom table?