How to Generate Invoice in Appsheet | PDF Generation in Appsheet | Appsheet Automations

[@radjirahim]

awesome

[@gandikha]

thank you so much sir

[@futuretechindian]

Very nice.

[@appsheetwithadithya]

Thanks :)

[@risheekkumar8908]

Very Useful Video Adi! Exactly what I needed for something. Continue the great work!

[@appsheetwithadithya]

Thanks da😇

[@shweta-singh012]

It's little complex to understand but thank you for your hard work.

[@amirgroupserviceteam1059]

i have a problem when i open pfd for print. when show '/appdata/Files/LB-4.pdf' not found Probable cause: N/A Path: Root Result: FAILURE Message: N/A Details

[@appsheetwithadithya]

Check your path it should be "data/appsheet/yourappname-somenumber/Files/LB-4.pdf"

[@shibanandachoudhury5379]

I am facing a similar problem, even after checking the folder sequence and name properly. Here is how I assigned as file location starting from first folder inside my g drive- "/appsheet/data/App-196066121/Files/Quotations/Q10001.pdf"

[@shreyassaoji]

HOW TO CREATE INVOICE TOTAL?

[@rizakarinaulia2008]

thanks brother, very usefull, is it ok if ask your PIP video to be move on the right top, so i can see the sheets item, thanks,

[@appsheetwithadithya]

Oops sorry i dint notice that will fix that in upcoming videos

[@rizakarinaulia2008]

@@appsheetwithadithya thanks brother, your're the best

[@dgrolfe]

When did you create the column "Related Invoice List of Items"??? I don't see where or how that was created....!

[@ณรงค์เดชพุทธพิทักษ์-ษ3ศ]

Sorry we can set the font like template google doc?

[@appsheetwithadithya]

Yes

[@ณรงค์เดชพุทธพิทักษ์-ษ3ศ]

@@appsheetwithadithya Can you give me some advice?

[@appsheetwithadithya]

@@ณรงค์เดชพุทธพิทักษ์-ษ3ศ you just change the font in doc it will reflect automatically in appsheet

[@oktarogandipolindo891]

Hello Mr. Adithya , After i try follow you , its good . But i have problem , example , what i can add more coloumn in invoice list item ? In your videos , is 4 coloumn , if i want add more coloumn can or not ? Thankyou very much #Indonesia

[@appsheetwithadithya]

Yes you can add as much as columns you want

[@anandmallikarjunan7775]

Is there any face recognition option like the Scanning option in Appsheet? If so, how to use it? Please explain. Thanks. Wish you good luck.

[@bcshetty11]

How to add colour condition in Google docs i.e if -ve valve then colour should be Red and if +ve valve then colour should be Green.

[@09-aloksinha85]

How can change date format in pdf report

[@warriorzbasketball]

Thanks for this Adithya. However you lost me at the end. I would like to see how you add the total aswell as how to include vat

[@kito8648]

hi bro i can generate pdf file but columns remain empty, any suggestion?

[@appsheetwithadithya]

Check your expression >

[@rameshbandai7726]

Hello brother It is possible to send generated PDF file using whatsapp Automatically ?

[@vjayshrma]

Thankyou Adithya for making such valuable videos! I was able to save the file as pdf. I cannot open the file. It says pdf not found. I gave the .pdf also still I'm getting. My file location is also proper like it starts from 'appsheet/data till file name'

[@appsheetwithadithya]

What is your file name? check properly in google drive and compare with the link in google sheet

[@grocykrt4386]

How to insert GST & Total in Invoice. Please help

[@abhijeettrivedi565]

Hi, Why is there yellow triangle with exclaimation mark in reference record that is created in invoice id (Child Record)

[@lavanyasenniappan3832]

Hai. While generating a pdf document template using word document...I got an error like "Input string was not in correct format" error. I don't know where the issue was. Can you please help me?

[@appsheetwithadithya]

check the expression of syntax

[@luisgomesmachado4066]

Hi Chennai, thank you for your video. When we create an invoice clients in some cases expect a sequencial invoice number, even though this number does not need to be the Invoice ID or a Key to appsheet, how can we create a sequencial number? Can you please elaborate a bit more on this?

[@appsheetwithadithya]

You can use count() function in pdf template to count your previous number of invoices

[@uminkyaw1739]

Thanks Aditya. But I have difficult to understand. Invoice app in your tutorial video is not deployed app. Even your not deployed app make automation bot. For me, I also have not deployed app. But I didn't make automation bot because Appsheet left message that since app is not deployed, bot will deliver email only to app owner and task cannot be use in this process. So what can I do more? Please let me know. I'm from Myanmar.

[@appsheetwithadithya]

You can use without deployed also if you deploy email will to go the respective user it doesn't cause problems in invoice generation

[@jicbro35]

Hi, how can send this pdf to any mail automatically, plz assist

[@learnwithwasim]

how to give serial no. for items in pdf

[@appsheetwithadithya]

You need to give in spreadsheet data and fetch it from there

[@learnwithwasim]

@@appsheetwithadithya how

[@archiebalatucan4625]

Hi Sir Chennai, Thanks for your video it's so very helpful to those beginners like me. By the way, I use this Generating Invoice App to my project right now but I use it as inventory borrow and returned. Can you help me how to add a status (Available & Issued) that when I add to issued item (which is your Invoice bill) it automatically change the status and the quantity also change. I hope you can help me. Thank you

[@شركةلوفيتال]

i have a problem , that i added more than 2 table but no appear except 2

[@appsheetwithadithya]

Please check the and expression

[@iliaryzhkov]

Great video, thanks very much. I wonder if there is a simple way of putting the first record of the [Related Invoice List of Items] in the template? I've tried TOP() and ANY() together with LIST() but those didn't work. I still get all records from the list.

[@appsheetwithadithya]

Use [_RowNumber] = 1 in filter condition

[@iliaryzhkov]

@@appsheetwithadithya Got it resolved. I needed to filter out the [Related Datos] instead of constraining the individual columns.

[@Otisawide]

Awesome! Does the file can be downloaded by push an icon inside Appsheet it self?

[@appsheetwithadithya]

You can download the file by opening in separate chrome tab. There is no option direct download from appsheet

[@Otisawide]

@@appsheetwithadithya thank you 🍊

[@ashwikumar1990]

Hi, how do I email that pdf directly after generated

[@NimbleNuggets]

How can use multiple Vlookup in appsheet. Please help.... bro

[@NimbleNuggets]

Bro please make video

[@appsheetwithadithya]

you can use ANY(SELECT()) fuction

[@NimbleNuggets]

@@appsheetwithadithya bro please make video please

[@temyraverdana6421]

Hi, thanks for videos, very useful for me. I have a question. Is it possible use google sheet as template? Thanks a lot and see you next

[@appsheetwithadithya]

No, you cant use google sheet as template instead you can use table in google doc for template

[@temyraverdana6421]

@@appsheetwithadithya Thanks for your answare.

[@wayneynot]

I'm looking for something that generate age in appsheet.

[@Yossinuri]

Thank you for the video great job. but I have only one problem I cannot open the PDF I keep getting an arrow "not found" any suggestion?

[@appsheetwithadithya]

Check the pdf file in your google drive

[@scripterman]

Hi Chennai, great video, what you did in 30mins still took me a couple hours, but it looks great. The Ref bits made my head hurt lol... Did you ever manage to SUM up the Invoice, I'm not sure whether to create a new column in the spreadsheet with some logic or can it be done in Appsheet? Thank you

[@appsheetwithadithya]

Please watch this video kzbin.info/www/bejne/jobZaGqnird8i5I

[@Ecobarter]

Hi Chennai, this video was so helpful. Please how do we go about summing the prices on the invoice list?

[@appsheetwithadithya]

Please watch this video kzbin.info/www/bejne/jobZaGqnird8i5I

[@gk-forumkerala1421]

Very nice presentation.. actually I was stopped appsheet works due to lack of knowledge to complete invoice generation process. Especially multiple rows loop #kerala#Calicut

[@muthukumaraswamyr6721]

Very nice presentation. Will this invoice generation be possible in 5 Dollar per month plan? Or 10 Dollar per month?

[@appsheetwithadithya]

how many users using?

[@muthukumaraswamyr6721]

@@appsheetwithadithya It will be very less, may be 2 or 3 only. We are a very small company trying to build some forms and reports for our internal use

[@muthukumaraswamyr6721]

👍👏👌Really appreciate your prompt reply

[@appsheetwithadithya]

@@muthukumaraswamyr6721 you need appsheet core plan which costs 10$/month please contact me @ whatsapp [phone] to help you with this subscription cost

[@muthukumaraswamyr6721]

@@appsheetwithadithya OK. Will contact you tomorrow

[@AbelTabz]

I learned alot from you and i like your tutorials but 1 comment only, please don't block the tabs of the google sheet, we can not see whats in there 😅😅

[@appsheetwithadithya]

Oops sorry😬 i didn't notice that will fix that from upcoming videos

[@ammaralasyful]

HI Adithya, Great tuotrial. voice is not clear. your front camera hiding important info

[@audreneyap8209]

hi I STILL CANT OPEN PDF

[@appsheetwithadithya]

Please check your pdf file name in gdrive which should be same in the spreadsheet link also

[@audreneyap8209]

@@appsheetwithadithya hi thx for ur reply ,n was so helpful. can i do generate invoice in another table ? cuz when i do the second one i cant open pdf shown fail agian

[@appsheetwithadithya]

@@audreneyap8209 i don't get you

[@stefaaneeman]

Can you please share this app so that I can look under the hood?

[@appsheetwithadithya]

Can you please contact me @ [e-mail]

[@shareef9button802]

hi sir

[@MindAccessTHIef]

I am working as teacher..I would like to maintain my class students weekly test marks record in appsheet and also like to generate as PDF file whole rows in one PDF file (25 rows in 1 page) but i could generate only one row in one page....for example if I have entered 25 weekly marks in record by using appsheet( I have included HM sign and class teacher sign too)..it means 25 rows in sheet then I try to generate whole rows and column (25 X 10) I want to genrate my whole records in legal sheet land scape ... Is there any way?...pls help me ...it will promote me and my co-workers(teachers).....thank u ..i need a video explaination..I think, text explanation is not easily understandable ...atleast photocopy explanation is fine for me.

[@ManishKataria123]

Sent you an email pls check for Appsheets