Are you looking for a way to create a form that allows you to upload files to your drive?
Would you like your files to be organised to your liking?
Would you like anyone, even anonymous people, to be able to fill in your form?
If that's what you're looking for then this project is for you!
You need to have a Google account and create a new Google App Script project in your drive.
You need to create a new folder where the files uploaded by users will be stored and you also need to create a SpreadSheet.
After deploying the project you can access the form using the url.
In the form you can fill in some fields such as first name, last name, email and upload a file.
After filling in all the fields you can submit the form which, after obtaining confirmation from the Google server that the form has been successfully uploaded, will redirect you to the Greetings page.
Behind the scenes the results of the form will be saved in a SpreadSheet while the uploaded file will be saved in a folder within the drive.
The files will be organised within it according to the year and the email address.
Once the data has been saved, an email will be sent to confirm receipt of the form.
No special knowledge is needed. Mainly you need to know HTML, CSS, JavaScript.
Listed below are sites that may be useful for you to modify the design to your liking:
- https://www.w3schools.com/html/
- https://www.w3schools.com/css/
- https://www.w3schools.com/js/
- https://developers.google.com/apps-script
Before deploying, you must enter the values for these variables in Code.gs.
| Values | Descriptions |
|---|---|
| URL_SCRIPT | Represents the url that is assigned by Google after deployment. |
| LOGO_MAIN_PAGE | Your main logo ID stored in your Drive |
| LOGO_GREETINGS_PAGE | This is the logo ID stored in your Drive that appears when the form is submitted successfully |
| URL_PERSONAL_PAGE | If you have a personal page, fill in the value with your URL |
| SHEET_URL | This is the URL of the SpreadSheet which is located in your Drive and will collect the results of the form. |
| DRIVE_FOLDER_ID | This is the folder where the uploaded files will be stored |
| EVENT_DATE | Enter the date of the event you are organising |
Create a new folder in your Drive where the uploaded file will be stored.
Create a new SpreadSheet file like the SpreadSheet file uploaded to my repository.