Collecting Data from Smartsheet Form
I am trying to collect data using a Smartsheet Form. More specifically, I am trying to send the Form to verify that an item has been discontinued with a supplier. I have a column titled ITEM NUMBER, in Smartsheet and will manually add the Item Number, can this number auto populate into the form so my supplier doesn't have to add in the form submission?
Answers
-
Yes, you can pre-populate fields in a Smartsheet form by using URL parameters. This way, you can send a form link to your supplier with the ITEM NUMBER field already filled out. Here’s how you can do it:
- Get the Form URL: First, open your Smartsheet and go to the form you created. Copy the form URL.
- Identify the Field ID: You need to find the unique ID of the ITEM NUMBER field. To do this:
- Open the form in edit mode.
- Click on the ITEM NUMBER field.
- Look at the URL in your browser's address bar. You should see a parameter like
?field_id=xxxxx
. Note down the field ID.
- https://app.smartsheet.com/b/form/FORM_ID?field_id_XXXXX=ITEM_NUMBERReplace
FORM_ID
with your form’s ID,field_id_XXXXX
with the actual field ID of the ITEM NUMBER, andITEM_NUMBER
with the actual item number you want to pre-fill.
Here’s an example:
https://app.smartsheet.com/b/form/1234567890abcd?field_id_12345=98765
In this example:
1234567890abcd
is the form ID.field_id_12345
is the field ID for the ITEM NUMBER.98765
is the item number you want to pre-populate.
- Send the Pre-Populated URL: Send this customized URL to your supplier. When they click the link, the ITEM NUMBER field will be pre-filled with the value you specified.
-
Hi Evan,
In the Form Edit mode, I am having trouble getting the Field ID. As you can see below, I am clicking on the "Domtar Item #" field, but the URL doesn't change from one field to the next, nor do I see anything like "?field_id=xxxxx". All I see is a number, with "?view=grid", same number for each field I click.
Am I missing something in this process?
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 458 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives