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

    How to collect data from multiple sources in one form and send it to one spreadsheet?

    Asked by butleren on January 17, 2017 at 09:55 PM
    I am gathering from around 20 forms "hour logging" from a restaurant.
    I haven´t decided yet if I should create one form with different staffs in
    a dropdown - so all data gathers into one sheet - then export from there.
    Any thoughts on best practice?
  • Profile Image
    JotForm Support

    Answered by Kevin_G on January 17, 2017 at 10:01 PM

    If you have some basic info that would be the same, then I think you could use a drop down to list the needed info, in your case the different staffs, this way you will have all your info in one spreadsheet without creating multiple spreadsheets and forms to collect almost the same info. 

    You can also customize the emails that are sent from a form and send the proper email based on the selection made on the staffs drop down. Please check this guide that will provide you more info about changing email recipients based on conditions: How-to-Send-Email-Based-on-User-s-Answer

    You could also change the thank you message if needed: How-to-Change-Thank-You-Message-Using-Conditional-Logic

    Basically, what I would recommend is to create a main form listing your different staffs, then customize your form to work based on the staff selected and have the info recorded in one form only. 

    If you have any question, please let us know.