What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    How can I prevent Jotform from including html tags in the links to uploaded files entered into my DB over Zapier?

    Asked by lafototeca on May 05, 2015 at 12:13 PM

    Hello.

    I have a form with an upload button for multiple files.

    When a submission is made, the data is inserted into mySQL.

    The problem is, for an example uploading three files, I would like to see this:

     

    http://www.jotform.com/uploads/.../Image1.jpg

    http://www.jotform.com/uploads/.../Image2.jpg

    http://www.jotform.com/uploads/.../Image3.jpg

     

    What I see on the database is this:

     

    http://www.jotform.com/uploads/.../<a target="_blank" href="http://www.jotformpro.com/uploads/.../Image1.jpg" rel="nofollow" title="Image1.jpg">Image1.jpg</a><br><a target="_blank" href="http://www.jotformpro.com/uploads/.../Image2.jpg" rel="nofollow" title="Image2.jpg">Image2.jpg</a><br>

    <a target="_blank" href="http://www.jotformpro.com/uploads/.../Image3.jpg" rel="nofollow" title="Image3.jpg">Image3.jpg</a><br>

     

    Im using Zapier integration to link jotform and mySQL.

    And after half of the url of the first image, the submission starts including html tags.

    Is there a way to prevent this?

     

    form URL:

    http://form.jotformpro.com/form/50977050041954

    Submission Results:

    http://guatephoto.org/opencall/sql/jotformexample.php

    Page URL:
    http://form.jotformpro.com/form/50977050041954

    uploaded files Zapier links URL string
  • Profile Image

    Answered by Ben on May 05, 2015 at 01:16 PM

    All data is sent in the same manner from our servers, so it would either be with the HTML tags or without them, but not mixed.

    The issue most likely is found in the connection made over Zapier.

    The reason why I say this is because we send the files in the same format - should be just a string.

    Zapier might be interpreting this and adding HTML tags for the link itself.

    You should however be able to change this if the data is not going to your DB directly, but to a PHP file on your server to strip the data that you do not need.

    You could also try to do it directly over webhooks so that your data is not going over Zapier, but going directly to the file on your server that is capturing and saving the data for you.

    You can see more about this here: How to Setup Webhook with JotForm