UI Action to show pop up with values of a table

Alon Grod
Tera Expert

I have the field u_jira_project on the incident table of type Reference to u_jira_project table. I need to create a form button called 'Create Jira'. When the user click on this button, he needs to see a pop up with all the projects from u_jira_project table divded into two columns: u_project_name, u_project key. After the user chose a project, the value of the project that he chose need to be populated inside u_jira_project field on the incident table. How can I achieve that?

3 ACCEPTED SOLUTIONS

@Alon Grod 

 

Their is one more error: make it name,key

 

var $j = jQuery.noConflict();
var ga = new GlideAjax('ShowJiraProject');
ga.addParam('sysparm_name', 'getProjects');
ga.getXML(parseResponse);

function parseResponse(response) {
var answer = response.responseXML.documentElement.getAttribute("answer");
alert(answer);
var str = "<div><table class='table' id='tableData'><tr><th>Name</th><th>Key</th></tr>";
answer = JSON.parse(answer);
for (var i = 0; i < answer.length; i++) {
str = str + '<tr id="tableRow"><td>' + answer[i].name +'</td><td>' + answer[i].key + '</td></tr>';
}
$j('#iframee').append(str);
}

  

View solution in original post

@Alon Grod,

 

There are a lot many tasks in this, will try to help you as I get time daily!

I am also stuck somewhere that has to be completed before this week ends!

 

I hope you understand 🙂

View solution in original post

Mathieu Lepoutr
Mega Guru

Hi

You can achieve this functionality by creating an ui-action on the incident table, which opens a dialog window with a list of projects from the u_jira_project table. Once the user selects a project, a script can set the value of the u_jira_project field on the incident table to the selected project's sys_id.


Please have a look at Exalate integration software. It enables you to synchronize data between the two systems, including incidents and projects, automating the transfer and ensuring they remain in sync. 

View solution in original post

33 REPLIES 33

Alon Grod
Tera Expert

@Alon Grod ,

 

I have answered exactly same type of requirement here with step by step, you need to just change the name of tables and it will work for you.

 

Please check the link here: https://www.servicenow.com/community/developer-forum/how-to-create-ui-action-and-ui-page-script-to-s...

 

Please let me know if you stuck at some point, might be I would not reply on the spot, but will check it once I get time

 

If my answer solved your issue, please mark my answer as  Correct & 👍Helpful based on the Impact.

 

@Prince Arora What am I doing wrong?

for some reason im getting page could have been found error. I added attachments.

@Alon Grod 

 

1 mistake : Inside script include, name of the table should be in double quotes ""

2 mistake : Inside button, new GlideModal("NAME_OF_THE_UI_PAGE") //please change the name of the UI page as "button"

 

If my answer solved your issue, please mark my answer as  Correct & 👍Helpful based on the Impact.

@Prince Arora Now im getting this error:

WhatsApp Image 2023-04-24 at 11.48.34.jpeg