How to calculate shipping fees based on delivery zones?

"We charge a diagnostic fee depending on the customer's vicinity from the closest shop."- Google Docs Editors Community

When the delivery fee depends on where the customer lives, a Google Form can ask for the area but can't charge for it. Every answer to "Choose the delivery area" costs the same as far as the form knows, so you read the area on each order, look up the fee and add it yourself. In Neartail, the FEE function gives each delivery zone its own fee. The customer picks their area on your Google Form and sees the fee and the amount to pay change before they submit.

Import your Google Form and follow the steps below.

How to calculate the shipping fee?

  • 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, under Manage, click Edit form 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
Your form now has your products and an order total question that adds up by itself. In this article, it's called Order Amount.
Add a multiple choice question for the delivery zones and a Delivery Fee that charges for each one.
  • Click on the Order Amount question, then click Add field in the toolbar on the right
The form in the editor, with the Add field icon marked in the toolbar on the right
  • Enter Choose the delivery area as the new question's title
  • Change the question type to Multiple choice in its list. Type the first delivery zone in the Option 1 box, then click Add Option for each of the others, because pressing Enter does not add one
The Choose the delivery area question selected in the editor, with its title and the gear at the bottom of its card marked
  • Click on the Choose the delivery area question, then click Add price field in the toolbar on the right
The form in the editor, with the Add price field icon marked in the toolbar on the right
  • Select Delivery Fee and click Next
The Add price field list, with Delivery Fee selected and Next marked
  • Select Fixed amount and click Next
The Delivery Fee settings with Insert after Choose the delivery area and Fixed amount selected, marked with Next
  • Click Create. You will replace this amount with the formula in the next step
The Fixed amount box with 1 and the Create button marked

Use FEE function to calculate the shipping costs

FEE function assigns fees for each answer choice in a multiple choice, dropdown or checkbox question. The syntax for the fee function is:
FEE(currency, question, value1, [value2, …])
where
  • currency - The currency symbol to be displayed
  • question - The entry#id of the question. Type @ and select the required question from the list.
  • value1, value2 … valuen - Fees for the first, second … nth answer choice
Let's say there are three delivery zones -- Zone 1, Zone 2, Zone 3 -- and the fees for the three delivery zones are $10, $15 and $12 respectively. The FEE formula for calculating the delivery fees based on the zone selected by the user is: FEE("$",Choose the delivery area, 10, 15, 12)
  • In Field settings, select the Answer tab. Write the formula in the Calculate option as shown below and click Save. Use your own currency symbol in place of $ or the form will mix the two
The Answer tab of the field settings with the FEE function with the delivery area question and the fees 10, 15 and 12 in the Calculate box, with the Answer tab and the box marked

How to add the shipping costs and order amount?

Add a Net Amount price field. It adds the Delivery Fee to the Order Amount by itself. Your customers pay the Net Amount.
  • Click on the Delivery Fee question, then click Add price field. Select Net Amount and click Next
The Add price field list, with Net Amount selected and Next marked
  • Select Standard calculation using NETTOTAL() and click Next
The Net Amount settings with Insert after Delivery Fee and Standard calculation using NETTOTAL() selected, marked with Next
  • Click Create
  • Click Save
The Standard calculation box with NETTOTAL() and the Create button marked
When your customers choose their area, the Delivery Fee and the Net Amount change on the form. Your customers pay the Net Amount.
The Bakery order form with Zone 2 chosen, Order Amount $21.50, Delivery Fee $15.00 and Net Amount $36.50

Summary

A Google Form can ask for a delivery area but can't charge a different fee for each one. With Neartail, the FEE function sets a fee for each zone, and the form adds it to the order amount as soon as the customer picks their area. Import your Google Form and complete the steps above. If you have any questions, write to support.

Set a delivery fee for each zone on your order form.

Import your Google Form, add a question for the delivery area and a Delivery Fee with the FEE function, so the fee changes with the area customers pick.

Last updated: