If a player inputs a number in one of our jotforms- is there a way to have the existing embedded spreadsheet be updated and viewed on our website

  • Profile Image
    tigerbluelacrosse
    Asked on May 20, 2013 at 12:24 PM

    We want to have a place on our website where players go to our team site and use the jotform we have in place to continually update a number (the number represents the passing repititions they have done) and have it be updated on our site???

  • Profile Image
    jonathan
    Answered on May 20, 2013 at 03:01 PM

    Hi,

    If you were refering to the Google Spreadsheet integration , the integrated spreadsheet does get updated everytime when new submission is done on the form.

    You can embed the google spreadsheet in your website by publishing.

     

     

    Hope this help. Inform us if you have further question.

    Thanks.

     


  • Profile Image
    tigerbluelacrosse
    Answered on May 22, 2013 at 12:05 PM
    Hello-
    Thank you for your help. If a kid, Bill, puts his name and information
    into the Jotform on my site it will show up on the spreadsheet-- When Bill
    goes to enter a new number at a later date in the same Jotform will his new
    entry create a new entry on the spreadsheet or will it just change the
    information in his space on the "old" spreadsheet? I hope that makes
    sense!?
    Thanks, Chip
  • Profile Image
    Welvin
    Answered on May 22, 2013 at 12:53 PM

    Hi Chip,

    That is possible with the Edit Link. Add an Auto Responder to your form, include the Edit Link in the auto responder so they can update their submissions anytime.

    In form submissions page, the submission for that particular user will be updated once they click and edit the submissions via the edit link provided. However, if you have integration this form to Google Spreadsheet, it will not update there. It will create a new data into the Spreadsheet - add a new row.

     

    Thank you!

  • Profile Image
    tigerbluelacrosse
    Answered on May 22, 2013 at 01:40 PM
    Hello-
    I appreciate your help! So how can I have 50-60 players edit their input
    and have it post on my website. Can they open and edit a spreadsheet on my
    website?
    Thanks again for your efforts, Chip
  • Profile Image
    Welvin
    Answered on May 22, 2013 at 02:22 PM

    Hi,

    I suggest creating Grid or HTML Listing Report. This method allows you to embed the results into your website. 

    Create HTML Table Listing Report

    Create Grid Listing Report

    With regards to how they can edit their submissions, again, create an auto responder. In Auto Responder, add the edit link then ask them to saved or bookmark the edit link. This way, they are able to go back and edit submissions without having to submit a new entry to your form which will result to duplicate entries.

     

    Thank you!