Sending form data to a certain spreadsheet based on chosen option

  • angusrussell
    تم السؤال بتاريخ ٢٢ أغسطس ٢٠١٤ في ١٠:٠٧ ص
    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
    تم الرد بتاريخ ٢٢ أغسطس ٢٠١٤ في ١٠:٤١ ص

    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
    تم الرد بتاريخ ٢٢ أغسطس ٢٠١٤ في ١١:٢٣ ص

    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
    تم الرد بتاريخ ٢٢ أغسطس ٢٠١٤ في ١١:٣٥ ص

    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.