Configuring Google Sheets

Various forms, e-mails, and their components are explained here:

• User form:

  • Item

  • Unit price

  • Quantity

  • Total price (calculated)

  • Delivery address

  • Phone

  • E-mail

  • Payment details

  Note

  Upon the order submission, the script sends confirmation e-mails to both the User and Accounts section.

• Confirmation e-mail to the user:

  • Order number

  • Item

  • Unit price

  • Quantity

  • Total price

  • Delivery address

  • Phone number

  • Payment details

• E-mail to the Accounts section:

  It is same as the user confirmation e-mail; however, an additional link to the dispatch form is included.

  Note

  On receiving order e-mails, the Accounts section verifies if the payment details are okay, and then forwards that e-mail to the Order Processing section. The Order Processing/Dispatch section clicks on the link to open the dispatch form, fills in shipment details, and submits the form.

• The dispatch form:

  • Order number

  • Item

  • Quantity

  • Delivery address

  • Shipment details

  Note

  On the dispatch form submission, the script updates shipment details in the spreadsheet...