Spreadsheet to Form widget pull data from live table

  • Profile Image
    DBConsortium
    Asked on July 23, 2018 at 06:01 PM

    Hello Jotform


    I have been using the Spreadsheet to Form Widget and love it.


    However, I am wondering if the Widget developer has or is planning to set it up to be able to pull the data from a live table, spreadsheet or other data source, rather than from a file which gets attached to the Widget.  And as new data gets added to the table, that newly revised table has to be added again to the Widget.


    By "live table or spreadsheet" I mean, a data structure which is updated from various sources in real time.


    The big advantage to using a live table is that as data gets added to the database or table of interest, that new data is available to the form.


    Please advise.


    Thanks,

    Don

  • Profile Image
    jonathan
    Answered on July 23, 2018 at 07:43 PM

    Hi Don,

    I have submitted this thread as feature request ticket to the next level support. We will update you on this thread once we news/updates on the status of the new feature

    ---

    An alternative method to prepopulate form fields with data from live data source is by using the form full source code and have it hosted on your website.

    You can create custom program codes using PHP or javascript to pull live data from data source into the embedded form on your website page.


    Best