Grouped Action Loop to Create New Rows in Another Table takes a long time and crashes the app somtimes

AppSheet AppSheet Q&A
1

Hello, at the request of @Steve (from this thread)

I created a new topic to describe my problem. I followed the guide there and created 4 actions

  1. Controller
  2. Increment Count
  3. Generate Child Row
  4. Loop Trigger

It’s pretty straightforward,
Controller is a grouped action to execute actions 2,3, and 4.
Increment Count just adds 1 to the Count column (that starts with 0).
Generate Child Row adds values to 4 columns, two of which uses the Count value as the index with this expression: INDEX(SPLIT(INDEX([Table List], [Count]), "."), 1) and INDEX(SPLIT(INDEX([Table List], [Count]), "."), 2).

When I submit the form, it first goes into this screen where it seems nothing is happening:

image
image1586×1010 19.4 KB

That happens for about half a minute or so.

Then sometimes it crashes, chrome asks me to “wait” or close the tab.

Then it goes to this loading screen which shows the progress:

image
image1600×1020 20.1 KB

It took more than 5 minutes to finish. I am using Appsheet DB for my tables.

What might be wrong? Also, please do tell me if you guys need more information.

More Information:

There are 2 bots attached to the control table (parent table) and 2 more bots attached to the target table (child table). Could this be the cause? because if there are 35 records to add, the bot will be triggered 70 times?

Looking at the Performance Analyzer, it took on average 6 seconds to add each row in the child table.

image
image2488×1362 244 KB

Here’s the details on one of the Add row operation:

image
image2648×902 202 KB

2

You may want to share more details about these expressions. For example, what is meant by [Table List] how is it created- what is the expression behind it.

From where the [Count] value is coming. You seem to be splitting on a “.” rather than a usual comma, “,”. So you may want to elaborate for better suggestions.

3

For the Add Operation, is it triggered from a Bot or is it executed directly from an Action ?

4

Rows were added using actions, while some of the column values were added using the bot.
I tried to isolate it, and removed the bot and only added the rows using the actions but nothing changed.

5

Table List is an enumlist which is just a list of tables, e.g. project_a.table_a, project_a.table_b, project_a.table_c, …)

I tried to re-do it but with only INDEX([Table List], [Count]) and the same thing happens.

6

Actions are processed in the Client Device, making them slow for multiple row Creations.

Whereas if the Action is called from the Bot, it is processed on the Server Side, and the Client only Syncs the changes from the Server.

Try moving your logic to the Bot if possible.

7

Thank you. However I am sorry that I am unable to add any suggestion with these details shared. I will request more details ( relevant screenshots, names of tables , columns involved if possible) .

Maybe someone else can help you with the details you have shared.