UTM Parameter übergeben und in Datenbank speichern (mit embedded form code)

  • Profile Image
    jeankendall
    Asked on May 22, 2021 at 03:04 AM

    Hallo!

    Ich habe ein Jot-Formular über script in meine Domain eingebettet.

    Nun möchte ich UTM Parameter übergeben, die genauso wie alle andere Werte im Formular in der Datenbank gespeichert werden.

    Beispiel:

    Die URL lautet: domain.com/jotform?source1=4711&source2=4812

    Die Felder/Werte im Formular lauten NAME und EMAIL.

    Wenn nun jemand dieses Formular mit NAME und EMAIL ausfüllt, können dann auch die UTM Parameter 4711 und 4812 zu diesem Datensatz gespeichert werden?

    Wenn JA = WIE?

    UND kann man diese beiden Parameter in der weiteren Kommunikation nutzen.

    Wenn ich z.B. eine automatische Antwort schicke, kann ich diese beiden Parameter als Platzhalter nutzen?

    Beispiel:

    Hallo NAME,

    vielen Dank für Dein Interesse an 4711 und 4811.

  • Profile Image
    Ariel_P
    Answered on May 22, 2021 at 05:55 AM

    Hello,

    Embedded forms can capture the parent window's query strings. You can use this to prepopulate your form. Create a field that will hold your UTM value, and prepopulate it via URL parameters. You may refer to the following guide for more related information: Prepopulating Fields to Your Jotform via URL Parameters

    Regarding the placeholders, yes. You can use the form element's {unique_name}, in that format, to display its value on the form.

    1621676988_60a8d3bc0a105_

    The element's unique name can be found here:

     1621677184_60a8d48100e4f_

    Hope that helps. Let us know if you have any questions or if you need further assistance.

    If you prefer to receive help in your native language, please let us know and we'll forward your ticket to the related team.


  • Profile Image
    jeankendall
    Answered on May 22, 2021 at 06:00 AM

    Hello!

    Thanks for that quick answer.

    But my main question was ...

    Can I save UTM Parameters in Jotform Database and use them later in Communication?

  • Profile Image
    Ariel_P
    Answered on May 22, 2021 at 09:19 AM

    Submitting the form will save the data to Jotform's database. If you're referring to pre-populating the form with data from previous entries on your form, you can download the submission data to Excel, use the Spreadsheet to form widget to upload your spreadsheet to your form, and use the values you have on the spreadsheet to prepopulate the fields.

    Related Guide: How to Use the Spreadsheet to Form Widget