How to present the Grid values in Table format in Datalist?

Confluence User - 02 Apr, 2019

Hi Guys,

I have created a few "List Grid" in my form, and it works very well in terms of flexibility in capturing multiple rows of values. However, my customer is requesting to see the details of the value in "List Grid" in the Datalist.

I have tried to pull the field into the Datalist. Unfortunately, it is displaying in JSON format rather than table/excel format.

May I know if there is any way we can have a human readable format for "List Grid"?

If "List Grid" is the the right field, may I have your kindness to point out the right tool for it in the form.

 

Thanks.

Regards,
Zach

datalists;forms;grid;listgrid

4


02 Apr, 2019
confluenceUser
confluenceUser

You can try out Nested Datalist Formatter

02 Apr, 2019
confluenceUser
confluenceUser

Nested Datalist formatter looks like a great way to present my data. Sorry if this is a silly question: This is how I currently design my app. 1. Use a CRUD to create partial data. 2. Create a form, and using the "List Grid" to pull and insert the data into my form, with added additional details. The data stored in the "List Grid" is embedded/part of the form (I imagine it is stored in a single column in the DB table in the form), and it is not a Datalist itself. May I know how can I use this Nested Datalist Formatter for "List Grid" Thanks.

02 Apr, 2019
confluenceUser
confluenceUser

Just trying to rephrase the sentence above 1. Use a CRUD to create partial data. 2. Create a form, and using the "List Grid" to pull and insert the partial data into the form, then adding additional details. 3. My colleague want to see the complete details (all value from the #1 & #2)

03 Apr, 2019
confluenceUser
confluenceUser

Here is a technique you can use to achieve this. First, for the list grid, you need to change its store binder with the Multirow Form Binder or JDBC Form Binder, so all the rows in the list grid can be stored into a DB table instead of its default JSON format. Ensure that you have a foreign key to relate the list grid data with its parent form's record ID. Then, depending on how you store the data, you can create a new datalist to retrieve the DB table/columns that stores the list grid data. Ensure that you also add a datalist filter for the foreign key because the Nested Datalist Formatter requires this. Finally, you can go to your previous parent datalist and configure your desired column's formatter accordingly with the Nested Datalist Formatter. You can refer here: https://dev.joget.org/community/display/KBv6/Multirow+Form+Binder https://dev.joget.org/community/display/KBv6/JDBC+Form+Binder https://dev.joget.org/community/display/KBv6/Nested+Datalist+Formatter

RELATED QUESTIONS

Your answer


To answer a question you'll need an account.

Print