Data Grid widget just shows as yellow block

  • Profile Image
    IDIUser
    Asked 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

  • Profile Image
    Charlie
    Answered 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
    Sunny 
    Answered 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
    Boris
    Answered 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
    IDIUser
    Answered 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
    CJRoth
    Answered 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
    Charlie
    Answered 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.