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

    Is there a way to auto save an excel report so that people can update the report fields without having to pull down a new report every time?

    Asked by prossmann on June 19, 2015 at 03:02 PM

    So I have an IT Work Order that my staff needs to fill out when they want IT to do a job.  I want to be able to have an Excel report auto saved to say my server so my IT team can access it, and update certain fields such as when it is complete, and what date and time it was completed.

    excel auto save new report Without
  • Profile Image

    Answered by Sammy on June 19, 2015 at 03:40 PM

    You can integrate your form with Google spreadsheet, which will save the submitted form data upon form submission by the user.

    You can then share the link to this spreadsheet with your IT team.

    Keep in my that the any updates on the spreadsheet will not propagate back to the data saved on jotform.

     

  • Profile Image

    Answered by prossmann on June 23, 2015 at 03:56 PM

    Not sure what you mean in your last sentence about updates on the spreadsheet propagating back to the data saved on the form.  Can you please explain?

    What I want is to have a running spreadsheet with columns that my IT person can constantly update on the running spreadsheet.  Is that what the integration will do?

     

    Thanks

  • Profile Image

    Answered by Sammy on June 23, 2015 at 04:42 PM

    Hi,

    Sorry for the unclear part, what i meant was that updates to the integrated spreadsheet will not be saved to the original submission data in jotform.

     

    Regarding the spreadsheet the integration will create a spreadsheet that will be constantly updated with new submissions, which can also be modified in addition you can specify your additional columns on the spreadsheet.