question Inserting data into a table in Developer forum

Inserting data into a table

yundlu316 — Thu, 22 Sep 2016 14:12:26 GMT

Hi Everyone, I was originally trying to build a record producer that would map to a custom table, but the formatting limitations of record producers is making me consider just building a Macro or UI Page instead. If I were to go this route, I plan to create a custom form using CSS/HTML, but am curious how to map variables back to my table. I did a bunch of googling and wound up here: http://wiki.servicenow.com/index.php?title=GlideRecord#Insert_Methods. I'm not familiar with javascript so was wondering if someone can confirm that this is the right approach to mapping variables back to and inserting into an existing table. Also, can someone explain to me how this code works? Would this be a client side script?

For example if i have a table named u_basic_info with a field called u_credit_card_number and I build a custom form with a insert text field, <input type="text" id="ccnum" name="u_credit_card_number">, how would I generate the below script so that when a user enters in their credit card number, it gets mapped back to the u_credit_card_number field in my my table u_basic_info?

var gr = new GlideRecord('to_do');

gr.initialize();

gr.name = 'first to do item';

gr.description = 'learn about GlideRecord';

gr.insert();

Re: Inserting data into a table

tanumoy — Thu, 22 Sep 2016 14:22:20 GMT

So basically what you have to do is, first you have to get the value what someone has given in u_credit_card_number in UI page.

You must have some button on that page. And after clicking that input will go to the table.

Example: onClick="submitRequest();"

<script>

function submitRequest()

{

var get = document.getElementById('ccnum').value;

var gr = new GlideRecord('u_basic_info');

gr.initialize();

gr.u_credit_card_number = get;

gr.insert();

}

</script>

Re: Inserting data into a table

yundlu316 — Thu, 22 Sep 2016 14:36:23 GMT

Hi Tanuomy, thank you, you've been helping me so much! One follow up question regarding onClick button, if I create this Macro or UI page with the script you provided above, and I decide to insert it into a Record Producer that already has a default Submit button, would that be sufficient?

Re: Inserting data into a table

tanumoy — Thu, 22 Sep 2016 17:03:07 GMT

I just tried that in my dev instance. If you create a UI Page with the below code and create a UI Page type variable in a catalog item/record producer, it will insert a record in that table whenever that catalog item/record producer is loading. No need to submit anywhere.

<?xml version="1.0" encoding="utf-8" ?>

<j:jelly trim="false" xmlns:j="jelly:core" xmlns:g="glide" xmlns:j2="null" xmlns:g2="null">

<input type="text" id="ccnum" name="u_credit_card_number">Text</input>

<script>

var get = document.getElementById('ccnum').value;

var gr = new GlideRecord('incident');

gr.initialize();

gr.short_description = "From UI page";

gr.insert();

</script>

</j:jelly>

I am not sure if you want this or not but this is not a good practice I believe.

Re: Inserting data into a table

yundlu316 — Thu, 22 Sep 2016 19:21:55 GMT

Hi Tanumoy, your code works great! I have one more follow up question (excuse me, I'm brand new to JS), your below code will enter one variable into the table, what if I have 10 different variables that I want to enter into the same table upon Submit? What would that syntax look like?

function submitRequest()

{

var get = document.getElementById('ccnum').value;

var gr = new GlideRecord('u_basic_info');

gr.initialize();

gr.u_credit_card_number = get;

gr.insert();

}

Re: Inserting data into a table

tanumoy — Fri, 23 Sep 2016 00:17:17 GMT

If you have the input type in UI page then use document.getElementbyId('field_id').value to get the value. Then set that value to the table field by using gr.field_name.

function submitRequest()

{

var get = document.getElementById('ccnum').value;

var gr = new GlideRecord('u_basic_info');

gr.initialize();

gr.field_name1 = document.getElementById('abc').value;

gr.field_name2 = document.getElementById('xyz').value;

gr.field_name3 = "Test Here"; //and so on gr.u_credit_card_number = get;

gr.insert();

}

Re: Inserting data into a table

yundlu316 — Fri, 23 Sep 2016 00:36:56 GMT

Thanks Tanumoy, so is the 2nd line needed? Should the code be like this?

function submitRequest()

{

var gr = new GlideRecord('u_basic_info');

gr.initialize();

gr.field_name1 = document.getElementById('name1').value;

gr.field_name2 = document.getElementById('name2').value;

gr.field_name3 = document.getElementById('name3').value;

gr.insert();

}

Re: Inserting data into a table

tanumoy — Fri, 23 Sep 2016 01:10:37 GMT

Your code looks perfect to me. In case you just have to set any static value then the option is to add line like gr.field_name3 = "Test Here";

Re: Inserting data into a table

yundlu316 — Fri, 23 Sep 2016 23:48:06 GMT

Hi Tanumoy, very strange...When I use the code above on 3-4 variables, it works great. However, my form has 30+ fields, when I try it with all of the fields, the submit and page redirect stop working. It's as if SN can't handle the script. Any thoughts on this?

Re: Inserting data into a table

tanumoy — Sat, 24 Sep 2016 04:21:24 GMT

could you please post the full code.

Also make sure that u_basic_info has all the fields present whatever you mentioned in the script (field names should be same as in the table also).

Re: Inserting data into a table

yundlu316 — Mon, 26 Sep 2016 03:51:01 GMT

Hi Tanumoy, here's my full code below: Edit fiddle - JSFiddle. I've added all of my variables back into the code and tested the form by entering a value and pressing submit, variable by variable. The submit button doesn't work until I enter a certain number of variables in the form. I've checked my syntax countless times now and can't seem to locate the issue. Thanks.

Re: Inserting data into a table

tanumoy — Mon, 26 Sep 2016 12:48:21 GMT

What I have noticed that you have use document.getElementById('<variable_name>').value; for all type of inputs like text, option, select-box etc. But this thing will work on text input not all of the inputs.

Like example for select-box you have to use document.getElementById('<variable_name>').innerHTML;

Please look into the below link to get what we need to use for different type of inputs.

JavaScript HTML DOM

Re: Inserting data into a table

yundlu316 — Mon, 26 Sep 2016 21:41:37 GMT

Hi tanumoy, I have a follow up question that is really just for my own knowledge. I've read that GlideAjax may be a better option for scripts such as this. Just out of curiosity, what would the syntax be for the below GlideRecord code?

function submitRequest()

{

var gr = new GlideRecord('u_basic_info');

gr.initialize();

gr.field_name1 = document.getElementById('name1').value;

gr.field_name2 = document.getElementById('name2').value;

gr.field_name3 = document.getElementById('name3').value;

gr.insert();

}

Re: Inserting data into a table

tanumoy — Tue, 27 Sep 2016 08:56:15 GMT

You can try below codes. But please note I have not tested it in my instance.

UI page code:

<script>

function submitRequest()

{

var field1 = document.getElementById('name1').value;

var field2 = document.getElementById('name2').value;

var field3 = document.getElementById('name3').value;

var ajax = new GlideAjax('saveDataToTable');

ajax.addParam('sysparm_name','saveData');

ajax.addParam('sysparm_field1', field1);

ajax.addParam('sysparm_field2', field2);

ajax.addParam('sysparm_field3', field3);

ajax.getXML(doSomething);

function doSomething(response){

var answer = response.responseXML.documentElement.getAttribute("answer");

if (answer)

{

alert('Data has been saved successfully');

}

</script>

Script Include:

Name: saveDataToTable

Client Callable: True

Code:

var saveDataToTable = Class.create();

saveDataToTable.prototype = Object.extendsObject(AbstractAjaxProcessor, {

saveData: function(){

var fname1 = this.getParameter('sysparm_field1');

var fname2 = this.getParameter('sysparm_field2');

var fname3 = this.getParameter('sysparm_field3');

var gr = new GlideRecord('u_basic_info');

gr.initialize();

gr.field_name1 = fname1;

gr.field_name2 = fname2;

gr.field_name3 = fname3;

var sys_id = gr.insert();

return sys_id;

type: 'saveDataToTable'

});