How to cascade the same grouping of rows multiple times for device management in a form
If I have a row that says "how many devices do you have?" And a user inputs 6 (for example). I would want the form to present the same grouping of three rows (serial number, location, owner), six times. That way each device has a unique place to document these discrete items and they file back to the same column in the smartsheet.
How do I accomplish this?
Answers
-
You can, but the data will not be normalized. You will need a column for each device. Like this:
Your form design will use logic like this:
For 1 device
For 2 devcices:
_________________________________________________
When I say that the data will not be normalized, I mean that normally, a person with three devices will have three records. You can do something like collect the information in this form, and then use cross-sheet references to transform the data.
-
So the above states that no row accumilation can be done. You have to have seperate columns for each device and owner and it would be stretched across columns instead of compacted under one header row with multiple sub rows below.
I had to manualy indent the below rows. Would love to be able to auto indent from form input.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives