Table add-on event handler loading infinitely

[Sasha_Korovkina]

1. My goal: my goal is to make edits to rows within my table and save them, through a table add-on with an event handler.
2. Issue:
   I have the following table add on:

And the following event handler associated with it:

This triggers a query, which runs successfully, but my add-on stays in the loading state permanently, like so:

[Shawn_Crocker]

Did you get help on this?

[Henry_Bates]

UPDATE - The add-on now exits the loading state, however we are unable to click into & edit any of the rows once the event handler has ran.

[dr_abe]

Have you tried tying a table refresh on/after the event handler has ran?

[Henry_Bates]

We have tried adding a table refresh but the issue still persists!

[Sasha_Korovkina]

On the above, when I enable table refresh and reset the table state through the interface (see screenshot below), the issue resolves and the row is updated and is editable.

Is there a way to programatically update the state of the table though JS in Retool?

[Jack_T]

Hi @Sasha_Korovkina,

Apologies for the issue. I am still very confused as to why the table UI is giving you an infinite spinner when you try to save.

Does the onTxChange query run and finish? If you are able to join our office hours, the team and I can further trouble shoot as to what could be causing this to happen.

For short term work arounds, you could try table1.refresh() and that should run the query to fetch the table data from the DB.

If the row is updated after you click the GUI to hard refresh, then it sounds like the onTxChange query is successfully updating the DB, do you have attached to that query in its On Success event handler to fetch the query to fetch the fresh DB data for the table?