Online Application based on Google Service

Avg Bid (USD)
Project Budget (USD)
$100 - $150

Project Description:
Use only Google services and Javascript (Google Apps script and browser) to achieve an online Application. Everything is hosted on Google (static page and server side code). database of this system: 1) Personal details : new record for first time applicant. one user per row. 2) Available Activity : maintained by by manager. one activity per row. 3) Activity's Applicant : one application per row. create an Google account and implement the feature. The owner of this account is the manager, all other Google user can be applicant.

## Deliverables

Data structure, 3 tables in same spreadsheet : 1) user personal info db. email, address, telephone number. 2) activity db, name of activity, date, max\_applicant, applicant\_so\_far, final\_apply\_date. 3) activity\_applicant: email of applicant, fill\_form\_date, approved by , approved date . each activity has own table. Main flow: 1) Applicant logged-in with Google account. 2) for first time applicant, pop up permission window to allow our script to access Google account. 3) once the user approve the script, for first time applicant , go to Personal Detail Form. after fill up, go to Activity Selection Form. go to Activity Selection Form directly for old applicant. 4) on Activity Selection Form, display only the active activity (final\_apply\_date less than today ) . if activity is full, (applicant\_so\_far more than max\_applicant) , warning message is shown . 5) when user choose an activity and click apply, manager will get noticed via email. new table will be created for the first application of a activity. 6) show user message: thanks for applying, please wait for approval. 7) an email with another Google form link will be sent to the manager, the manager approvals or rejects by click a button on the form. see\_report\_approval for sample code. 8) applicant get noticed via email and SMS(optional) . subflow: cancellation of an application. 1) user logged-in with Google account. 2) enter "the activity i am attending" page. 3) click cancel. 4) manager get noticed, applicant\_so_far minus 1.

Skills required:
CSS, PHP, Software Architecture, Software Testing, Web Hosting, Website Management, Website Testing
About the employer:
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.