What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    data table - Data retrieval

    Asked by enetknowhow 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
    JotForm Support

    Answered by jonathan 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

    Answered by enetknowhow 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
    JotForm Support

    Answered by EltonCris 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!