How to generate a pdf from a form and send it to another table

suprakash · ‎03-21-2017

Suppose I am entering some data in a form of table u_candidate_details and when i submit or save the form a record will be inserted in table u_candidate_database and a pdf attachment will be added on the record that was created on table u_candidate_database . the attachment will be pdf of the form view u_candidate_details

nayanawadhiya1 · ‎03-21-2017

Hey Suprakash,

Write a INSERT BUSINESS RULE -

var gr = new GlideRecord ('u_candidate_database');

gr.addQuery(Filter_condition);

gr.query();

if(gr.next())

{

var rm = new sn_ws.RESTMessageV2();
       rm.setHttpMethod('GET');
       var url = gs.getProperty("glide.servlet.uri") + current.getTableName()+ '.do?PDF&sys_id=' + current.sys_id;
       rm.setEndpoint(url);
       rm.setBasicAuth(gs.getProperty('glide.user.userid'), gs.getProperty('glide.user.password'));
       rm.saveResponseBodyAsAttachment(gr.getTableName(),gr.sys_id,current.number+".pdf");
       var response = rm.execute();

}

View solution in original post

AbdulAzeez · ‎03-21-2017

Here you go,

nayanawadhiya1 · ‎03-21-2017

Remove 4 to 8 lines and 16 as well.

And let me know if it is not working.

AbdulAzeez · ‎03-21-2017

Its not working Nayan.

Unable to create a PDF...

AbdulAzeez · ‎03-21-2017

nayan.awadhiya@p5solutions.com Do i need to activate any plugins related to REST ?

I create 2 sys properties as mention earlier: glide.user.userid & glide.user.password and written a BR on Incident table after on Insert and pasted your code:

(function executeRule(current, previous /*null when async*/) {

// Add your code here

var rm = new sn_ws.RESTMessageV2();

rm.setHttpMethod('GET');

var url = gs.getProperty("glide.servlet.uri") + current.getTableName()+ '.do?PDF&sys_id=' + current.sys_id;

rm.setEndpoint(url);

rm.setBasicAuth(gs.getProperty('glide.user.userid'), gs.getProperty('glide.user.password'));

rm.saveResponseBodyAsAttachment(current.getTableName(),current.sys_id,current.number+".pdf");

var response = rm.execute();

})(current, previous);

Later i created a notification where i am getting an email but not with PDF

Correct me if i have done anything wrong.!

nayanawadhiya1 · ‎03-21-2017

By default it is activated please cross check.