Pre-filled URL is mixing fields in the Jotform

  • Profile Image
    Daniel_daniel619
    Asked on November 01, 2021 at 03:11 AM

    Hi,


    I have an automation where a pre-filled URL is created in Airtable by using the data inputed into the relevant table. Airtable uses a formula to substitute the relevant inputs, the formula is the following:


    SUBSTITUTE("https://form.jotform.com/212159048340046?investorSignatory[first]=" & {Signatory 1 First Name (Simple)} & "&investorSignatory[last]=" & {Signatory 1 Last Name (Simple)} & "&investorSignatory2=" & {Signatory 1 Title (Simple)} & "&investorEntity4=" & {Investor Entity Legal Name (Simple)} & "&investorSignatory5=" & {Signatory 1 Email (Simple)} & "&individualOr=" & {Type of Investor} & "&issuerName=" & {Issuer Name} & "&investorName[first]=" & {Investor First Name (Individual)} & "&investorName[last]=" & {Investor Last Name (Individual)} & "&investorEmail=" & {Investor Email (Individual)} & "&investorEntity=" & {Entity Type} & "&investingEntity26=" & {Investor Entity Legal Name (Complex)} & "&signatoryName[first]=" & {Signatory 1 First Name (Complex)} & "&signatoryName[last]=" & {Signatory 1 Last Name (Complex)} & "&signatoryTitle=" & {Signatory 1 Title (Complex)} & "&signatoryEmail=" & {Signatory 1 Email (Complex)} & "&preferredSignature=" & {Delivery Method} & "&yourName[first]=" & {Submitter First Name} & "&yourName[last]=" & {Submitter Last Name} & "&yourEmail=" & {Submitter Email} & "&additionalRequests=" & {Additional Requests} & "&investorSignatory126[first]=" & {Signatory 2 First Name (Simple)} & "&investorSignatory126[last]=" & {Signatory 2 Last Name (Simple)} & "&investorSignatory127=" & {Signatory 2 Title (Simple)} & "&investorSignatory128=" & {Signatory 2 Email (Simple)} & "&Of134=" & {Number of Signatories (Complex)} & "&Of=" & {Number of Signatories (Simple)} & "&signatory2[first]=" & {Signatory 2 First Name (Complex)} & "&signatory2[last]=" & {Signatory 2 Last Name (Complex)} & "&signatory2137=" & {Signatory 2 Title (Complex)} & "&signatory2138=" & {Signatory 2 Email (Complex)} & "&Of140=" & {Number of Signatory Entities} & "&signatoryEntity=" & {Signatory Entity 1 Byline} & "&signatoryEntity142=" & {Signatory Entity 2 Byline} & "&signatoryEntity143=" & {Signatory Entity 3 Byline} & "&cartaEmail=" & {Carta Email} & "&addressLine=" & {Address Line 1 (Individual)} & "&addressLine146=" & {Address Line 2 (Individual)} & "&city=" & {City (Individual)} & "&country=" & {Country (Individual)} & "&state=" & {State (Individual)} & "&stateprovince=" & {State/Province (Individual)} & "&postalzipCode=" & {Postal/Zip Code (Individual)} & "&addressLine150=" & {Address Line 1 (Simple Entity)} & "&addressLine151=" & {Address Line 2 (Simple Entity)} & "&city152=" & {City (Simple Entity)} & "&country164=" & {Country (Simple Entity)} & "&state166=" & {State (Simple Entity)} & "&stateprovince153=" & {State/Province (Simple Entity)} & "&postalzipCode154=" & {Postal/Zip Code (Simple Entity)} & "&addressLine157=" & {Address Line 1 (Complex Entity)} & "&addressLine158=" & {Address Line 2 (Complex Entity)} & "&city159=" & {City (Complex Entity)} & "&country165=" & {Country (Complex Entity)} & "&state167=" & {State (Complex Entity)} & "&stateprovince160=" & {State/Province (Complex Entity)} & "&postalzipCode161=" & {Postal/Zip Code (Complex Entity)}, " ", "%20")


    My current issue is with the following items:

    -> "&investorEntity4=" & {Investor Entity Legal Name (Simple)}

    -> "&investorEntity=" & {Entity Type}


    The first item is a short text input where the name of a company is inputed, for example: Acme, LLC.


    The second item is where the category of that company is selected, this is a single select form in Jotform options being: Simple Entity or Complex Entity.


    Currently, the links that are generated have all the correct field IDs but when a link is generated the data from second field (investorEntity) is also inputed into the first field (investorEntity4).


    Here is an example URL link with fake information:

    https://form.jotform.com/212159048340046?investorSignatory[first]=Daniel&investorSignatory[last]=Test&investorSignatory2=Principal&investorEntity4=Acme%20I,%20L.P.&investorSignatory5=daniel@test.com&individualOr=Entity&issuerName=Acme%20Health,%20Inc.&investorName[first]=&investorName[last]=&investorEmail=&investorEntity=Simple%20Entity&investingEntity26=&signatoryName[first]=&signatoryName[last]=&signatoryTitle=&signatoryEmail=&preferredSignature=DocuSign&yourName[first]=Daniel&yourName[last]=Test&yourEmail=daniel@test.com&additionalRequests=&investorSignatory126[first]=&investorSignatory126[last]=&investorSignatory127=&investorSignatory128=&Of134=&Of=1&signatory2[first]=&signatory2[last]=&signatory2137=&signatory2138=&Of140=&signatoryEntity=&signatoryEntity142=&signatoryEntity143=&cartaEmail=daniel@test.com&addressLine=194%20Doe%20Road%20South%20&addressLine146=&city=New%20York&country=&state=&stateprovince=NY&postalzipCode=38120-2256&addressLine150=194%20Yates%20Road%20South%20&addressLine151=&city152=Memphis&country164=United%20States&state166=TN&stateprovince153=&postalzipCode154=38120-2256&addressLine157=&addressLine158=&city159=&country165=&state167=&stateprovince160=&postalzipCode161=

    Thank you

  • Profile Image
    Daniel_daniel619
    Answered on November 04, 2021 at 07:41 PM

    Following up on this, much appreciated.

  • Profile Image
    Nikola
    Answered on November 05, 2021 at 03:23 AM

    Sorry for the late reply. I saw that one of my colleagues is working on your issue. I'll ask her if she has an update.

  • Profile Image
    Sam
    Answered on November 05, 2021 at 06:23 AM

    Hello Daniel_daniel619,

    I'm not sure why this is happening.

    Kindly try to update the unique name of the field

    and then update the URL as well to see if this will resolve the problem.

    Let us know how it goes.