Mensaje de error en formulario con integraciones

  • ccieton
    Fecha de consulta 5 de junio de 2023, 16:16

    Saludos.

    Actualmente tenemos activo el siguinet formulario:

    https://form.jotform.com/ccieton/preescolar-armado-grupos-23-24

    Pero a partir del día de hoy comenzamos a recibir el siguiente mensaje de error:

    "SELECT failed while reconnecting<hr>"

    Y no guarda los registros.

    Este formulario se encuentra integrado con una cuenta de Google a una hoja de GSheet.

    ¿Qué debemos hacer para resolver este conflicto?

    Quedo atentos a sus comentarios. ¡Excelente día!

    .-)

  • Patrick Jotform Support
    Fecha de respuesta 6 de junio de 2023, 7:44

    Hi alejandra,

    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 assist you in English using Google Translate, but you can reply in whichever language you feel comfortable using. Or, if you'd prefer to receive 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, let me help you with your question. I've cloned your form to see if I'll bump into the same error message, but everything worked the way it should. Check my screenshot below:

    Mensaje de error en formulario con integraciones Image 1 Screenshot 20

    If you are having issues with Google Sheets, removing and reading the integration fixes the imparity between Jotform submission and the information on Google Sheets. Let me show you how you can remove and add the Google Sheets integration again:

    • In Form Builder, in the orange navigation bar at the top of the screen, click on Settings.
    • In the Settings menu, click on the Integrations option on the left side of the screen.
    • Select the Google Sheets integration.
    • Then, click on Remove Integration, and then Yes, Remove!

    1648534382 6242a36eb58bf screencast 2022 Screenshot 31

    • Now, let's connect the Google Sheets Integration again:
    • In Form Builder, circle back to Settings at the top of the page.
    • In the Settings menu, click on the Integrations option and Google Sheets integration again.
    • Now, select and connect your Google account.

    1648109353 623c27296967e screencast 2022 Screenshot 42

    • Select an option.
    • Choose your form fields.
    • Make sure the Send existing submissions to the sheet is checked.
    • Click on Save, and that's it, you're done.

    1648109623 623c28372f503 screencast 2022 Screenshot 53

    This will reactive the integration and send all the previous submissions to your Google Sheets file.

    We also have a guide about Google Sheets integration that you can check out.

    Give it a try and let us know.

  • ccieton
    Fecha de respuesta 6 de junio de 2023, 10:31

    Thank you very much! It works!

    Regards!


    .-)