Use the Toolbox buttons in the interface to build your form structure.
+ Short / + Long: Use these for names, emails, or messages.
+ Single / + Multi: Use these for multiple-choice questions. You can switch between Text Mode (simple list) and Image Mode (visual options) in the settings.
+ File: Adds a file upload button. You must fill in the blank space with a Google Drive Folder ID.
[? IF] / [/ IF]: Use these to create conditional logic. Wrap questions between these blocks. If the user answers the "Watched" question with the "Trigger" value, the wrapped questions will appear.
Info: Add information or terms and condition.
Image: Add cover image.
Gate: Adds a mandatory checkbox.
- Page Break -: Splits your form into multiple steps/pages.
Phase 2: Connecting to Google
Go to Google Sheets and create a new spreadsheet.
In the first row (Row 1), add your headers. These must match the data you plan to collect. You can get the header data (Sheet Keywords) from this website.
Click Extensions - Apps Script.
Clear everything from Code.gs and paste the new code generated by this website (Google Apps Script).
Click Deploy - New Deployment.
Select Web app as the deployment type.
Set Execute as to Me.
Set Who has access to Anyone.
Click Deploy and authorize the permissions. (Don’t be alarmed by Google’s warning; this is normal when deploying code.)
Copy the Google Web App URL.
After getting the URL, paste it back into this website and copy the generated form code.
Phase 3: Generating Data
After getting the code, you can either host it on any website or simply save it as an HTML file and open it in a browser. Alternatively, you don’t need the code at all, you can use this website’s View Form page for direct entry. You can enter your data using any of these methods, and it will be saved directly to a Google Sheet.