Working with forms

Submit information to a sheet

The Form Button opens a separate page where users can submit information to your Google sheet. Glide can also submit data about that user, such as the user's email address and the date/time of submission.

Below you can see that after the user submits a form, Glide automatically populates that user's email and the date/time of the submission.

Video tutorial

Setting up a form

Adding the form button

Add the Form Button to any details page like you would with any other component. To access and customize the form itself, click on the Form Button and you'll be taken to the forms page with its own list of components and values. Glide will automatically add components based on the data in your sheet.

Collecting submissions

At the top of the components panel on the right, there is a box which allows us to select the sheet that the form will write data to.

If we keep the same sheet that our list items are in, then any form submissions will get populated on that sheet.

If you don't want that to happen then create a separate sheet for form submissions and then select that sheet instead.

Configuring forms

Types of data

Forms can submit three types of data.

  1. Data the user enters (EDIT COMPONENTS)

  2. Data about the submission (SPECIAL VALUES)

  3. Data from the parent item (COLUMNS)

Adding special values

In the example below, we take out the Text Field edit components and add the User's email address and Current date/time special values and make sure they are bound to the correct columns in our sheet.

Glide will only have access to the user's email if you have set your app's sign in to be Public with Email or Email Whitelist. Otherwise, it will just stay empty. It won't prompt the user to sign in.

Adding column values

In the example below, a user clicks on an item (Dog) and submits information about it, but in our sheet, it's not clear which item the user was referring to. We could add a field for them to fill out saying which item they are referring to, but it's a bit annoying for them.

Instead, we can get Glide to populate this data for them. In the columns section we have access to the columns from our main list item which has three properties:

  1. Name

  2. Image

  3. Price

If we add a column for the Name column in our Things sheet and then bind that to the Item column in our Form Submissions sheet, then Glide will add 'Dog' to the submitted row on behalf of the user.