Collecting Data from Smartsheet Form

Rick Byers

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?

EvanShortreed

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:

1. Get the Form URL: First, open your Smartsheet and go to the form you created. Copy the form URL.
2. 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.
3. 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, and ITEM_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.

1. 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.

Rick Byers

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?