I am using google forms to punch orders in my Google Sheets.

Although I am facing a challenge as the number of products is variable.

For example

Question 1: Item Name 
Question 2: Quantity

I want the responder to add as many items and quantities as they want.

Is it possible to do the same with core features or appscripts? If not possible with google forms, is there any other form app to do the same?

  • Welcome. How many items do you have? – marikamitsos Feb 3 '20 at 12:15
  • I have around 1000+ SKUs. Thanks! – eceo Feb 3 '20 at 12:28
  • 1
    That is way too many for a Google form. Sorry. – marikamitsos Feb 3 '20 at 12:36
  • Whats on your mind if the number was less? – eceo Feb 3 '20 at 12:38
  • What I had in mind would be 15-20 max. So ... forget it. – marikamitsos Feb 3 '20 at 12:43

You could use sections having each section with three questions

  • Item name
  • Quantity
  • Would you like to add another item? (except in the last section)

The "Would you like to add another item?" question should be one of the types that allow to jump to another section. In case that the respondent choose No, then submit the form.

On the last section you could tell to the respondent that if they want to add more items, they should send a new form submission. You could set your form to show a link to submit another form response in the form submission confirmation page.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.