Filling form fields from the link

The link to your web form can contain default values for form fields, or values set by a script. This help page describes how you use this feature.

You can provide a default value for many types of all named form fields in the link to the form. This allows you to enter values into the form fields from the surrounding environment, e.g. a script that fetches values from a database. Hidden or locked fields can be used to ensure that the user doesn’t change the preset value.

Passing field values in the link or “URL” is technically called a query string. Please note the special technical requirements for query strings and the characters they may contain.

Here are a few examples of links with a query string to set a form field:

  • Text field: /form.htm?lang=sv
  • Check box: /form.htm?example=TRUE
  • Radio button: /form.htm?example=Female
  • Ratings: /form.htm?example=4
  • Slider: /form.htm?example=42
  • Calendar: /form.htm?date=20376 (date as Excel serial number)

Note that the form field autosave process normally saves the latest known value for all input fields. The autosaved values from the previous form will override any default values in the link. If you want the values in the link to override the autosaved values, you have to disable Browser Storage on the Workbook tab.