级联形式

Nick Burrus · 06/17/22

Cascading Form data sets is one of Smartsheet's missing capabilities that I believe would be a game-changer for many alternative providers. Cascading forms are a very effective technique that can be used to compress form data and limit down options in order to narrow a workflow or collect more accurate data.

Recent usage of a Cascading Form is likely. For instance, after selecting your Country, a list of States is displayed. This demonstrates the effectiveness of Cascading Forms.

For Example, if I have a dropdown titledAnimal Typewith the following options:

水
Land
Flying

I would like to be able to include conditional alternatives. If my response is "Water," I would like to be able to load in the following dropdown a series of the following options for a field titledAnimal Species:

Whale
Dolphin
Fish

But, if I choose Land

Dog
Cat
Mouse

Etc. So, when the form is finally submitted, Animal Species is Dolphin for example. Doing this with the current method is very messy, and it is very difficult to manage a cascading data set correctly.

Many alternative services such as DocuSign, ProntoForms, Office 365 Excel Forms, AirTable, etc allow you to point to 1 sheet (CSV, Excel Sheet, or an online spreadsheet) in order to create a cascading table automatically form form data fields that are mapped.

This can accomplish two highly requested features:

Allow dropdown values to be mapped to another sheet's column in order to allow dynamic updates. (This is what ddupdate does, and there are well over 500 posts in this forum alone about it).
Allow advanced cascade features to allow Smartsheet (and hopefully offline forms) to compete in the field.

We've had to turn away lucrative oil companies, etc from Smartsheet, simply because Cascading data on large amounts of forms was difficult to effectively manage.

Cleversheet · 10/17/22

@Nick Burrus, I assume you’ve already tried parsing your columns such that, for example, you have a [Land Animal] column with Dog/Cat/Mouse, so that when the form user selects Land as the [Animal Type] then form logic will present them the [Land Animal] dropdown—and accordingly not the [Water Animal] or [Flying Animal] dropdowns.

Nick Burrus · 10/17/22

@Nick Burrus<\/a>, I assume you’ve already tried parsing your columns such that, for example, you have a [Land Animal] column with Dog\/Cat\/Mouse, so that when the form user selects Land as the [Animal Type] then form logic will present them the [Land Animal] dropdown—and accordingly not the [Water Animal] or [Flying Animal] dropdowns.<\/p>","bodyRaw":"[{\"insert\":{\"mention\":{\"name\":\"Nick Burrus\",\"userID\":65666}}},{\"insert\":\", I assume you’ve already tried parsing your columns such that, for example, you have a [Land Animal] column with Dog\\\/Cat\\\/Mouse, so that when the form user selects Land as the [Animal Type] then form logic will present them the [Land Animal] dropdown—and accordingly not the [Water Animal] or [Flying Animal] dropdowns. \\n\"}]","format":"rich","dateInserted":"2022-10-17T13:09:20+00:00","insertUser":{"userID":105651,"name":"Cleversheet","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Cleversheet","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-09\/9d\/3c\/n9d3cda2a97cae4b01fcea6153d986565.jpg","dateLastActive":"2023-06-24T21:35:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/347407#Comment_347407","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/347407#Comment_347407

Yep. The issue is , this gets dirty fast for large data sets. :(. We use Enterprise level addons, etc, now for this client and they're paying upwards to almost $100 grand a year for Smartsheet for a few users. They have ended their interest in Smartsheet to go to a competitor that supports cascades natively. Our other clients are still on SS. Just cascades are a "will be really nice" feature for a lot of things. We're currently building out a proof of concept for an energy company that wants over 164 variations of cascades.

Nick Burrus · 10/21/22

We just lost a health services client moving to Smartsheet over the lack of cascades for a massive survey they want to do. We did find a solution with zoho forms/analytics if anyone is looking for that.

Definately do want to be able t obring them home to Smartsheet one day!

Sign in to submit new ideas and vote

级联形式

Idea Submitted·最后一次更新06/17/22

Comments

Categories