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

    Sending form data to a certain spreadsheet based on chosen option

    Asked by angusrussell on August 22, 2014 at 10:07 AM
    Is it possible to use the conditional logic to send a form's data to a certain spreadsheet dependent on the event chosen?
  • Profile Image
    JotForm Support

    Answered by david on August 22, 2014 at 10:41 AM

    Hi,

    Unfortunately it is only possible to have your form integrated with only one spreadsheet.  Due to this, the information from each form can only be sent to one spreadsheet and the data must be consistent.  If you alter the form or the spreadsheet after integrating, the integration could also break.  Please let us know if you have any further questions and we will be happy to help.

    Thank you for using JotForm!

  • Profile Image

    Answered by angusrussell on August 22, 2014 at 11:23 AM

    OK, so in my example, as a race organiser, I'd need to use a separate form for each event?

    Or send it all to one spreadsheet, and then filter/sort the data to separate out the bits I need?

    Thanks

  • Profile Image
    JotForm Support

    Answered by david on August 22, 2014 at 11:35 AM

    Hi,

    Yes you would need a separate form form each spreadsheet or you could also have all your forms pump the data to one spreadsheet and just filter from there.  The form fields would need to be identical if you are going to use one spreadsheet.  Multiple forms can integrate to one spreadsheet though you can't integrate multiple spreadsheets to one form.