Learning such tools from professionals will cost hundreds of dollars. Mr. Amit is real hero, giving away such a productive tips for free. Thank you sir. :)
WOW!!! AMAZING. THANK YOU , I MIGHT HAVE TO WATCH , PAUSE, WATCH , PAUSE ABOUT 100 TIMES BEFORE I SUCCESSFULLY COMPLETE A FULL FORM , BUT IT WILL BE WORTH IT!! THANX
@Amit Agarwal ! I have been a huge fan of your website for a few years now and I never even thought to check out your TH-cam! You are so AMAZING & TRULY TALENTED! I have learned so much from you and I don’t know if I would have been able to learn so much had it not been for your tutorials!!! You are so TALENTED & SMART!!! 💜💜💜 THANK YOU!!!!!! 😍
Nice! This is amazing. But is this usable if it's a bit more complicated?: For example if the cake have different 4 sizes, S, M, L, XL? And someone want's to order 2 of the same cake and another cake at the same time? How to you get the total price with the array formula and how to structure the price list?
Oh wow. This is so straight to the point and in my honest opinion, an excellent presentation of the whole work flow which others want to keep for themselves. Your accent is neutral and your voice calming. Your new fan here.
You actually simpulated a real order and didn't got the "Test" this "Test" that dummy data. Well done. Thank you for such a clear and useful presentation/tutorial. Jusy what I'm looking for to replace our fragile Appscripts invoice creator.
This is the right video that I am looking for it. I am seeking for how to generate the invoice and send email as well. This is suitable for me and motivate me to do next project. Thanks a lot for your great tutorial.
This is amazing, I usually try to make Business, Orders, Invoicing very simple and Less time consuming process.. I was doing all such things also facing some problems but now you have made the process so simple and easy.. I'll add UPI QR Code instead of PayPal Link ( Already learned from your video ) to make invoice in same format. Thank you so much Amit.
I am trying to make a new online business and want to automate all invoicing your lesson is the answer of my business "writerblock" Thank you so so so so much
Hello Amit. This is a great video. I do have one question: How do you get multiple files of the same person into just one combined folder in Google Drive instead of a separate folder for the same person based on every entry?
I've been reading your site labnol since almost a decade now and you're always coming up with something new and awesome and most importantly - shareable and that many others can benefit from. Thank you sir!
Thank you so much for this! My problem is that My Studio App doesn't run on my computer. I wonder if it's not in use anymore(??). Now I have to find another way for creating invoices with using Forms.
Sir I am using document studio with vlookup command in google sheets. Once I fill up the google form and submit the sheet in itself the vlookup command given in google sheets fills up couple of values. But the pdf made by document studio doesn’t picks the values generated by vlookup commands. Please suggest.
What will be the formula if my prices are whole numbers? When I use the array formula for example from prices sheet its 300.00 then on the actual sheet it became 300 without the zeros, can you help on this?
Thanks for the nice tutorial. How do I create the same workflow with multiple items included on the same order. Instead of ordering one cake only, the client can order a cake, some drinks, ice cream etc?
Hey! Bro here you have only one item ie., Cake . But i have N number of items (Hardware store) . So if i wanted to show the "n" number of items that which have been purchased from my store How should i do it? Constraints: Customer 1 may buy 5 items where Customer 2 may buy only 2 items. So based on this how to make it
Great Tool Sir. Only problem is how to add multiple items to invoices. How that kind of data will be handled by form and most importantly sheets for proper calculation. Would love to use and promote this as a tool for creating invoices for small businesses but can't figure out how to add multiple items and thier calculations. Please give some idea. I've created similar tool in MS Access where I used subdatasheet. But can't find similar feature in Google Sheets. It would be super helpful for lot of us if we can create our own invoicing system with google forms + sheets + document studio. Also we can take that to whole new level by also adding script to sheet which will add google calendar event according to invoice due date. And also a column for payment status. Endless possibilities. Only if we know how to add multiple items to invoice. Either way, Thank you for creating this awesome tool :)
Is there an option or further decision branching on the document generation process? For example, a certain customers may want email notification but some may not. For those who opted for email notification, we can send one to them. But for those who declined, we do not do so. How to make this automatic in Document Studio?
Amit do you know if it's possible to generate an individual QR code for each order - automatic for large volumes of orders? Something i'm working, need your help!!
I think this work well if the customer only purchase 1 item, but what if they want to purchase multiple Items with various quantity? The form response should contain another columns for the total of each item. How do the add on knows which is the total column for each product that has no blanks, and automatically email them?
This is not working I ma getting this error.. Sign in with Google temporarily disabled for this app This app has not been verified yet by Google in order to use Google Sign In. WHY???
for the if/vlookup, do you have to put in for else "" or can you leave blank? i always use ""... also i never knew isblank.. i used always Len(A2)=0 ... that is, blank. would you recommend isblank? does it take up less memory/space?
Gread video, is it easy to replace google form with an other data source like webwsite form(wordpress, scretch coded or shopify for example)? Or if thats not possible maby by importing a excel ?
Very nice video. I have a question: with my VLOOKUP I want to capture a date. If I insert a name direct from the sheet its works fine. But when I do it from a Form, the information goes to the sheet in a wrong format (simple text or automatic). I´ve already format both columns to DATE. How can I fix it? Sorry for my bad english and thanks!
Hey Amit, your tone, video and background music all make for a perfect online tutorial. Document Studio is awesome. I was just wondering if we could use a conditional 'if' statement to exclude a bunch of data on the resultant PDF if a particular field is not filled out. Thanks a bunch!
Amit sir can we put in a condition that the invoice should be printed when final confirmation is given and an enquiry has basically converted into a customer?
The videos on productivity automation we all want, the hero we don't deserve.
Rock on Amit Agarwal!
Thank you 💕
Mr. Agarwal,
You are by far, the most amazing person ever. This tool is amazing. You are awesome. Thank you.
- Robert
This is not spam. Amit has helped me in my business for years. All of these tools and tutorials are always spot on. Thanks again!!
Learning such tools from professionals will cost hundreds of dollars.
Mr. Amit is real hero, giving away such a productive tips for free.
Thank you sir. :)
I don't think you could ever find a more helpful google forms video anywhere. Thank you so much!
Holy Molly! I never knew Google docs is callable for such automation with no coding at all! Thanks much for this tutorial!
WOW!!! AMAZING. THANK YOU , I MIGHT HAVE TO WATCH , PAUSE, WATCH , PAUSE ABOUT 100 TIMES BEFORE I SUCCESSFULLY COMPLETE A FULL FORM , BUT IT WILL BE WORTH IT!! THANX
the ambient sound is so relaxing and surprisingly i somehow love how you talk.. keep it up
Amit, you have engraved your name in cyber world with your handy, creative, google products related solutions. Thank you sir.
@Amit Agarwal !
I have been a huge fan of your website for a few years now and I never even thought to check out your TH-cam!
You are so AMAZING & TRULY TALENTED!
I have learned so much from you and I don’t know if I would have been able to learn so much had it not been for your tutorials!!!
You are so TALENTED & SMART!!! 💜💜💜
THANK YOU!!!!!! 😍
Wow, this video is incredibly informative and well-presented! I learned so much from watching this.
Glad you enjoyed it!
Nice! This is amazing. But is this usable if it's a bit more complicated?: For example if the cake have different 4 sizes, S, M, L, XL? And someone want's to order 2 of the same cake and another cake at the same time? How to you get the total price with the array formula and
how to structure the price list?
did you get the answer for this? Please share it.
Oh wow. This is so straight to the point and in my honest opinion, an excellent presentation of the whole work flow which others want to keep for themselves. Your accent is neutral and your voice calming. Your new fan here.
I have been searching for this video for years. Thanks. God bless you.
You actually simpulated a real order and didn't got the "Test" this "Test" that dummy data. Well done. Thank you for such a clear and useful presentation/tutorial. Jusy what I'm looking for to replace our fragile Appscripts invoice creator.
252 currently dislikes who not about into word "business". Loved this educational tutorial!
Exactly what I needed. Thank you for the clear and practical explanation!
In case you didn't know, this guy is a mega-genius with Google Apps Script!
Hi! Thanks for the guide, I'm wondering it is possible if we could set up the Google Form so the customer can put the order more than one item
That spreadsheet skills are out of this world!
This is the right video that I am looking for it. I am seeking for how to generate the invoice and send email as well. This is suitable for me and motivate me to do next project. Thanks a lot for your great tutorial.
I didn't think that we can do this in one step! I will practise and apply it in work. Thank you...
In the love the way you explain and create solutions, keep it up the good work Amit
Impressive Amit. You created a more automated business than most in just 14 minutes lol
This is by far the most amazing video I have seen based on Productivity. Thank you So much for this Amit
Excellent video. you deserve millions of viewers. Thanks.
I have seen alot of related videos but you just explained everything so smoothly and to the point, I am impressed. Great Tutorial !
Thank you for great explanation. Love from Sri Lanka 🇱🇰
You will definitely become the top 1 who makes cracks
I've been watching your channel since 2014. You're 👍 awesome 😎
Never see this before a pleasure to see how can we make simple things with imagination, thanks a lot great video
Mind blowing man. You already achieved 🔝 level of drive
Best tutorial I’ve ever seen in my life
This is amazing, I usually try to make Business, Orders, Invoicing very simple and Less time consuming process.. I was doing all such things also facing some problems but now you have made the process so simple and easy.. I'll add UPI QR Code instead of PayPal Link ( Already learned from your video ) to make invoice in same format. Thank you so much Amit.
I am trying to make a new online business and want to automate all invoicing
your lesson is the answer of my business "writerblock"
Thank you so so so so much
Hello Amit. This is a great video. I do have one question: How do you get multiple files of the same person into just one combined folder in Google Drive instead of a separate folder for the same person based on every entry?
You are a Master.......and your voice is also very clear and understandable........and as gift i am subscribing your channel......😊
I've been looking for this for a very long time!
Thank you Amit, this is an amazing scheme of Google docs interaction!!!
I've been reading your site labnol since almost a decade now and you're always coming up with something new and awesome and most importantly - shareable and that many others can benefit from. Thank you sir!
Wow....great new things Google Docs has created. I will learn to make use of some of them. Thanks
Gosh. Mind blowing. We are doing it all manual in gsuite and this is really mind blowing. Thanks for this sharing !
Excellent Explanation Amit Agarwal, You are really Great , Great Job
Wowwww!!! You are so genius!!! So amazed with your google drive’s knowledge! And thank you for sharing all of these :)
Amazing and Awesome!!! Thanks for your kindness to share this. Very useful! Wanted to learn more from you....
what a good job mate 👍
Clear, clean, simple and pleasant to view.
Thanks !
You're from india, right ?
Thank you sir for sharing your valuable knowledge to me. It was very unique.🙏🙏🙏
Hiten from India.
Awesome Buddy. This Video Opened doors to many possibilities at my end.
Thank you so much for this! My problem is that My Studio App doesn't run on my computer. I wonder if it's not in use anymore(??). Now I have to find another way for creating invoices with using Forms.
Sir I am using document studio with vlookup command in google sheets. Once I fill up the google form and submit the sheet in itself the vlookup command given in google sheets fills up couple of values. But the pdf made by document studio doesn’t picks the values generated by vlookup commands. Please suggest.
Awesome explanation! Love it. Great job, Amit
Everything works, especially free, use until it is too late!Cool! Downloaded))
Google forms se WordPress thank you page ka automation possible hai ?....kindly suggest a method or plugin... thanks
What will be the formula if my prices are whole numbers? When I use the array formula for example from prices sheet its 300.00 then on the actual sheet it became 300 without the zeros, can you help on this?
Amazing job Amit🙏. Clearly explained and neat presentation.
Wooow, amazing, am not a IT guy, i love ppwk outo flow. Love it. I need to learn all that process.
Thanks for the nice tutorial. How do I create the same workflow with multiple items included on the same order. Instead of ordering one cake only, the client can order a cake, some drinks, ice cream etc?
Thanks Amit, really good informative video, to the point, clear and concise, thanks again :)
Hey! Bro here you have only one item ie., Cake . But i have N number of items (Hardware store) . So if i wanted to show the "n" number of items that which have been purchased from my store How should i do it?
Constraints:
Customer 1 may buy 5 items where Customer 2 may buy only 2 items. So based on this how to make it
Your presentation is very professional.
Great Tool Sir. Only problem is how to add multiple items to invoices. How that kind of data will be handled by form and most importantly sheets for proper calculation.
Would love to use and promote this as a tool for creating invoices for small businesses but can't figure out how to add multiple items and thier calculations. Please give some idea. I've created similar tool in MS Access where I used subdatasheet. But can't find similar feature in Google Sheets. It would be super helpful for lot of us if we can create our own invoicing system with google forms + sheets + document studio.
Also we can take that to whole new level by also adding script to sheet which will add google calendar event according to invoice due date. And also a column for payment status. Endless possibilities. Only if we know how to add multiple items to invoice.
Either way, Thank you for creating this awesome tool :)
Whoa! What are you? GOD?
too good man!! Hats off to you... 👌👌👌👏👏👏👏
Did you use scripts to be able to use the maps and paypal functions?
Very Useful. the speciality is the Good voice.. Nice.. Thank you
dangggggg! i got goosebumps for your this great video! thank you so much!!! invoice emailed
Thanks a lot for your explanation, but may i ask you something. Can i use payment method other than paypal? Thanks for the amswer.
Is there an option or further decision branching on the document generation process? For example, a certain customers may want email notification but some may not. For those who opted for email notification, we can send one to them. But for those who declined, we do not do so. How to make this automatic in Document Studio?
Wonderful explanation.. This will be very useful for many small size companies where a cost effective solution is required. Thanks for sharing.
Wow.. simply wow . So clearly explained
great video, Do you know if Googlemaps function is still available on google sheet ?
Wow!!! Thank you for such an awesome video. This will really help streamline my process. I had no idea I could do this is google!
Awesome...you're jenius and very kind of person ..thank you, wait for your next video
Super impressive. Even if I don't buy I've learned about array formulae.
What are you doing about the numerous, unresolved feedback from aggrieved customers?
You deserve more subs brother! Thanks for this amazing informative video!
Amit do you know if it's possible to generate an individual QR code for each order - automatic for large volumes of orders? Something i'm working, need your help!!
I think this work well if the customer only purchase 1 item, but what if they want to purchase multiple Items with various quantity? The form response should contain another columns for the total of each item. How do the add on knows which is the total column for each product that has no blanks, and automatically email them?
You are a wonderful teacher. I cant' wait to implement this in my company.
How did it go? Do people are using it?
@@gillanR it went really good! Preparing and sending invoices is a very burdensome task. Now it costs me 9 usd/mo for it to happen automatically.
Amazing yr. This is what we need..Salute you sir.
You are a wizard!!!! Thank you so much!!!
This is not working I ma getting this error.. Sign in with Google temporarily disabled for this app
This app has not been verified yet by Google in order to use Google Sign In. WHY???
Ur loged in with 2 accounts
Very helpful tutorials, even for spreadsheet formulas...and above very simple usage
this is perfeccctttt - ok, I have one question, Instead of auto sending an invoice, can I have them select (Pay In person) or Pay online?
for the if/vlookup, do you have to put in for else "" or can you leave blank? i always use ""... also i never knew isblank.. i used always Len(A2)=0 ... that is, blank. would you recommend isblank? does it take up less memory/space?
This was soooo helpful! Favoriting and adding to my edu playlist!! Thank you!!!
Nice! Brilliant! Cheers mates!!
Thanks from Brazil, you saved me!
Cara, é seguro baixar? Navegador diz que não é seguro..
Gread video, is it easy to replace google form with an other data source like webwsite form(wordpress, scretch coded or shopify for example)? Or if thats not possible maby by importing a excel ?
Wonderful product... Does it work with Stripe? Thank you.
There is no document studio on the google sheet..is there any other ads on?
Very well explained... good work and thanks for your time and knowledge share. I failed to understand why few people gave a thumbs down!!
Can we merge the spreadsheet with more then 1 google docs file and send it simultaneously to 1 email address?
I had one doubt. Can I create multiple email templates from the same google sheet?
Best tutorial! Very informative. Life saver!
Very nice video. I have a question: with my VLOOKUP I want to capture a date. If I insert a name direct from the sheet its works fine. But when I do it from a Form, the information goes to the sheet in a wrong format (simple text or automatic). I´ve already format both columns to DATE. How can I fix it? Sorry for my bad english and thanks!
Hey Amit, your tone, video and background music all make for a perfect online tutorial. Document Studio is awesome. I was just wondering if we could use a conditional 'if' statement to exclude a bunch of data on the resultant PDF if a particular field is not filled out. Thanks a bunch!
thanks man much easyer than the other vidioes
Absolutely too good. The power of google! 😄
almost took me a year to watch this video, but awesome stuff. good job.
Amit sir can we put in a condition that the invoice should be printed when final confirmation is given and an enquiry has basically converted into a customer?