1st time on kodular a great logic…
Total 3 step and every step quite easy…
post edited (3rd step added)…how to download/view spreadsheet as pdf in app instantly
easy method to create custom pdf layout also u can create an invoice creater app and much more by this method…no extention only logic just follow steps…
1st step
open ur google spreadsheet in any browser and then modify pdf layout by ur taste and copy row/colum of that field where u want to pass value…then open script editer from tools options…
2nd step
now modify this script code by ur pdf layout…
function doGet(e){
var app = SpreadsheetApp;
var ss = app.getActiveSpreadsheet();
var activeSheet = ss.getActiveSheet();
addUser (e,activeSheet); }
function addUser(e,activeSheet)
{
var amount = e.parameter.amount;
activeSheet.getRange(26, 4).setValue(amount);
}
after setting of script code u need to publish this as web app
Copy ur spreadsheet link and edit that link (from end) like below pic…and set it to in downloader…
when downloaded done then set view pdf from storage where u dowloaded the pdf file by activity starter or and pdf viewr extension Note after every change u can download new pdf with new values…
important note; change the privacy of googlle spread sheet and script editor as anyone can edit…
A simple custom pdf creater or u can say invoice creater app…
u can change edit full pdf view add pics…
u can save/print ur pdf file also.
u can do what u want…
no…only web component used in this components…
no liberary
no pdf generater extention
no json code
no activity starter
no ftp server
no php
no mysql…
only a big logic used