How to use bulk actions to select specific table row data to export to Excel?
Application Type
Reactive

I created a table and I would like to select some of the records to export to Excel. Are there any methods to do this without using any plugin in Forge?


Thank you very much.

Solution

Hi Lena,

It can be achieved logically via Outsystems itself instead of any forge component. Please make use of the OML for reference.

Please find the URL : https://saravanan-gamechanger.outsystemscloud.com/TEST/Bulkactions?_ts=637562736612876475

TESTBulkActionExcel.oml

Hi Saravanan

Thank you so much! This is what I want to do. I just tried, it works!

Regards

Lena

Hi Saravanan

One more question, if I would like to customize the export to Excel, what should I do? I try to add the aggregate and List to Export,  if it runs like this, the download selected function will fail to do so.

Thanks!!!

Regards

Lena

what your trying to customize ? could you please explain in brief.

Hello Lena,

You can create a Server action with input as record list of your table.

and inside that action use the record list to excel widget of outsystems.

and then use download widget for getting the excel file.


Refer this link for further reference:-

https://www.outsystems.com/forums/discussion/47682/download-xls-file-on-the-fly/


Thanks,

Krunal

Hi Lena,

I believe you need to put the filter into the aggregate to filter the records from your table (entity) and then pass that record list into the excel record list  to get it downloaded.

Please refer the below link to know how to download the data into the excel.

https://success.outsystems.com/Documentation/How-to_Guides/Data/How_to_Export_Entity_Data_to_Excel

Thanks & Kind Regards,

Sachin

Solution

Hi Lena,

It can be achieved logically via Outsystems itself instead of any forge component. Please make use of the OML for reference.

Please find the URL : https://saravanan-gamechanger.outsystemscloud.com/TEST/Bulkactions?_ts=637562736612876475

TESTBulkActionExcel.oml

Hi Saravanan

Thank you so much! This is what I want to do. I just tried, it works!

Regards

Lena

Hi Saravanan

One more question, if I would like to customize the export to Excel, what should I do? I try to add the aggregate and List to Export,  if it runs like this, the download selected function will fail to do so.

Thanks!!!

Regards

Lena

what your trying to customize ? could you please explain in brief.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.