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.

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.

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

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.