Sending form data to a certain spreadsheet based on chosen option

  • angusrussell
    Asked 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?
  • David JotForm Support
    Replied 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!

  • angusrussell
    Replied 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

  • David JotForm Support
    Replied 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.