Sheetgo Forms allow you to collect data efficiently by creating customizable forms that feed directly into your spreadsheets. The ability to configure subquestions allows you to gather more detailed information without overwhelming users.

For example, when someone selects an order item as a "drink," it triggers a new set of questions to specify the type of drink ("Coke," "Water," or "Ginger Ale"). This selection can trigger another set of questions about the drink size ("Bottle" or "Can").

To set up this configuration, you will need a spreadsheet with 2 tabs:

Let’s use the restaurant example to show how to use of this feature.

As seen above, our primary question is "Order Item Type," with data validation that includes the values "Drinks," "Sandwich," "Burger," and "Dessert."

This setup creates the initial list of questions in your form. Now let's configure the subquestions in the second parameters tab.

The parameters sheet should list all potential combinations of values for your primary question and its subquestions.

Create columns for your primary question and subquestions: List all potential combinations as new rows. For example, if a user selects "Drinks" from the primary question, list all the different drink options, like "Coke," "Water," and "Ginger Ale." Repeat this process for each value from your primary question.
​
Your sheet should look something like this:

You can continue adding columns for additional subquestions, making it easier to filter this table by item and sub-item.

You can also choose to create a new table for each set of parameters rather than one long table as shown above (e.g., a table for "Drinks" values, a table for "Dessert" values, etc.). However, this will affect how you configure your form questions in the next step.

Now that your parameters are listed in your second tab, return to the main forms tab to apply the configurations for the subquestion behavior. Below is an example of what your main forms tab should look like:

The “Order Item Type” above is the column you created in the first step. This should contain the field title and should be formatted with data validation. You can also add configurations to adjust the way it is presented in the form.

Now it’s time to create the next set of columns for your subquestions. For this, you’ll need to use the following order of configurations:

Once you have carried out the steps above, your form spreadsheet is now ready to use. Using the example above, whenever a user selects an item in the “Order Item Type” field, their specific answers will trigger a new sub-question field where they can continue to select the following answer.

Another powerful feature of the subquestions is the auto-fill function, which allows a new answer to be automatically completed based on the previous one.

To configure this on your form, we need to use the configuration vlookup and two others based on a conditional field, key, and range.

This is used to indicate another field that will provide the value to be searched for. The value of the key configuration will be the same name as this other field. Range, on the other hand, is used to indicate the data. The first column must have the searched value and the following columns must have values related to this one. Here is an example of how the configuration looks on your spreadsheet.

Using the above example, a pre-filled field can be configured to: [default:vlookup, key: "User id", range:"Auto fill parameters!A2:B"], where an existing field called User id will have options ranging from 1 to 6. When this field changes, our pre-filled field will change its default value based on the previous value. Here is a look at this system in action:

Additionally, an index configuration can be added to indicate which column of the range will have the values that will be displayed in the field. This follows a notation of 1 to many.

In the above example, if the range was "Auto fill parameters!A2:C", including the column Color, and values of column Name should be displayed, adding index:2 would achieve this goal. If the index is not indicated, the last column of the given range will be used.

Configuring subquestions in Sheetgo forms is a powerful way to enhance your data collection process. By following these steps, you can set up conditional logic to show subquestions based on respondents' answers, making your forms more dynamic and efficient.