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.

  • Profile Image

    Answered by eaguiar on June 13, 2017 at 05:04 AM

    I am looking for this. I would like to fill some data of the form that will be picked from a spreadsheet. 

    For example: user enters his user number,  with that user number jotform will enter other fields of the form with data from the spreadsheet (name of the user, favorite templates, paying method, discounts etc.. 

     

    Is this possible? 

     

  • Profile Image
    JotForm Support

    Answered by Charlie on June 13, 2017 at 05:18 AM

    @eaguiar

    To better assist you, I have opened a separate thread for your concern. Please refer to this link instead: https://www.jotform.com/answers/1171581. We will address it accordingly.

    Thank you.