I want to generate a pdf of selected records in a list?

trinadhgottipat
Kilo Expert

Hi All,

I want to generate a PDF of selected records in a list, when the user clicks on 'Generate PDF' UI action(List Choice),created by me.

Is there a way I could do this.

Thanks,

Trinadh.Developer Community Service ManagementdvpChuck Tomasi's BlogPradeep Sharma's Blog ctomasi

1 ACCEPTED SOLUTION

Hi Trinadh,



Have a List UI Action either List bottom button or List context menu as per your need.


Select the checkbox for client and add this function downloadPdf()


In the script section add the following code. What it does is it gets the pdf for only those records which are selected in the list layout.


I have tested it at my end and is working fine. It will take columns specific to a view and not the ones which you have added from gear icon.


If you want the columns which are present on the list layout then make the view as empty



Script


function downloadPdf(){



  var checked = g_list.getChecked(); // get's the sys_id of the checked records


  var query = "sys_idIN" + checked.toString();


  var rows = checked.split(",").length; // rows to be sent to the pdf function


  var view = "default"; // set this to default for columns present in default view for list layout


  //var view = ""; // set this to empty if you want all the columns present in the list layout including the customized ones.



  var dialog = new GwtPollDialog('u_sample_table', query, rows, view, 'unload_pdf');


  dialog.execute();


}



Mark Correct if this solves your issue and also hit Like and Helpful if you find my response worthy based on the impact.


Thanks


Ankur


Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

View solution in original post

28 REPLIES 28

Hi Ankur,


Thats working fine for me aswell,but i want the pdf to be downloaded in the form view.


Can you assist?



Thanks,


Trinadh.


Hi Trinadh,



The rows variable should have 1 which is correct in your script.


Can you show some screenshot or error which you are getting for the Form button when you click?



Regards


Ankur


Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Hi Ankur,


Thats working on my form aswell.


But,


This is what i get through the script i have mentioned earlier.


find_real_file.png





But im looking for a pdf that displays the form information specifically,something like this,



find_real_file.png




Thanks in advance,


Trinadh


Hi Trinadh,



Got it. You need the information in 2 column format and not as a single row. But why not use the Out of box Export Pdf option instead of having a separate UI action on form.



Regards


Ankur


Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Hi Trinadh,



You can use the below script to check whether you are getting the columns in 2 column layout in the form ui action.


I think this works only when you have columns being splitted in 2 columns in form layout by using begin split and end split



var url = '/u_table.do?PDF&sys_id=' + g_form.getUniqueValue() + '&sysparm_view=default' ;


window.open(url,'_blank');




Mark Correct if this solves your issue and also hit Like and Helpful if you find my response worthy based on the impact.


Thanks


Ankur


Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader