Integrate two forms with one Google Spreadsheet.

  • juanbernardolince
    Fecha de consulta 18 de mayo de 2024, 14:35

    Adicionalmente, un segundo formulario donde el vendedor registre cada vez que haga una venta con los datos de marca, producto, cantidad.

    Por último se podría integrar ambos formularios, de manera que en la integración con google sheets toda la información quede recopilada en el mismo data set. Muchas gracias!

  • Eliza Jotform Support
    Fecha de respuesta 18 de mayo de 2024, 15:00

    Hi Juan,

    Thanks for reaching out to Jotform Support. Unfortunately, our Spanish Support agents are busy helping other Jotform users at the moment. I'll try to help you in English using Google Translate, but you can reply in whichever language you feel comfortable using. Or, if you'd rather have support in Spanish, let us know and we can have them do that. But, keep in mind that you'd have to wait until they're available again.

    Now, coming back to your question, it's currently not possible to integrate multiple forms with one Google Sheet. Each form integration will create a new worksheet. As a workaround, you can integrate your two forms with the same spreadsheet, and then combine both worksheets with all the data using Merge Sheets add-on. Integrating your form with the same spreadsheet is easy. Let me show you how:

    1. In Form Builder, click on Settings in the orange navigation bar at the top of the page.
    2. Go to Integrations.
    3. Select Google sheets. Integrate two forms with one Google Spreadsheet Screenshot 50
    4. Select your Google Sheet account for authentication. Integrate two forms with one Google Spreadsheet Screenshot 61
    5. Select Use an existing spreadsheet, and click on Select under Spreadsheet name to select the Spreadsheet that you want to use. Integrate two forms with one Google Spreadsheet Screenshot 72
    6. Under Worksheet name, input a name to easily recognize the sheet.
    7. Check all the form fields that you want you send on your new worksheet.
    8. Click on Save at the button. Integrate two forms with one Google Spreadsheet Screenshot 83

    We also have a guide about How to Integrate Forms with Google Sheets that you can check out.

    Reach out again if you need any other help.