Solution for spreadsheet in which data changes constantly?

  • Profile Image
    etiaccess
    Asked 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
    Charlie
    Answered 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
    eaguiar
    Answered 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
    Charlie
    Answered 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.