Have Questions? (800) 477-0970

Ask Tech Support: ‘Other’ Row in a Table

Posted by Filed in: How-to articles, SurveyGizmo News

It’s infamous, and it’s back; the Ask Tech Support series continues to address the ‘collective consciousness’ of users by addressing common tricks and tips when using SurveyGizmo.

When asking the same question of multiple items, such as rating your satisfaction with different products from a company, it makes sense to use a table or matrix. Each of the selectable options (ratings) would be set as the columns in the table, while the rows would be defined as the different products.

That was an eyeful! A visual aid would be useful… oh look, here’s one now:
Table with other row

While there may be a core number of products you wish to always get information on, if your respondents wish to rant or rave about a specific product that is not part of the core survey target, you want to give them the opportunity to not only supply the name of the product, but also to rate that product just like they did for all the ones above. The cleanest way to do this within SurveyGizmo is to split the single table question into two parts: A checkbox question on the previous page, and then a table with question piping on the following page.

The logic is to split the question into two parts: identify which products they use, and then rate those products. This accomplishes a few goals:

  • Reduces the number of products the respondent needs to rate to only those they use
  • Provides a count of the most heavily used products in a quick glance during reporting
  • Directly associates their rating with the ‘other’ suggestion

Using the above table as an example, the first question could be a simple checkbox question with 3 other boxes. Also, this question should be required so the survey respondent must respond with at least one check and have to rate at least a single product. It would look similar to the following:
Checkbox source for piping

The second step is to rate the products they have selected as products they have used previously. You will alter the original table by removing the row headers completely and removing the ‘Not Applicable’ column as it is no longer relevant. Finally, set the table to Pipe Questions From the checkbox source question.
Table piped rows and cols
Table Pipe Questions From

What are the results? The new table will now contain only the items checked in the source checkbox question as the row headers on the left side of the table! To see this in action, check out the sample table piping survey.
Piped table - final results

If you have any questions or curiosities, head on over to our community forums!

Tags: , , ,
Share This:

Have you tried SurveyGizmo yet? Try our 14 day free trial

About the Author

Mario Lurig
Technical Training Manager at SurveyGizmo. Mario hails from Reunion, France off the coast of Madagascar in the middle of the Indian Ocean… no, really… then Kenya, United Arab Emirates, and Florida till 2004. He is an author of two books: an ebook of conversation starters and a PHP book. He is also an avid cyclist and tennis player, and is 1-0 in knife fights. His most recent project benefits authors tracking amazon sales rank.

Start your free 14 day trial

Get all features for $50/month. Add users for $20/month each.

Questions? Call us anytime during your trial at (800) 477-0970.

No credit card required.

  • Call us at (800) 477-0970
    for help setting up larger teams.

* Extra users are free for the duration of your trial.
You can change the number before upgrading to a paid plan.

The Survey Expert Blog

By

Why Survey Design Matters for Feedback Surveys

February 3 2012 -

Survey Expert Ryan Farmer observes that many well-known companies aren’t branding their surveys, and discusses why survey design is hyper-important when you want to gather customer feedback.

By

New Team Management & User Permissions System

Starting February 2nd, SurveyGizmo is launching a new set of user management features. Learn more about them here!

By

5 Questions with SurveyGizmo co-founder and CEO Christian Vanek

Boulder’s Daily Camera newspaper interviews Christian Vanek, who shares what’s next for the company.

More from our Survey Experts