In Progress

Online Application based on Google Service

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 [url removed, login to view]\_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: CSS, PHP, Software Architecture, Software Testing, Web Hosting, Website Management, Website Testing

See more: Date enter, use script in google spreadsheet, tables in data structure, table data structure, spreadsheet script google, service spreadsheet, service first, service database access, server side application, script google spreadsheet, sample google apps, pop google apps, online account manager, max flow, https developers, google php server for developers, google apps spreadsheet, google apps script spreadsheet, google apps script developers, google apps script create new spreadsheet, google apps pop, google apps javascript, google apps email, get a manager online, flow max

About the Employer:
( 16 reviews ) Taipei, Taiwan

Project ID: #2675980