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

    Editing Google Spreadsheets

    Asked by englep10 on October 16, 2014 at 11:34 AM

    Hey guys,

        I have created a form that will help my company when they are cold calling so that it is easier for them to quickly insert information. However because I had the need for a lot of options in my forms my google spreadsheet is extremely long with the possibility of answers. Is there a function that if something was left blank that it could be condensed? Sorry this is kinda of a confusing question without much background information. I will show you what my form looks like so that you guys can better understand my predicament. I was also thinking that I could potentially do this through the spreadsheet function. Setting the form inputs to an equals function that would condense what I would like to see.

     

    Best,

       Philly Cheesesteak

    Page URL:
    http://form.jotform.us/form/42557879459173?

    My Forms information company
  • Profile Image

    Answered by englep10 on October 16, 2014 at 11:37 AM

    I forgot to ask my biggest question. Can I tell the jot form submissions where to go on the spreadsheet? that would help a lot with organization 
  • Profile Image
    JotForm Support

    Answered by Welvin on October 16, 2014 at 01:48 PM

    Hi Philly,

    Condense, meaning, don't include it in the spreadsheet when left empty? Or put it into? Or something to set aside when the field is left empty. In general, all fields are included in the Google Spreadsheet. With or without a data submitted to it, the field will still appear in the spreadsheet columns. I think removing the label is possible with a script in Google Spreadsheet, but when you do it, how can the other submissions be put into when the field is not there? 

    Also, you will break the integration when any modifications will be made to the form and the spreadsheet, especially, the labels which is on the first row. We don't recommend any modification when the integration is present. Otherwise, there will be a problem.

     

    Your question related to the location of the submission has been moved here as a new thread: http://www.jotform.com/answers/444444

    Thank you!

  • Profile Image

    Answered by englep10 on October 16, 2014 at 02:42 PM

    Thank you, makes sense!