Date Calculations - For Example:
On your Business website you may want to have a Home Rental booking system. Saving time and money processing daily inquiries.
So the Ideal system would be...
Submit Dates (Normal Form Submit as "Get Rates" for the Calculation Spreadsheet PUBLIC)
Submit Form and Payment (Main Booking Form - PRIVATE).
For the moment it will be just - Submit Dates (to Calculation Spreadsheet) - Date Calculations.
Submit 2 Dates for Calculation
Refresh Page and Date Calculations.
(Last Cells of Form Submission)
Refresh Page to Refresh Calculations
(Refresh interval is set for 1 min)
+ Calculation Diagram/Chart (Not visible in the Table Gadget)
Adjust the Google Gadget Properties as you like. (eg. remove sorting, interval etc...)
To get the Last Cell from a Form Submission.
You can place the following functions in a new Sheet ("+" button [bottom-right]) of the forms spreadsheet :
Add the following functions to any cell in sheet2:
Arrival Date (Sheet1 Column C) =index(sheet1!C:C,MAX(IF(sheet1!C:C<>"",ROW(sheet1!C:C))),1)
Departure Date (Sheet1 Column E) =index(Sheet1!E:E,MAX(IF(Sheet1!E:E<>"",ROW(Sheet1!E:E))),1)
You will need to adjust the columns in the functions (column A = A:A etc..).
NEW Google Apps Scripts is now integrated into Google Sites. Google Apps Scripts allows you to access other Google accounts and create entities just by using code through Google spreadsheets.
This will make Google spreadsheets very powerful in developing everyday Business solutions. More Examples and Google Sites Tutorials are Being developed , while some services still remain in Labs/Experimental.There is great potential for power calculators and compute engines. The savings of these normally expensive products in the cloud is massive.
Any Specific Google Apps Scripts Example can be suggested through Google Moderator HERE.
Any submissions using the Form can be added to the calendar. The Best Practice for this type of System would be to authorize and confirm the Booking first, before adding to the Calendar.
For the moment we will add any form submissions data to the calendar using a simple Apps Script.
Extending the 'Date Calculations' System with a Calendar Example using Apps Script
More Apps Script Examples: