Two Forms, One Google Spreadsheet?

  • Profile Image
    Asked on January 30, 2014 at 03:10 PM

    We have two separate forms that we are creating for a program, one for applicants and another for references.  We were wondering if when we created a spreadsheet for one, we might make the other another tab within that same spreadsheet.

  • Profile Image
    Answered on January 30, 2014 at 04:35 PM

    Hi, if both forms have the same fields, you could integrate Google Spread in one form, then clone it and change the tittle of the cloned form. In that way you will be getting all the data from both forms into one spreadsheet. 

  • Profile Image
    Answered on January 31, 2014 at 04:37 PM

    Unfortunately the two forms do not have the same fields. For example, we have students input email addresses of the people who would be submitting recommendations for them (currently designed on a separate sheet).  Would it be possible to send emails to those individuals using the conditions button with the separate form that could then be added to the other information on the spreadsheet?

  • Profile Image
    Answered on January 31, 2014 at 08:26 PM

    Sounds like you want to send emails to the referrees automatically, then have them fill out a form which automatically updates the existing integrated google spreadsheet, right?

    Well unfortunately, it is not possible to do that with current jotform features.

    Automation of such a workflow would also be a bit difficult, and prone to errors.

    I would advice that you export the referee data once submitted manually import it to Google Spreadsheet.

    I will brainstorm this with the support team and update this thread.

    Please advice us with the general workflow so that we may understand the bigger picture.