75
Views
9
Comments
Pivot Table
Question
Hi all,

I need to create a "Pivot Table" like Excel does on a WebScreen. Does anyone have done anything like it? The main problem is how to reproduce non static columns on a Table Record Widget.

Thanks in advanced,

Nuno
2019-03-21 11-53-43
Duarte Gouveia
Hi Nuno,

In order to create, dynamically, columns within a table you can use the attached extension DynamicTableRecords.xif.

This means that you won't be using a table record but an unescaped expression. This expression will be filled in with the result of constructing the HTML table 'manually' with this extension's help.

Since you have to 'build' each cell one by one, you can add specific HTML/Javascript code that will render the appropriate object...

This is not 'built-to-change'... :(

Best regards,

Duarte Gouveia
2023-02-20 18-02-29
Nuno Baptista
Hi Duarte,

Can I see the attached extension DynamicTableRecords.xif :) ?

Thanks,

Nuno
2019-03-21 11-53-43
Duarte Gouveia
It seems that I didn't uploaded it...
DynamicTableRecords.xif
UserImage.jpg
Pedro Ventura
Hi,

Can you show us how we use the extension?

Thanks
2019-03-21 11-53-43
Duarte Gouveia
Here it goes (free of charge... for now :D).

Duarte Gouveia
DynamicRecordsSample.oml
UserImage.jpg
João Campos
Hi!

Can you use the BuildMetaTable Action to retrieve the HTML table after? If yes how can i do it?

Thanks in advance.
UserImage.jpg
Sunil Mane
Hi Duarte,

can you please provide that osp in version 6.0 or advance version.

Thanks in advance.

2024-12-17 14-32-59
Matthias Preuter
 
MVP
Has anyone worked on a Pivot solution?

Kind regards,
Matthias
2013-05-09 08-37-44
António Braz
Hi,

while testing this I upgrade to 8.0.1.
DynamicRecordsSample.oml
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.