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

DocuSign integration suddenly not working with contacts that display the name instead of email.
I've had a DocuSign integration working for a while now. Today, I go to use it and it doesn't work because it sees invalided characters. Upon researching, I have discovered that if the contact field displays the person's email instead of their name the integration works. So it's like DocuSign used to be able to use the…
Checking provisional members on Smartsheet for USM model
Hi smartsheet community! I wanted to check if there is any way by which we can check who all are provisional members in our existing user list. Kindly note that we have not ye to move to User Subscription Model. Thank you for your response!
Pivot App doesn't allow date columns?
I have a source sheet that has the following columns: Project Code , Milestone and Milestone Date . I want to use the Pivot app so that it gives me a row for each project code, columns of Milestones and the corresponding dates for those milestones. Am I correct in understanding that the Pivot app cannot output dates? I…