Forms
Once someone submits a form, can they go back in and change it if they need to? Maybe they need to edit something or add something that they forgot to.
If it is possible, the new info added or edit where will that populate in the smartsheet? Will it be in the same row?
Answers
-
I have seen dynamic view used previously for moments like this but it wasn't necessarily to go back and edit previously submitted information. Dynamic View was used for a 2 part intake process for project approval (approval for initiate -> Discovery, and then approval from Discovery -> execution). That way the same line is completed for all the project initiation and discovery related content.
Otherwise, you could generate a report that would filter on "current user" for items that the user submitted and allow them to edit that way?
-
So they can submit the form again and that would just generate a new line?
-
Hello @JenaW,
Submitting a new form will always create a new row in a sheet, not update a current row. What Martha is suggesting is to create a report from this sheet and have a filter to only show rows with the "Current User" in a Contact column. To do this, you could have a Submitted By or Assigned contact column with the person that submitted the form entered into that field. Then, your report can be filtered on Current User for that field. If someone that submits a form needs to go in and edit or add info to what they submitted, they could then go to that report and would be able to see and edit only information that they submitted.
If my comment helped you, please help others by marking it as an accepted answer and consider helping me by clicking the 💡Insightful or ❤️Awesome buttons below!
Monique Odom-Stearn
Portfolio Operations Tools Manager
Smartsheet Leader & Community Champion
Pronouns: She/Her (What’s this?)
“Take chances, make mistakes, get messy!” – Ms. Frizzle
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives