Success!

Note

Error

Session expiration Your session is going to expireClick here to extend

Budget:

Small project <800

Posted on

5/7/13 3:54 AM

Buyer:

Mon***

This project has expired

Why don't you register anyway? We are sure that you will find many similar projects out of the thousands waiting for you!

Post similar project now

Description

Admin Note: Dear client, we have send you an email in regards to the project budget. Thank you. *********************************************************************

We have a PHP 5+ registration module with variable fields which collects submissions from users for a series of different one-day events over the course of several months.  The submissions are stored in MySQL, by registrant and corresponding event.  The submissions data is to be displayed in Google Drive Spreadsheets by event per month such that there will be several worksheets, each with submissions for an event, per spreadsheet which will be for each month.  The data is confidential and will be displayed in the spreadsheets during the registration period, which varies from event to event.  Clients with access to the related Google Drive will be able to view the spreadsheets during the registration period but not edit the data.  However, "administrators" will be able to edit the developing data of the spreadsheets.  Once the registration period is finished, the Client will also be able to edit the spreadsheets.  

The following capabilities are required...

1) A Google Apps Script to periodically receive data as it updates on the website's server and then display it in corresponding spreadsheets/worksheets.   

2) A Google Apps Script to update data on the website's server when changes are made in the worksheets.  

3) A PHP 5+ class that will create necessary spreadsheets, create related worksheets in specific spreadsheets, feed developing submissions data from the website's database to the Google spreadsheets and update submissions data in the website's database as received from updated Google spreadsheets.  

The PHP class may have no other dependencies.  It may use CURL.  The Google Drive Account and website database must be variables that can be set for different accounts and different websites.  Auth 2 must be used so that the data can remain secure during the entire process.