Solution for spreadsheet in which data changes constantly?

  • etiaccess
    Asked on September 1, 2015 at 2: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.

  • Charlie
    Replied on September 1, 2015 at 2: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?

    Solution for spreadsheet in which data changes constantly? Image 1 Screenshot 20

    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.

  • eaguiar
    Replied on June 13, 2017 at 5: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? 

     

  • Charlie
    Replied on June 13, 2017 at 5: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.