New form entries overwrite existing row

vvk

Hi,

I'm using a form in order to collect scores from various people, for the same project. Ideally, each new form entry should appear as a new row in my sheet - but instead, what Smartsheet does when someone adds scores (through the email update request form) is overwrite the previously existing scores in the same row in the sheet (instead of creating a new row with the respective person's scores).

Is there a solution to this?

Andrée Starå

Hi @vvk,

I hope you're well and safe!

Yes, but you'd need to use the Form option instead.

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

@vvk

You could also combine it with the URL query feature.

More info:

https://help.smartsheet.com/articles/2478871-url-query-string-form-default-values

vvk

The Form option worked fine, many thanks for the quick reply @Andrée Starå !

Andrée Starå

@vvk

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

murphyspccms

Hi @Andrée Starå, vvk, how do you use forms to replace an existing row? I haven't had luck finding anything online with an explanation.

murphyspccms

https://community.smartsheet.com/discussion/comment/385062#Comment_385062

@Andrée Starå Following up on this, if possible?

@Paul Newcome See above, maybe you can help? I can't find the answer searching the community. Thank you all!

Paul Newcome

@murphyspccms You cannot use a form to replace an existing row directly. You would have some kind of unique identifier on a row that is also entered in the form and then use formulas with cross sheet references to pull over the most recent updates.

murphyspccms

ok, got it. Thanks for the quick response, @Paul Newcome !