In my example, I use a “Multiple choice” question type to get the product. For the products/services input, you can use a “Short answer” question and get the name, so basically there is no limit to the number of products/services you can create invoice with. The template for the invoice, in the Google Sheet, has space for 20 fields, so you can create up to 20 fields to be populated with product details. This means that I can populate only 5 fields in the invoice with any of the 6 products. If these limits are not making you problems then this is the perfect solution for you.įor this example, I have created a Google Form that includes 6 products and 5 fields to populate the invoice template. Also, you have to define upfront, the maximum number of items you going to include in your invoice. The problem in creating this type of form is that the more products or services you sell the more complex the input field is going to get. If you are a beginner you can learn more about Google Forms from this article: How to Create Google Form and How to Google Form Responses. Create a Google Form to collect Invoice data But this setup is going to be very easy to implement, you will have your data in one place, you will automate the whole procedure and you can track payments much easier. I know it sounds difficult, I know you have your template in some document or maybe in a spreadsheet with formulas to do the calculation for you.
0 Comments
Leave a Reply. |