Updating a data table with excel in run-time

Updating a data table with excel in run-time

  

Hi Guys


I have an application that has tables updated (excel files) by users at runtime.

I have built the logic to validate the upload and this works but my problem is that I have aggregates that fail after the load is complete. 

It's as if the applied filters have been disabled - but as soon as I check the test inputs and refresh them in the aggregates work again.        

Hi Craig,

Can you please elaborate more and illustrate with pics of your code?


Cheers,

Tiago.

Tiago Gafeira wrote:

Hi Craig,

Can you please elaborate more and illustrate with pics of your code?


Cheers,

Tiago.


Hi there, 

here's a link to my original post about the Upload (for context) 

https://www.outsystems.com/forums/discussion/37216/uploading-excel-report-in-the-frontend/

so my error is subsequent to this process... Now that I have the upload working --> the tables all show the relevant updates, but the calculations/aggregates that are derived from those tables fails to execute after an upload