This is the Snippets Bakery Order Form and these are the submitted orders. Anyone else hungry? Whilst I was writing this I was pretty disappointed that my orders weren't actually going to result in any cakes being delivered!
The aim of our code is to create something like this confirmation email:
|Automatically generated confirmation email with HTML table of responses|
In the next few posts I will breakdown various bits of the code and explain how some of the more intricate results were achieved. If you're happy to dive right in, you can get all the code here.
Features and explanatory articles!
- Styled HTML Table (formatted with HTML as CSS support in email clients is patchy at best) with responses split in to two sections - part two
- Work around for the lack of date picker in Google Forms - part three
- Difference between two dates calculated - part four
- Total Cost Calculated based on three variables - part five
- Orders with less than 3 days notice until the fulfilment date are automatically rejected with a polite alternative email.