I have a truck brokerage business.
When a customer sends us an order for pickup, we create a google docs spreadsheet. This spreadsheet has data that needs dropdown boxes that pulls from other Google docs spread sheets. For instance Location, Destination, Carrier names and rates.
Once that main spreadsheet is populated then a conifirmation using the data above should be created and emailed through google to the carrier who esigns the doc.