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

    Can I add HTML code to form data prior to is posting to Google Sheet?

    Asked by claybj on December 01, 2014 at 04:25 PM

    I need to add the HREF tag to form data prior to it posting into the linked Google Sheet.


    thanks - clay

    form data href
  • Profile Image
    JotForm Support

    Answered by Mike_T on December 01, 2014 at 05:34 PM

    Thank you for contacting us.

    It is not likely that we can adjust the user input data. Can you please provide us with some example use-case? We will see if there are any workarounds.

  • Profile Image

    Answered by claybj on December 01, 2014 at 05:36 PM

    Ok... then another quick question.  Can we separate the Latitude and Longitude numbers in the Jotform Google Map app so that they post to two separate fields?  Unfortunately Google Maps Pro wants a field for each Lat and Long, but Jotform's Map App only posts to one field.


    help :)


    thanks - clay

  • Profile Image

    Answered by claybj on December 01, 2014 at 05:40 PM

    Sorry.. It's ZEE Maps that needs two fields.  But Zee is the only service that automatically updates the Map from a Google Sheet.

    Here's what I'm doing:


    1.  Collect data via Jotform.

    2.  Post data to Google Sheet.

    3.  Use Zee to grab data and make map.


    Seems easy enough but it's not.  Zee wants two fields for Lat and Long.  Google's on map engine doesn't automatically update from their own sheets.


    Hope this helps.  Thanks for your assistance.


    - clay

  • Profile Image
    JotForm Support

    Answered by jonathan on December 01, 2014 at 06:56 PM

    Hi Clay,

    Your questions here are entirely 2 different things.

    I created a separate thread for the next question here http://www.jotform.com/answers/467822

    We will respond to it separately.