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

  • Profile Image
    lafototeca
    Asked 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 noopener" title="Image1.jpg">Image1.jpg</a><br><a target="_blank" href="http://www.jotformpro.com/uploads/.../Image2.jpg" rel="nofollow noopener" title="Image2.jpg">Image2.jpg</a><br>

    <a target="_blank" href="http://www.jotformpro.com/uploads/.../Image3.jpg" rel="nofollow noopener" 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

  • Profile Image
    Ben
    Answered 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