Table edit doesn't save even though says success

[Topps42]

• Goal: Edit table and save the data

• Steps:

1. Table is hooked up to postgres and is displaying data.
2. Column I'm editing is marked as "editable"
3. Editing query is set up using GUI query with following configuration:

Action type: Bulk update via a primary key
Primary key column: id
Array of records to update: {{ table1.changesetArray }}
Run behavior: Manual

4. Connect Save Actions Add-on to the script
5. Edit column and click save

Expected Result: changes to column save. Notice of pending changes disappears.
Actual result: changes do not save. Notice of pending changes shows 1 pending change.

• Details: Been having a hell of a time just getting basic editing working. I've gone through these guides: Editable table columns, Bulk updates

I think I have everything set up together, and the logs show that the script ran successfully, but the data in the table doesn't change.

• Screenshots:
  Bulk edit configuration:
  
  

Save Action trigger:

Table I'm editing:

Console showing success:

[ZeroCodez]

Hi @Topps42, you can use tableName.refresh() after the update query succeeds.

[Topps42]

Where do I put that code? Also, when I refresh the whole page the data hasn't updated, so not sure it will help.

[ZeroCodez]

Upon the query's success

[Tess]

@Topps42 did that resolve it? If not, what does {{table1.changesetArray}} evaluate to?

[Topps42]

Yep, looks like the table refresh works! Thanks