Upload Google Form Responses to Another View
Larn how to build file upload forms for Google Drive and receive large files from anyone. The form respondent does not take to be signed in to their Google accounts
With File Upload Forms (form demo) for Google Sheets, you tin receive large files of any size from anyone directly in your Google Drive. Yous can automatically send email confirmations to notify the form submitter. The forms can exist created inside Google Sheets using the congenital-in elevate-north-drop form builder and the forms can have CAPTCHAs, collect e-signatures, multiple file uploads, countersign protection and more than.
Dissimilar the file uploads feature in Google Forms, the class respondents do not require a Google business relationship to uploads files through your form.
Receive Files from Anyone in Google Drive
A school teacher may want to build forms for students to upload assignments and the files are automatically saved to her Google Drive only in separate educatee folders. The Hour team may want an online form where job applicants tin can upload their resumes in PDF or Word format. Business concern tin build forms with eSignatures that respondents tin sign on their desktops and mobile phones.
Google Forms do allow file uploads merely the respondents need to be signed into their Google accounts before they can upload files. File Upload Forms impose no such limitations - anyone can upload files to your Google Bulldoze. They may not have a Google account and they'll even so be able to employ your Drive upload forms.
File Upload Forms - Getting Started
Here's a pace-by-stride guide on how yous can build your ain File Upload Forms in a few minutes. Or watch the YouTube video to go started.
Step 1. Copy the Google Sheet for File Upload Forms
The File Upload Form is written in Google Scripts and the code needs to be fastened to your Google Canvas for information technology to piece of work.
To go started, go to forms.studio/copy and click the "Copy" push button to create a re-create of the Google Sheet template to your Google Drive. This sheet includes the grade builder, email designer and it will as well be storing your form responses just similar Google Forms responses are stored inside Google Sheets.
Step ii. Deploy the form as Web App
Within your Google Spreadsheet, become to `Tools -> Script Editor to open the Google Script editor. Don't worry, you don't take to write a single line of code, y'all only have to deploy this script as a spider web app so anyone tin can access your form via a simple spider web URL.
Go to Publish -> Deploy as Web App, choose Me nether Execute the app as, choose Anyone, fifty-fifty Bearding under Who has access to the web app and click the Deploy push button.
You lot may have to authorize the script in one case since it has to practise all the operations - similar sending emails, uploading files - on your behalf.
Also, if you become the "App Not Verified" screen, just click on the Avant-garde link and choose "Get to File Upload Forms" to continue. While this pace is optional, you tin submit your app to Google for verification and they'll driblet the 'non verified' warning.
Stride 3. Pattern the File Upload Form
Switch to the Google Sheet, expand the File Upload Forms menu (near Help) and choose Edit Form. Information technology will launch a simple just powerful drag-n-drib form architect right within your Google Sheets.
Your forms can accept multiple file upload fields, eSignatures, engagement, time picker, and all the standard form fields. Use the Rich HTML field to embed YouTube videos, Google Maps, SoundCloud MP3s, Google Slide presentations, Images or any HTML content.
You lot tin can also add together data validation rules to various course fields using simple regular expressions. The file upload fields tin can be configured to accept single or multiple files. You tin too limit uploads to specific file extensions like images, videos, nada, and more.
Step 4. Customize the Form's Settings
After your form is designed, go dorsum to the File Upload Forms menu and choose Configure Form. It will open a sidebar in your Google Sheet where you can customize the grade and Google Drive settings.
The confirmation bulletin can include place-markers - form fields enclosed inside double curly braces like {{name}} - for personalized messages. You lot can also identify a URL inside the Redirect After Submit field and respondents would be redirected to that website afterward submitting the form.
In the advanced settings section, click the Select Folder button to choose the parent folder in your Google Drive where all the files would be saved. Yous can also specify a sub-folder path for storing files and this path tin can be dynamic - \\{{Country}}\\{{City}} - based on form answers.
You can as well change color schemes, runway visits to your form with Google Analytics and protect your forms with Google CAPTCHA and passwords.
Step 5. Ship Confirmation Emails
With File Upload Forms, you tin send email notifications when people submit the class. The emails can exist personalized by including the form fields in the electronic mail subject and message body.
Apply the special {{All Answers}} place mark in the message torso to include a summary of the form response in a keen tabular array. The TO, CC or BCC field can include the {{question title}} where yous ask for the email address and it volition be replaced with the actual value in the form response.
That's it.
Your course is now ready for the globe. Expand the Share section and you'll exist given the URL to direct access the class and as well the embed code for adding that form to any website.
You can use Gmail Mail Merge to send the form link to all your contacts in a personalized email. The Certificate Studio add together-on tin can help you create beautiful, pixel-perfect PDFs from the form response and they are motorcar-saved in Google Bulldoze.
Things to Know - File Upload Forms
- To stop accepting new responses, go to Publish -> Deploy every bit spider web app menu and click the Disable link.
- If yous wish to restrict the forms to users inside your organization, choose your Google Workspace domain nether Who has access to the app in place of Bearding.
File Upload Forms - Compare Plans
Delight visit the product page to compare features of the Enterprise and Standard editions. File Upload Forms for Google Drive require a license for extended use.
Source: https://www.labnol.org/internet/file-upload-google-forms/29170/
0 Response to "Upload Google Form Responses to Another View"
Post a Comment