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.
JotForm and Zapier Integration to MySQL changing URL link from Uploaded fielsAsked by festivalnacionaldacancao on May 13, 2014 at 12:34 PM
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
The http://www.jotform.com/uploads/festivalnacionaldacancao/40193325531346/265557026791187137/Staden- perfume.mp3
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?
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.
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
2014-05-13 22:02 GMT+02:00 JotForm Support Forum :
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.
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.