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

nayanawadhiya1 · ‎03-21-2017

Mark Answer as correct to close this thread.

kamer · ‎03-04-2020

Hello,

How can i convert a notification body as a pdf and attach to that same email.

AbdulAzeez · ‎03-21-2017

Suprakash,

Please mark it as correct and close the thread.. I think you must do this

suprakash · ‎03-21-2017

At first I will like to thank Nayan

Abdul Can you please provide me or help what are what you added in sys_properties table . so that i also add into my instance also

AbdulAzeez · ‎03-21-2017

Suprakash,

go to sys_properties table and create 2 new properties name it as glide.user.userid and glide.user.password, give type as string and value must be your user id for glide.user.userid table & your password for glide.user.password type as string and value must be your password.

then the magic happens

Thanks,

Abdul Azeez

PS: Hit like, Helpful or Correct depending on the impact of the response