Forms

JenaW
JenaW ✭✭
edited 09/22/23 in Smartsheet Basics

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

  • Martha Hemingway
    Martha Hemingway ✭✭✭✭✭

    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?

  • JenaW
    JenaW ✭✭

    So they can submit the form again and that would just generate a new line?

  • Monique Odom-Stearn
    Monique Odom-Stearn ✭✭✭✭✭✭

    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