SmartSheet Forms - Populate with web data at submission

Svendahle · 08/04/15

SmartSheet API's make it easy to interact with data coming OUT OF SmartSheet. Is it possible to capture web data (in particular from a URL) to prepopulate certain values?

Use case:

Survey - user is logged in and is responding to a survey based on an item they are viewing.

Need to capture user details (User ID, First Name, Last Name, email address from profile, etc). and details related to the item they are viewing (Rhinestone boots).

in this scenario all other data would then be form entered.

The URL would be specific to Item and User. SmartSheet would need to interact with db to pull User and Item data then populate the values based on that.

Possible?

Thanks.

Brett Evans · 08/04/15

This is the hack for Google Forms.

http://justingale.com/2013/09/url-tricks-for-google-forms-pre-populate-and-automatically-submitting-responses/

You could try to adapt this for your SS Form. You would have to have the webpage/script build the URL and input the user info into the form.

Good luck.

SashaR · 08/04/15

All the details you would capture is outside of Smartsheet, so you wouldnt use their API to get that information (you would get it from your db).

Once you get that data from your db, you can contruct a link with query strongs and send the user to the URL (just as Brett suggested). Here is the help center article on web forms, scroll down to Submitting the Form Manually & via Query Strings: http://help.smartsheet.com/customer/portal/articles/522221-using-web-forms

Welcome to the Smartsheet Forum Archives

SmartSheet Forms - Populate with web data at submission

Comments

Categories