What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    URGENT Integration with Spreadsheet Google lost a part

    Asked by grisu59 on November 13, 2013 at 04:14 PM

    Hello, I have create an integration between this form

    http://form.jotformpro.com/form/33135089925964

    and this spreadsheet

    https://docs.google.com/spreadsheet/ccc?key=0AmdvTu4S17PFdGhtVXFlTkxDLVVvZFJUNGt3UlVwcEE&usp=drive_web#gid=0

     

     

    All was fine until 1 our ago with updates

    but now when I add a record only last 5 columns on the right are update not the first columns

    (I had by my hands the informations in these columns colred in red)

     

    Why?

     

    Claudio

    create hello
  • Profile Image
    JotForm Support

    Answered by Mike_T on November 13, 2013 at 05:46 PM

    We are very sorry for the inconveniences caused.

    It is probably that some recent changes to our Google Spreadsheet integration created some bugs. I have created a bug report ticket and escalated it to our Development Team.

    We will get back to you with update to this thread once we have any news.

  • Profile Image

    Answered by grisu59 on November 14, 2013 at 12:28 AM

     

    just for your information

     

    before of this problem spreadsheet lost all the custom fields that i added.I

     

    i must use a recover google version of the spreadsheet

     

  • Profile Image
    JotForm Support

    Answered by alp_deniz on November 14, 2013 at 01:02 AM

    Hello Sir,

    I am sorry for troubles it caused but it is fixed now. You should be able to use it without any problems.

    All the best

  • Profile Image

    Answered by grisu59 on November 14, 2013 at 01:34 AM

    I hope that will be true ;-)

    because the spreadsheet lost another time configuration that I did

    Anyway I used a recovered version and all was ok.

     

    Thanks

  • Profile Image
    JotForm Support

    Answered by EltonCris on November 14, 2013 at 04:56 AM

    @grisu59

    That is great to hear!

    If you come across any issues again, feel free to report it in this Support Forum.

    Thank you so much!

  • Profile Image

    Answered by grisu59 on November 14, 2013 at 05:29 AM

    There is still a problem because the number of record (column A in the spreadsheet) is not updated automatically (I add by hand the numers in red color)

     

    BE CAREFUL because I don't want lost the configuration of the spreadheet

     

    Thanks

  • Profile Image
    JotForm Support

    Answered by jonathan on November 14, 2013 at 06:56 AM

    Hi Claudio,

    Can you give as separate duplicate copy of the spreadsheet.
    This way there is no risk in messing your live spreadsheet.

    You can just copy the spreadsheet in google and share to us the URL of the copy.

    We await for your updates and we will check this further.

    Thanks.

  • Profile Image

    Answered by grisu59 on November 14, 2013 at 09:42 AM

    This is the copy of the spreadsheet (thanks for the suggest!)

    https://docs.google.com/spreadsheet/ccc?key=0AmdvTu4S17PFdHJuUk9wdkdyVUJ1Z3FQRHdqYl8wQ1E#gid=0

     

  • Profile Image

    Answered by EliezerN on November 14, 2013 at 11:43 AM

    Thanks for sharing the copy of the spreadsheet, however, we are not able to access to it as it is set as Private. So, in oreder to give us access to it kindly change it to public or to Anyone with the link so that we can accesss to it and further ivestitgate.

    Thanks

  • Profile Image

    Answered by grisu59 on November 14, 2013 at 11:49 AM

    Sorry I forget

    Now I share with everyone has the link!

    Do you need also modify the spreas sheet or jus view?

     

    Another question:

    if I modify teh values in the database they are not automatically updated on the spreadsheet?

     

    Thanks

  • Profile Image

    Answered by khrisell on November 14, 2013 at 12:15 PM

    Hello,

    Those who you shared the spreadsheet with will also be able to edit it.

    The data that will only be carried in the spreadsheet is from the form itself. If you update from your own database, it will not be synced with your spreadsheet. As the integrated Spreadsheet is fetshing data from the form only.

    Please let us know if you need further calrifications.

    Thank you.

  • Profile Image

    Answered by jeanettebmz on November 14, 2013 at 12:30 PM

    Don't worry, I've added the link to that copy into the ticket. Your original one won't be touched

  • Profile Image

    Answered by grisu59 on November 14, 2013 at 03:57 PM

    I don't explain well, of course I mean if I modify the values using the form after that I confirm the first time, the values are not modified in the spreadsheet

  • Profile Image
    JotForm Support

    Answered by Mike_T on November 14, 2013 at 04:32 PM

    I was not sure about the edit submission functionality with the Google Spreadsheet integrated form, so I have tested this and found that we do update edited submission on connected Google Spreadsheet.

    Please re-check this from your side, and if this is not working, create a new thread about it. Then, we will be able to do more tests and escalate the issue if needed.

    Thank you.