How to print each order for packing?

"this will have blank spaces in every response from the user"- Google Docs Editors Community

When a Google Form has many products, each response row in the Sheet is mostly blank cells, because nobody orders everything. Whoever packs has to read across the row to find what this person wants, and printing a response from Google Forms gives the whole form with every product on it. Joining the cells takes a formula, and one misread row sends the wrong order out. With Neartail, you print each order on its own page: the order number, only what was ordered, the total and where it goes. On a busy day you can print a whole column of orders as one table.

Let's start. Import your Google Form and follow the steps below.

1. Import your Google Form

On the page that opens, paste your Google Form's link or click Browse to pick it, then click Import. Select your currency and click Continue. When it says "Your order form is ready", Neartail has made a product from each question with a price and added an order total and summary. If it says no products were found, add a price to any question. Click Preview your form, then click Edit form under Manage to open the form builder.
The Neartail page to import a Google Form, with a form link pasted in and the link box and the Import button marked

2. Open the order

Your new form has no orders yet. Click SHARE, click Link, click Open and place a test order. Then click ORDERS, then Kanban board. Under Submitted, click the order you're packing.
The Kanban board with three orders in the Submitted column and order #3 for Maria Garcia at $21.50 marked

3. Click Print

Click the ⋮ at the top of the order and choose Print.
Order #3 open with 2 Cheeseburgers and 1 Fries, a total of $21.50, Maria Garcia's phone, email and address and its menu with Print marked

4. Pack from a page with no blanks

The page has the order number, only what this person ordered, the total and their name and address. Pack from it, then put it on the bag.
The printed page for order #3, listing Cheeseburger 2 and Fries 1, Order Amount $21.50 and Maria Garcia's name, phone, email and delivery address

5. Print a whole column on a busy day

Click the ⋮ on the Submitted column and choose Print, then choose how many orders and click Print. You get one table with a row for each order.
The printed table with columns for the order number, customer, address, order and payment and a row each for orders 3, 2 and 1

Summary

A Google Form's responses are rows of mostly blank cells, and printing one gives you the whole form. With Neartail, you print each order on its own page with only what was ordered and where it goes, or a column of orders as one table. Import your Google Form and complete the steps above.

Print each order from your form for packing.

Import the Google Form your orders come in on, open an order on the Kanban board and choose Print, so you pack from a page with only what was ordered.

Last updated: