Prepopulate Form for Update Request

Martin Cocson

We use forms to get information from our colleagues and we would want to send them a form prepopulated by their inputs so they can update the information if there are any changes.

This would be very useful if we can automate the process and make the items mandatory

Andrée Starå

Hi @Martin Cocson

I hope you're well and safe!

You can use the URL-Query feature to pre-populate a form.

Do they need to be able to update previous information or only add to fields they haven't filled out yet?

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

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, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Martin Cocson

Hi Andree,

They also need to update previous information and add info not yet included. I tried using this URL-query and send them a pre-populated form. However, it comes out as another entry. Is there a workaround for this duplication?

Andrée Starå

@Martin Cocson

No, if they need to be able to update previous information, too, then you'd have to use the Update Request feature.

Other options could be a Report (need access to the sheet), Premium Apps, Dynamic View, or WorkApps.

Would any of those options work/help?

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

Joseph Shiyanbola

@Andrée Starå

Is there any other alternative?