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

    Solution for spreadsheet in which data changes constantly?

    Asked by etiaccess on September 01, 2015 at 02:22 PM

    Hi Aytekin,

     

    I guess this solution is good for static spreadsheet. But do you have any solution for spreadsheet in which data changes constantly.

  • Profile Image
    JotForm Support

    Answered by Charlie on September 01, 2015 at 02:33 PM

    Hi,

    Just to clarify, when you say the data constantly changes, are you referring to the actual submission itself? Let's say you are editing or updating the submissions using the edit link or in the Edit mode in the submissions page?

    If you are editing the submissions using those options then it will automatically update the submission in the Google Spreadsheet to where it is synced.

     

    If what you are referring to is making changes on a spreadsheet, then what I can recommend is using ImportRange function in the integrated spreadsheet to a master spreadsheet where you can easily change, edit or add new columns without breaking the integration of the other spreadsheet connected to the form.

    I hope that helps.