Pass URL parameters from web ad campaign into Form hidden values

ems
ems
edited 06/14/22 in Add Ons and Integrations

I am running an advertising campaign to get registrations on my Form. When the users click on the advertisement (either ad A or ad B), 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. B) 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!

 

Comments

  • 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

  • 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.
    Genevieve P. Employee Admin

    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