Can I pre-populate a form with data from a sheet?

Max Weinstein

I am looking to create a form that will pull in current data tied to an ID from a sheet. I envision having the user enter the ID in the form and certain fields will pre-populate based on the entry. Is this possible, or is there an alternate solution?

Andrée Starå

Hi @Max Weinstein

I hope you're well and safe!

Unfortunately, it's not possible now, but it's an excellent idea!

Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.

Here's a possible workaround or workarounds

• Have it auto populate after submission in the sheet
• Using URL query to have the values prepopulated in the form

Would any of those options 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!

Max Weinstein

thanks @Andrée Starå - can you elaborate on using URL query to have the values prepopulated in the form? How would that process work?

Kaveri Vipat

Hi Max Weinstein, 

I have faced the same issue for one project so we tried this option, You can auto-populate the data into the forms by creating a form link by the following formula. 

After the form link, I used the following to auto-populate the data-  

?&ID%20No=541212&Location=Room1&Location=Room2 

Where, %20 represents the space, ‘&’ is used to join the link with multiple entries to be populated in the form. 

Images are attached for your reference. 

 

Picture2 1.png

Picture1 1.png

 

Andrée Starå

@Max Weinstein

Excellent!

Happy to help!

More info.

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

✅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!