How do you display a Form Grid in a Data List

 
1
0
-1

I have a Form that contains a FORM GRID, that works perfectly. However, I want to create a DataList that contains the information form and data entered in the Form Grid.


This is the form I want to be viewed in a Data List. All the information that was entered

    CommentAdd your comment...

    2 answers

    1.  
      1
      0
      -1

      Hi Briant Fletcher

      In form grid properties, use the "Load Binder > Multirow Form Binder" and "Save Binder > Multirow Form Binder" to store your form grid child records. If you leave the Load & Save Binder empty, it will store as a JSON format.

      Correspondingly, create a new form with similar fields to your form grid but add one more hidden field for the foreign key. Then map this new form to the Load & Save Binder.

      The Joget Marketplace HR Expense Claims app has a similar example (using spreadsheet but the concept is similar) on this, refer to the form "Expense Claim Form" to see how it is done.

      Reference: Form Grid


        CommentAdd your comment...
      1.  
        1
        0
        -1

        Hi

        Do try use the Nested Datalist Formatter to display your grid data in a sub list. There are some sample apps at the bottom of the documentation.

        1. Briant Fletcher

          Thank you for this idea. However, it is really what I wanted. The form grid is still showing as the following in the datalist view.

          <<<

          [{"iModifiedBy":"Tester User","iQuantity":"2.00","":"","iUnit":"gal","iCommentsSupplier":"Berger Paints","iDescription":"White Paint","CostingCode":"","id":"a8be23b0-ac1f144b-b568eb00-d8aa404d","__UNIQUEKEY__":"a8cf1b40-ac1f144b-b568eb00-a9606710"},{"iModifiedBy":"Tester User","iQuantity":"5.00","":"","iUnit":"bags","iCommentsSupplier":"Caribbean Cement","iDescription":"Cement","CostingCode":"","id":"a8c4f5e0-ac1f144b-b568eb00-e3d6d9db","__UNIQUEKEY__":"a8cf1b40-ac1f144b-b568eb00-880977d6"},{"iModifiedBy":"Tester User","iQuantity":"1.00","":"","iUnit":"box","iCommentsSupplier":"TruValue Hardware","iDescription":"Screws","CostingCode":"","id":"a8cc5bf0-ac1f144b-b568eb00-e9839497","__UNIQUEKEY__":"a8cf1b40-ac1f144b-b568eb00-7725a1b7"}]

          >>>>

          I want to break this apart into meaningful data. So that the user and read it.

        2. Walter

          Your grid data is stored in a singular cell in the database now thus it will be hard to show in listing.

          To use Nested Datalist Formatter, you need to store the grid's data using the Multirow Form Binder. See this video tutorial - Video Tutorials#CreatingmultirowgridinForm 

          Once you store the grid/child data in proper table structure and jot in JSON form, you can use the nested datalist.

        CommentAdd your comment...