Problemas con integracion google form

Buenos dias,

Habiar realizado un jotform para unas visitas de compostaje, y vinculado los resultados a un google sheet. Google sheet en el cual habia hecho tablas dinamicas para hacer un tratamiento de datos automatico. Resulta que no todos los datos del formulario se añaden en el google sheet (pero si estan en jotfrom y los puedo descargar). He visto que la unica manera de hacer los era re hacer la integracion con google sheet...pero en este caso pierdo todo el trabajo que he hecho en el google sheet inicial. Hay alguna manera de revincular los datos con el google sheet inicial.

Para ejemplos:

• Esto es el google sheet inicial : https://docs.google.com/spreadsheets/d/1nakTroqxj4SiOZEJi839S7W34j0Z_N12D2xNKbhtn-Y/edit?usp=sharing
• Y esto es el formulario: https://form.jotform.com/223253860658360
• 
  

Hi cepitu,

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, let me help you with your question. I'm sorry this is happening. Have you made any changes to the Google Spreadsheet that was integrated? Please know that any changes that you make to the column header in the Google Spreadsheet that is integrated will result in the integration to break. You can redo the integration in Jotform to fix it.

Reach out again if you have any other questions.

Hi Janice

No I haven't touch anything in either the jotform or the google sheet. And as I explained, I have some work done on the original google sheet (pivot tables) that allows me to automate things quite a bit. I am afraid that if I redo the integration all this work will go to waste and I will have to redo everything

Thanks to see if there is another solution.

Cheers

Nicolas

Hola Nicolás,

Gracias por los detalles adicionales. Al re-integrar tu formulario con un documento en Google Sheets no perderás los datos previamente recolectados, solo tienes que dejar activada la opción de "Enviar datos existentes a la hoja":

Incluso puedes escoger el documento que ya estabas usando en Google Sheets al seleccionar "Utilice una hoja de cálculo existente":

Pruébalo y déjanos saber si tienes alguna otra pregunta.