How to generate a URL based on a concenation of a static URL and a unique ID?

  • Beanie3556
    Asked on March 2, 2017 at 9:22 AM

    I want to create a form where following will appear


    A) an generated URL that is based on a combination of (1) a static URL (ex. www.mydomain.com/orders/ and (2) the purchase order number of the form that is a unique number generated by the widget "Unique ID" and (3) another static rerence "/index.html"

    B) A QR-code that contains the above generated URL

     

    A) About the URL that shall be generated:

    The field "Order number" is a unique counter that increases with "1" for every form that is submitted.

    In the field "URL", I want the following to appear:

    www.mydomain.com/orders/ordernumber/index.html

    "www.mydomain.com/order/ordernumber" will be the folder where I manually will upload the ordered item upon form submission

    "index.html" will be a page that I will upload upon form submission. (for the user to later access and download his purchased item)

    The URL-field shall show 3 concentated items (prefix+ordernumber+suffix)

    Prefix= www.mydomain.com/orders/

    middle= the unique order number

    suffix= /index.html

    When a form user selects either Blue, red or yellow, I want the URL to automatically be filled.

    Assume the first user selects a color, then the URL shall look like this:

    www.mydomain.com/orders/PO-1001/index.html

    When next user select a color, , then the URL shall look like this:

    www.mydomain.com/orders/PO-1002/index.html

     

    B) About the QR code

    I want to use the dynamic QR widget to generate the QR code based on the URL-field. (I have got that part to work, because if I try to manually input a domain in the URL field, a QR code will appear), but the QR code does not appear since I dont get the concenation to work in the URL-field.

    In a auto-response email to the form submitter, I want both the URL and the QR-code to appear.

    Reading the forum and about the QR-code widget, I understand that it is possible to achieve this.

    I tried little of everything, but I could not get it to work. The purchase order number is not visible in the form preview.

     

    If anyone could guide me on how to achieve this, I would be very very happy.

    Thank you very much in advance for your support.

     

  • David JotForm Support Manager
    Replied on March 2, 2017 at 12:35 PM

    I think this can be accomplished. After you have completed your form, and setup your custom unique ID.

    How to generate a URL based on a concenation of a static URL and a unique ID? Image 1 Screenshot 50

    You can paste the URL in a notification, and/or Thank You page. For this example, I will display it in the Thank You page:

    1) Click on Settings.

    2) Click on the Thank You Page tab.

    3) Click on the Form Fields drop down to paste the variable of the Unique ID in the meddle of the URL.

    How to generate a URL based on a concenation of a static URL and a unique ID? Image 2 Screenshot 61

    4) Create the Hyperlink:

    How to generate a URL based on a concenation of a static URL and a unique ID? Image 3 Screenshot 72

    Here is my cloned version for you to test: https://form.jotform.co/70605196845866 

    How to generate a URL based on a concenation of a static URL and a unique ID? Image 4 Screenshot 83

    On regards of the QR code, I am still trying to figure out how to accomplish it. I will let you know if it is possible to do it. Hope this helps.

     

  • David JotForm Support Manager
    Replied on March 2, 2017 at 1:19 PM

    Hi, I have tried to generate the URL in the form, and add it into the Dynamic QR Code widget.  However this is not possible, because the Unique ID value is generated after the form is submitted. So, the QR Code part will not be possible to accomplish.

  • Beanie3556
    Replied on March 3, 2017 at 2:33 AM

    Dear BDavid,

    Thank you very much for your effort to solve this for me. It was really good actually.

    The thank-you page shows the link. I understand from you that the QR code part cannot be accomplished. It is not all the way to my goal, but pretty close to it.

     

    I noticed one small problem that I need to address.... Please look at the image below. It is how it looks in the e-mail that the submitter will receive.

     

    As you can see, the form submitter will see the "prefix, Suffix and URL (where the order number is left out).

    I do not want this to show in the email. I want the link that is shown in the thank-you-page to be shown.

    Like the one that is below....

    http://www.mydomain.com/orders/PO-1010/index.html

    Is this possible to achieve?  It would be very nice of you if you were able to show me how to do this.

     

    Thank you very much in advance for your great support.

    Best Regards,

    Bjorn

  • Support_Management Jotform Support
    Replied on March 3, 2017 at 5:29 AM

    I noticed one small problem that I need to address.... Please look at the image below. It is how it looks in the e-mail that the submitter will receive.

    Looks like you replied straight from your email and attached the image there. We can't see attachments in our Forum. Please resend it by opening your thread https://www.jotform.com/answers/1080150 > then post your reply along with your screenshot from there.

    Related guide: How-to-add-screenshots-images-to-questions-in-support-forum

    Now, I'm assuming this is the new form you're tinkering around with 70611491773457. So I cloned that and did a test submission and got the URL on the THANK YOU page exactly as expected:

    http://www.mydomain.com/orders/PO-1001/index.html 

    How to generate a URL based on a concenation of a static URL and a unique ID? Image 1 Screenshot 30

    I'm guessing you're talking about the Email Notifications / Autoresponders. These can be modified so it won't include the Suffix, Prefix and URL. All you have to do is delete them from the email template.

    How to generate a URL based on a concenation of a static URL and a unique ID? Image 2 Screenshot 41

  • David JotForm Support Manager
    Replied on March 3, 2017 at 11:31 AM

    In addition to my colleagues suggestion. You can simply delete those fields:

    How to generate a URL based on a concenation of a static URL and a unique ID? Image 1 Screenshot 20

    They are useless, I created them when I was trying to find a way to accomplish the QR-code part, and forgot to delete them, that's why they appeared when you cloned my demo.