full blocks
i have tried but not getting right way
iam creating invoice app
1 Like
Almost Everything is available in post… You need a try according to post…
You can create fully customizable pdf invoice creater app just follow the post…
post link or aia file
in google sheet
TypeError: Cannot read property ‘parameter’ of undefined (line 8, file “Code”)
Publish as web app…
Check your script URL, normally it`s ending is like …/exec, but before adding any parameter you should include ?, so after including your parameters your script URL should look like this …/exec?cname=Sreenu&caddress=Delhi&cphone=555667788&gst=…
1 Like
Before downloading the pdf file I prefer to format a little bit the page. Here are the steps that I follow:
1 - Take the spreadsheet ID for edition, should be something like this:
https://docs.google.com/spreadsheets/{yourSpreadSheetID}/edit?usp=sharing
2 - Replace the last part (edit?ups=shading) for this export?exportFormat=pdf&format=pdf
3 - Now include all the parameters that you could need (here are some of them):
&size=letter + //paper size
&portrait=false + //orientation, false for landscape
&fitw=true + //fit to width, false for actual size
&sheetnames=false + //hide sheet name
&printtitle=false + //hide title
&pagenumbers=false + //hide optional
&gridlines=false + //false = hide gridlines
&fzr=false + //do not repeat row headers (frozen rows) on each page
&gid=; //spreadsheet ID, this will be populated in the FOR loop
&single=true + //number of copies
1 Like
Can you share the .aia file? please
Can you provide aia ?
How to do this