Basic link format to pass values into forms
https://forms.sheetgo.com/{FORM_ID}?{FIELD_NAME}={VALUE}Form URL (https://forms.sheetgo.com/{FORM_ID})
This does not work with shortened URLs copied from the Form Publishing settings (https://sheetgo.io/{ID}).
Query String Initiator (?)
This signals the start of query parameters that pass data into the form.
Field Name ({FIELD_NAME})
This corresponds to the form field where you want to prefill a value. Spaces in field names are represented by plus signs (+).
Equals Sign (=)
Connects the field name to the value you want to prefill.
Field Value ({VALUE})
The value that will be inserted into the {FIELD_NAME} field when the form is opened.
For example, this URL selects “Four” in the “Dropdown” field:
https://forms.sheetgo.com/43B100E9-84dD-3691-B097-b0d16373BB82?Dropdown=Four
Passing several values through the URL
You can extend that basic format by adding more fields and values to the URL. This is achieved by using the query parameter separator (“&”) between each field/value in the form.
https://forms.sheetgo.com/43B100E9-84dD-3691-B097-b0d16373BB82?Dropdown=Four&Radio=Two&Paragraph=Text+goes+here&Scale=5
Why is it beneficial to fill Form values through URLs?
This way of filling out forms takes more work to set up, but it offers two key benefits:
It ensures correct information is always provided for any given field.
It saves time for everybody who fills out the form.
One way to leverage this feature is to prebuild links in a spreadsheet by concatenating the form link with information.
Use cases to pass values automatically into forms
This approach is useful to automate processes where some values could be auto-filled based on data from a spreadsheet.
A few examples include:
For purchase order approvals, you can prefill the ID and the value to make the approval process quicker and more transparent.
To track data from people filling out a form without the need for them to sign in.
To submit Inventory restock requests with the item and SKU preloaded.