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

    JotForm and Zapier Integration to MySQL changing URL link from Uploaded fiels

    Asked by festivalnacionaldacancao on May 13, 2014 at 12:34 PM

    Hello 

    I have a Zapier integration with MySQL 

    When Zapier inserts the data in the table. 

    URL that is being inserted is not the same 

    which is provided by JotForm 

    example 

    JotForm 

    https://www.jotform.com/uploads/festivalnacionaldacancao/40193325531346/265557026791187137/Staden-%20O%20perfume.mp3 

    ZAPIER 

    The http://www.jotform.com/uploads/festivalnacionaldacancao/40193325531346/265557026791187137/Staden- perfume.mp3

    JotForm and uploads table www zapier mysql
  • Profile Image
    JotForm Support

    Answered by TitusN on May 13, 2014 at 04:02 PM

    Hello,

    Looks like Zapier is removing the whitespace placeholders (%20 O%20) for the upload URL.

    The name of the file is actually Staden- O perfume.mp3

    The spaces in the filename are translated as %20 when the file is uploaded to Jotform - and it looks like the integration may have a problem with this - possibly because %20 may be a system designated characer - either for Zapier or MySQL.

    My test with a similar Zapier integration did not show this behavior - but our settings might vary.

    Please check zapier's task history here: https://zapier.com/app/history

    Select the integration and find the transaction - expand the details so that you are able to see the URL that was sent - Is it the correct one?

    Similar scenario:

    If the link is correct - then MySQL is changing the link URL by removing the whitespace placeholders (%20)

    If the link is wrong - then we will forward this to our developers for futher advice.

    Looking forward to your response.

  • Profile Image

    Answered by festivalnacionaldacancao on May 14, 2014 at 08:31 AM
    Hello
    In analyzing the situation, when I access JotForm is I download the
    Submissions, the informed File (Excel) URL is encrypted using the UTF-8
    format for URL.
    and when the Zapier make MySQL Integration with the same url
    is not encrypted
    Tiago Vital Pereira Gomes
    tiago@digisulnet.com.br
    (35) 3212-4922
    www.digisulnet.com.br
    2014-05-13 22:02 GMT+02:00 JotForm Support Forum :
    ...
  • Profile Image
    JotForm Support

    Answered by TitusN on May 14, 2014 at 08:56 AM

    Hello,

    I have brought this behavior and your updates to the attention of our developers - they will advice further concerning the Jotform - Zapier - MySQL intergration.

    Thank you for your patience.

  • Profile Image
    JotForm Support

    Answered by liyam on June 10, 2014 at 09:39 AM

    We apologize for the delayed update on this case, festivalnacionaldacancao,

    I've been trying to test the submissions from JotForm and I can't seem to find an issue on our end. May I request from you to please contact Zapier on this matter via https://zapier.com/support/.

    Please do keep us posted on this matter.

    Thanks.