data table - Data retrieval

  • Profile Image
    enetknowhow
    Asked on February 15, 2016 at 01: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

     

     

     

     

     

  • Profile Image
    jonathan
    Answered on February 15, 2016 at 04: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?

     

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

     

     

  • Profile Image
    enetknowhow
    Answered on February 20, 2016 at 03:35 AM

    Hello,

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

     

    Thanks you support!

  • Profile Image
    EltonCris
    Answered 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!