data table - Data retrieval

  • enetknowhow
    Asked on February 15, 2016 at 1:37 AM

    1. How can I create a CSV. Table use / insert?

     

    2. How can I use values with a query?

     

     

    column

    1,2,3,4

    Row a,b,c,d

     

    Field Value Example

    Row 1

    22, 33, 44, 55

    -----------------------------

    How can I do this query

     

    if row 1 and column 3 than is = 44

     

    Thanks

     

     

     

     

     

  • jonathan
    Replied on February 15, 2016 at 4:37 AM

    #1.

    You can use the Report to create CSV Report out of the submission data.

    user guide: http://www.jotform.com/help/103-How-to-create-a-CSV-Report

    #2.

    I am not sure yet what you wanted to do here. But can you check Form Calculations 

    user guide: http://www.jotform.com/help/259-How-to-perform-calculation-in-the-form

    OR

    The Spreadsheet Widget has such calculation function as well.

    link: http://widgets.jotform.com/widget/spreadsheet

    Here is the demo form http://form.jotformpro.com/form/51730795061960?

    data table   Data retrieval Image 1 Screenshot 20

     

    Hope this help. Let us know if you need further assistance.

     

     

  • enetknowhow
    Replied on February 20, 2016 at 3:35 AM

    Hello,

    Hi, this is not what I mean. See the file that I send describing the calculation.

     

    Thanks you support!data table   Data retrieval Image 1 Screenshot 20

  • Elton Support Team Lead
    Replied on February 20, 2016 at 12:02 PM

    Sorry but we do not have that kind of widget. You may, however, consider using this widget instead but this doesn't have dynamic features like taking values from the form fields (they all are pure static text). http://widgets.jotform.com/widget/data_grid. All the values should be defined in the widget settings.

    However, you can always implement custom functions within your form source code manually. http://www.jotform.com/help/104-How-to-Download-a-Source-Code-of-your-Form

    Thank you!