- lafototecaAsked on May 05, 2015 at 12:13 PM
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:
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?
- BenAnswered 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