Pass URL parameters from web ad campaign into Form hidden values

I am running an advertising campaign to get registrations on my Form. When the users click on the advertisement (either ad A or ad , they go to a landing page with a URL ending in -----.com/?campaign=launch&utm_source=ad_a , and the form is on that landing page. Parameters are key-value pairs that can appear inside URL path

But when I look at the responses to the Smartsheet form, I want to know which advertisement (A vs. that each particular user clicked on to arrive at the website where they filled out my form.

How can I get the web parameters (key-value pairs in the URL) to auto-populate the Form (as Hidden Fields)?

<form action="https://app.smartsheet.com/b/form" method="GET" >

<input type="hidden" name="EQBCT" value="fbab5300a6d74cc58ae6326e267b3c4f" />

<input type="hidden" name="utm_campaign" value="launch">

<input type="hidden" name="utm_source" value="ad_a">

<input type="text" name="Customer Name" value="">

</form>

I see there are a few related threads in the Community, but no one quite answers this...

Thanks!

Find more posts tagged with

Forms

Sheets

Integrations

Marketing

Comments

Shaine Greenwood

Hi ems,

You'll want to append query strings to your Smartsheet form URL into hidden form fields. More info on query strings (and hidden form fields) can be found in the help article on creating forms: https://help.smartsheet.com/articles/522221-using-web-forms#query

benhamilton1

Shaine, that link does not supply any assistance in a URL passthrough that pulls the full URL of the page the form is imbedded into.

We use Smartsheet for lead tracking and I would very much like to use a UTM to attribute leads.

If the Smartsheet forms don't support this I can find a workaround I'm certain.

Does Smartsheet allow for an email triggered row creation? Because I could implement a 3rd party form tool to get around this functional deficit.

Genevieve P.

Hi @benhamilton1

You're correct, the query strings that Shaine is referencing can populate data into the form automatically, but it won't identify the origin of where the user located the form unless you had this set up in your sheet.

To do so, you would want to create a hidden field in the form that you could then fill in using a query string. Then embed a unique form URL to each of your separate pages with a different query string per-page.

Ex.I would use this form URL in Community:

https://app.smartsheet.com/b/form/xxx?Origin=community

And this other form URL in the Help site:

https://app.smartsheet.com/b/form/xxx?Origin=HelpCenter

This would map to a column called Origin in my sheet so I could tell which form link the user clicked.

Cheers,

Genevieve

Sign in to join the conversation!

Quick Links

Trending discussions

Anyone getting JIRA API errors using the connector?
We are using the Jira/Smartsheets connector and got this error: Invalid response from JIRA. statusCode: 410, reasonPhrase: Gone The requested API has been removed. Please migrate to the /rest/api/3/search/jql API. A full migration guideline is available at Looks like the connector needs to be updated. Anyone know anything…
Dirty save - #BLOCKED/Invalid Value issue when using integration until manually save the sheet
Hello everyone, We’re facing a critical issue in one of our Reports. We use integration and it adds values to the sheets. The corrected values don't seem to auto-save. Formulas in sheets first show #BLOCKED/Invalid Value, then if we refresh the sheet - it updates to the correct numbers. The save button is active even…
Smartsheet for Google Drive doesn't seem to be available anymore
Trying to access Smartsheet for Google Drive and it seems it's not available anymore: https://workspace.google.com/marketplace/app/app/46145466229 Also the app is not listed when searching on Google Marketplace.