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 Grid widget just shows as yellow block

    Asked by IDIUser on April 22, 2016 at 02:41 AM

    Hello,

    I've added Data Grid to my form https://form.jotform.com/61117002052133 under Pay Codes, but I can't figure out how to use it. When I preview the form, it's just a blank yellow box.

    The purpose of the widget is to have the user dynamically enter their text values so I can capture them on the backend in a spreadsheet or CSV for import into another app. Your spreadsheet widget wont work because it only accepts numbers. Please advise and thank you for your help.



    This is a re-post of a comment on How to Add a Widget to your Form?

    data grid widget not loading
  • Profile Image
    JotForm Support

    Answered by Charlie on April 22, 2016 at 03:09 AM

    Please note that the Data Grid widget is not an input type of field, it will just display a table with a list of values to your users, it is something like a look up table.

    The reason why it is not showing in your end because you have incorrectly set it up. In your column names, you have setup two items. However, in the data list, you have 3 items on each row, which presents 3 columns.

     

    If you want to have a table-like field that allows you to add values on them, you can try using the Matrix field.

     

    If you want your users' inputs to automatically show up on a spreadsheet, then perhaps integrating your form to Google Spreadsheet will help? You can check this guide: https://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet 

    You can also download your submissions as an excel or CSV file, you can do that in your submissions page: https://www.jotform.com/help/269-How-to-view-Submissions 

    You can also create reports for your submissions, here are the list of reports you can do: https://www.jotform.com/help/326-How-To-Create-Form-Reports-in-JotForm 

    I hope that helps. Do let us know if you need more help on this and if I misunderstood how you want your data to be presented.

  • Profile Image

    Answered by Sunny  on April 22, 2016 at 03:59 AM
    delete the post of @jameslees as this is SPAM. it redirects to an unrelated external link outside of the support forum. SNEAKY SPAMMERS !
  • Profile Image
    JotForm Support

    Answered by Boris on April 22, 2016 at 04:21 AM

    Thank you for your report and vigilance, Sunny, my colleague just noticed the spam as well and it is already deleted. :)

    If there is anything else we can assist you with, please don't hesitate opening a new support thread, and as always we'll be happy to help.

  • Profile Image

    Answered by IDIUser on April 22, 2016 at 02:44 PM
    Hi Charlie,
    Thank you for your prompt and detailed answer. This information was extremely helpful.
    Yours truly,
    Sonja
    ...
  • Profile Image

    Answered by CJRoth on July 18, 2016 at 08:33 AM

    Can I use the Data grid to capture the data entered into the form by the user and have it display to them while they are filling out the form.  Then have the user have the option to click on items in the form to add, edit or delete their selection.  If so, is their an instructional video on how to set up the Data Grid Widget?

    Thank you in advance.

  • Profile Image
    JotForm Support

    Answered by Charlie on July 18, 2016 at 09:39 AM

    @CJRoth

    To better assist you, I have opened a separate thread for your question. Please refer to this link instead: https://www.jotform.com/answers/884927. We will address it shortly.

    Thank you.