Ruchi Trivedi
ShiokFarm Order Form
Posts
Support
Hi,
I'm using Google Forms and have added Formfacade to allow me to create summaries for customer orders. I need help understanding how to create (a) Cost per product order and (b) Total Order Summary.
Let me know how I can achieve this? FYI - my form is filled by about 40 people every week.
Regards
Ruchi Trivedi
Hi Ruchi, If you have already created a form in Google Forms, you can customize it using the Neartail addon to add amount calculations and show order summary. Otherwise, you can use the Neartail templates to create an order form.
Neartail pricing
https://neartail.com/order-form/pricing.html
Neartail templates
https://neartail.com/order-forms
You can pick the preferred template, edit it to add your products and then use the Neartail share link to collect responses. Order amount, summary calculations are included in the templates by default. If required, you can also add discount, tax, delivery fee calculations in your form.
Neartail - Order form addon for google forms
https://workspace.google.com/marketplace/app/neartail_order_form/743172720058
Open your form in Google Forms > click on the addon icon > click Neartail > click Calculate order amount > select the currency, enable format prices option, click Next > select Calculate amount based on price option, click Proceed > Neartail Edit page will open in a new tab > if required, you can then customize the form and the use the Neartail share link to collect responses.
Fri Jul 26 2024
The issue we have concerns sheet *“ORDER DETAILS”*, some of the names of our products are not being downloaded correctly into the Google Sheet. The new name we gave in the form for the products (fruit & veggies) are not updating in the Google sheet. For some reason, the names in column E and F are correct, then *they are not correct in column G to AK*. And then we have what looks like correct names again.
To help you check faster: *all our product names for vegetable and fruit have their country of origin into brackets* (ie: (Thailand), (Australia), etc)) *included in their name*. If one sees the name of a fruit or vegetable on row 1 that does not have the country of origin, then it means the name is not the one we edited in the form.
As a consequence, the macros we are developing for the Google sheet are not working as the names are not matching.
Hi Ruchi, we already discussed this on email. When you export the data from Neartail Reports, it will create three sheets (1) Order summary: This includes the customer contact details, amount and other fields in the form. (2) Order lineitems: This includes the order lineitems data. You can use the pivot table option on this sheet to create the aggregate reports you need. (3) Order details: This includes the quantity ordered for the products in each order. Each product will be added as a column. For products with variants, each variant will be a separate column.
If you add new products in the form, it will be added at the end in the Order Details sheet. If you update the product name, it will not be updated in the Order Details sheet currently. We plan to implement this option in the coming releases. In the meantime, you can use Neartail Reports or use a pivot table option on the Order lineitems sheet that will have current product name.
Thu Aug 22 2024