Limitation of dataset for a report

Hi Appsheet,

Is it possible that there is a limitation on how many rows a report can run?

I’ve made a report that change data according an action that [Trigger]+1
The report is working all fine when I just select a couple of rows, but for a large amount of rows there is no change.

(I want to update my ref columns of all the rows once a week at night!)

Greatings,
Bram

0 7 520
7 REPLIES 7

I would recommend looking at the Log entry for the run of the report to see if there were any errors reported. You can get to the log by opening the workflow and tapping on the Log button in the header.

If that doesn’t prove helpful then we would need to drill in and analyze what’s going on.

There is a limit on the total execution time for any individual Report invocation.
If you are updating thousands of rows you might exceed that time limit.
You may need to break the work up into separate Reports that each update a reasonable number of rows.

Thx … it’s exactly that what happens: error exceeding time limit…

When I split the actions in different parts and put it in one report it’s working fine.

Nevertheless, this means a lot of copy and formula’s

Bram

How do you mean break them up? Meaning separate apps? I built an app that is built to do one thing - run reports. I needed something to email my users when a new dispatch ticket (from my table) is created. I couldn’t use Workflow rules - as the users are NOT going through the app or any Appsheets app. The table changes without hitting the Appsheet server. Anyway, i had to set up a report every 5 min. IT is basically the same report - but set at 5 min intervals. So, i have about 155 reports in this app.

The report checks [Closed Status] - if it is “Open” then it fires emails - based on my user email table ( i built):

Example of one report. FYI - [Adjusted Time] is because i have an API built that the time was off by 6 hours - so i built a ref column for that. In the “condition” i look for two things:
[Closed_Status] = “Open”
[Adjusted Time] <= (Now() - “000:07:10”)

Reason is so when the reports run it checks back 7 minutes and 10 seconds. It is basically overlapping by 2 minutes and 10 seconds. I had to do the extra 2 minutes because even though i have a report every 5 minutes - i was missing some rows - meaning it wasn’t catching them. I suspect a time server problem, but not quite sure.

Sorry for the extra work required on your part.

Our reason for imposing the execution time limit is to avoid having any single application using so much time that it impedes other users.

Trying to avoid the extra work,I would consider two things:

  1. Can you do the updates in small doses? For example, run the report each night but update only a small portion if the records.

  2. Running it once a week at night, sounds like maintenance work run to avoid times when the system is busy with user activity. Maybe a backend process that runs off the AppSheet platform is better suited to the task, e.g. using Google Scripts or a database stored procedure/script depending on your datasource.

Just some ideas to consider.

It is indeed maintenance work on my main table.
My main table automatically records data from another table with reference.
However, when the user makes a subsequent change to the other table, the system does change the ref column, but all [refcolum].[column] is not changed.

That’s why I’ve set a trigger that adds a column once a week, so that all the appformulas will be required to reset.

The trigger only works when the relevant column is empty, which limits the dataset a lot.

The idea of doing it with google sheet, it seems to me interesting to investigate too …

Bram

Top Labels in this Space