Embed CSV file for fetching data values?

  • PooPipeBoy
    Asked on February 20, 2018 at 11:22 PM

    Hi,

    My goal is to create a form that fetches data from an embedded CSV file, based on inputs provided by the user.  Lets say the user wants to find out the reactivity of two substances:  They provide those two input values using dropdown lists, then the code parses a numerical result directly from 2-D tables within the embedded CSV file.

    I've done this before with Android apps, but it's proving to be much more challenging with online websites.  Since the Same-Origin Policy doesn't allow access to external domains, I have no choice but to embed (and hide) a data file within the same domain as the form itself.

    Is this possible with JotForm?  Thanks!

  • BJoanna
    Replied on February 21, 2018 at 4:49 AM

    We have a Spreadsheet to Form widget that you can use to prepopulate a form from an external Excel Sheet. Inside of this guide, you can find more about this widget:

    How to Use the Spreadsheet to Form Widget

    However, I am not sure if this will fit your needs. 

    If you only want to provide some number to your users based on the options they selected in two dropdown field, maybe you can use the From Calculation widget to calculate that number and to provide it to your users. 

    You can assign calculation values to your dropdown field and perform a calculation. Inside of this guides, you can find how to do it:

    How to Assign Calculation Value

    How to Perform Form Calculation Using a Widget

  • PooPipeBoy
    Replied on February 21, 2018 at 8:53 PM

    Thanks, I'll check it out.  For some reason it is very difficult to find an HTML service that allows simple data fetching.  Is it possible to pull data from an Spreadsheet or Data Grid widget located in the same form?

    Only other option I can think of is using some kind of free MySQL database or Google Docs spreadsheet to access data remotely, if that will even work.

  • Nik_C
    Replied on February 22, 2018 at 2:07 AM

    The only way to prepopulate the form from Spreadsheet is by using the Spreadsheet to form widget that my colleague proposed already.

    That's the only built-in solution we have.

    What do you mean by:"Is it possible to pull data from an Spreadsheet or Data Grid widget located in the same form?"