Dear Forum Members,
I extend my gratitude for your invaluable contributions to the topic of creating a dynamic table with data fetching. In my pursuit of this goal, I've come across existing solutions on the Forge platform.
1. *Dynamic Table - Reactive:*
- Comment: This is a reactive app, but it requires building the logic yourself.(https://www.outsystems.com/forge/component-versions/16197/version/0/platform/)
2. *Dynamic Table - Traditional Web:*
- Comment: Provides a sample app, but not directly usable in a Reactive app.(https://www.outsystems.com/forge/component-overview/3669/dynamictable)
Given my unique requirements, I've navigated through the following steps:
1. Explored an alternative solution for Reactive since the traditional web solution is not directly applicable.
2. Derived insights (logic) from the provided sample app in the Traditional Web solution, as Reactive lacks a sample.
3. Focused on key considerations: Database structure, Interface (Web Block-wbDynamicTable - JsonDeserialize), Interface (Web Block-wbDynamicTable - stylesheet).
4. Created a list of local variables on the screen and established logic in (OnReady).
5. Attempted modification for data fetching from the database and populating cells, encountering challenges. This leads to my questions:
*Questions:*
1. How can I successfully fetch data from the database and display it cell by cell?
2. Is it possible to incorporate checkboxes inside the cells?
I appreciate your patience and assistance in helping me navigate through these challenges.
I already attach the oml file, complete version is in screen 1 and 2.
Best regards,
Martin
@martin woon to do this you need to first make a list of header. i my self have the functionality in the grid is that whenever there is new department added that will shown in the grid as a new column.
so my approach that works is that
first i created a list in which only the header name will come and i iterate that list on the header section.
second used the same name so the grid can match while binding the values.
Hi Martin Woon
Are you using the grid for displaying the table.
Hi Yashpal,
Not sure about that, cuz i still figuring out this solution.
But the outcome is like that, and the logic that i create is like this:
Additional information:So far, the table that modified based on my needs is look like: the more specific question is:1. how should i display the name 1 by 1 (Like the queue(first in first out) or Like the list or table that in the outsystem)2. Can my LineDetail cell display the checkbox featues?
Below has the latest oml file.