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

  • Profile Image
    Asked 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
    Answered 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.