Write a short description
Custom Invoice Generater
You can create customizable Invoice with Google spread sheet
Add a picture of all the blocks
Write instructions to use your extension
Firts of all you need to go to your Google spread sheet and then create your pdf layout and leave that cells values blank that u want to change and note the cell position (Colum+row) like A24 cell…
then open script editer…
now download this script from extension’s description and put in the google spread sheet script editor and deploy the script and copy script url…
Now all done…
Working of extension
On screen intialize we need to put spread sheet’s detail(script url, sheet id, sheet num, sheet name)…
Now use web component with passvalue value block to pass values to specific cell of spread sheet… And then use button or method to perform the action
Important note…
On Web got text event we need to set last text box like this to download/generate invoice automatically …
And you can set custom filename and folder name in which invoice save as pdf…
And now on download complete event u can view your invoice as pdf
Include a Download link here; can be direct or a link to your website/host
Aix
Custom_Invoice.aix (56.7 KB)
Aia
CustomInvoice.aia (114.4 KB)
Test apk
Custom Invoice.apk (5.5 MB)
script link
https://drive.google.com/drive/folders/1mMmlOLbkKotP3pweWL8ig_8my3TnHG80
Test apk
…