Learning Google Apps Script

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 ...