SmartSheet Forms - Populate with web data at submission

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.

Find more posts tagged with

API and Developers

Comments

Brett Evans

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

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