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.
Take Photo Widget: the submission starts with an image name followed by the link when the submission sends to google spreadsheetAsked by natt1 on June 13, 2016 at 05:03 AM
In my form I have "take photo" widget. The form is connected to a spreadsheet. The photo is sent to spreadsheet like this;
However, I only need the "https" part for my mapping project (the map only recognizes the links). So I have to get rid of the first part with . How can I do this?
In my spreadsheet I entered a new column with a split formula (which would take the photo string and split it) but then the spreadsheet stopped receiving new form submissions. I guess I can't edit a spreadsheet so I need another solution.
Thank you very much for all the help.
I had been trying the form from multiple devices. Now I realize that "take photo" widget interacts with Google spreadsheet differently when it comes to phones and computers. In spreadsheet the following results can be observed depending on the device;
Phone Photo: Spreadsheet cell starts with https://
Computer Photo: Spreadsheet cell starts with [Photo_759e74b.jpg]
Is there a way to solve this issue and remove this difference among submissions?
It seems that that's how it delivers the information to the spreadsheet.
I have forwarded this inquiry to the development team to see if there is something that can be done. However, I cannot guarantee that this issue can be resolved right away as they have been quite busy with matters in the pipeline. But as soon as we have updates, we'll inform you right away.
Thank you for the response
Have a great day