I want to have the form be used to create a row with child rows underneath it, so I don't have to keep doing this manually
Sign in to see the current vote count, add your own vote, or leave a comment.
I could use that functionality as well
Just jumping in here to let you know that @Paul Newcome posted an explanation of one way you could do this using formulas and workflows:
Cheers,
Genevieve
This would be really helpful in my situation too!
Would this work for child rows that aren't always 2 and can vary in numbers and parent rows aren't always in the same row?
Love this idea! Currently, every new row added to a sheet by a form has to be manually indented as a child row. It would be fabulous to be able to add the row automatically as a child to whatever parent row is closest to the bottom of the form (or top, if that's how your rows are added!).
This is a great request that I can definitely put to good use!
Holy cow, I am SO HAPPY to hear this is on the roadmap!!!
This opens the door for so many applications.
It would be nice if certain values were entered in on a form, that a children row would be populated automatically with its submission. We have multiple products at sites that may need attention. I would like each product listed underneath the parent row, automatically. Instead, I have to have a column for each submission value which isn't easy to manage.
+1 for me on this feature!
I've built a work-tracking system that requires users to enter standard course projects that can be a single 'segment' or have multiple segments. Adding a single-segment course is easily done via a form. However, adding a multi-segment course requires giving users edit access to the sheet & training them to enter data only in a few columns. (Other users regularly need to update other columns so locking or hiding isn't a viable option.)
I want the ability to have the form ask 'what's the name of your course' and 'how many segments', then create rows in the sheet with parent/child relationships like this: COURSE NAME — SEGMENT 1 — SEGMENT 2 — SEGMENT 3
I would like to have the ability add a child row to a specific parent row in a form. Like maybe selecting the parent from a dropdown. Most of the time this will be after the parent has initially been created.
Use Case: We onboard new accounts that have main Group Code for the entity and Subgroup Codes for the locations that entity has. If we could send a form that allowed them to add details for each location as child rows under the entity, that would be extremely useful. To take it a step further, sometimes these locations might have multiple addresses - like a billing address and delivery address. If the form could allow the end user to select that the location has x number of addresses and add another level of child rows for each address it would be even better.
Use case - we are managing tours of a showroom, and there are different requirements for different types of tours. For example, if the user indicates that refreshments are needed - I want a child task for the refreshment information to be added to the sheet. If they indicate that a video presentation is required - I want a child task for that. But if they do not require these things, the child task is not added. (these are just a couple of the requirements that might be needed)
Use Case: We set up job #s to encompass an entire marketing campaign, and the components within the campaign each have a sub-job # that we manually create to tie them all up into the one job #. If we could have the respective components that were submitted on the form as an automatic child row, would eliminate hours of manual work with the job #s and adding all of the respective child rows.
The "browse" button was recently changed to go through a recent workspaces menu and requiring a second click on "browse all" before actually bringing up the browse menu sidebar. This change is unintuitive as there is a "recents" button right below the browse button and for anyone who regularly uses more than 6 workspaces…
I need to be able to backup all workspaces at once. Backing up each workspace one by one is tedious and a waste of time. I know someone is going to tell me "even system admins cannot backup workspaces they are not shared to, and can only backup workspaces they own or are shared with." So, let me do that. At least let me…
I had Technical Support Case #09045069 in relation to this issue. I was told to get the API documents corrected, I needed to post to here. Update API Documentation Some (all?) of the API calls related to Alternate Email Addresses require both an Enterprise Account and to be manually activated by Smartsheet Support. The API…
