Screen Refresh After Editing Table Record

App Building
1

I'm working on a dashboard with a MongoDB backend. The majority of the data is read from the Mongo collection, but two of the columns are editable through the Retool table. Everything works properly - users can edit the correct columns through the table. The issue is the view doesn't seem to 'refresh' properly. If a user enters a value in a cell, the cell shows blank until the browser is refreshed. Same thing if they edit/clear an existing value.

Any ideas how to get the table/cell to refresh as soon as the change is made?

Grabbing the row ID so we know what row to edit...

image

Triggering the update query...

image

Update query...

image

Clearing the change set...

image

2

Hey @BenBeJammin

You should trigger the query to fetch data for the table whenever an update query modifies the data. Alternatively, you can refresh the table upon the successful execution of the update query.
image

image

2 Likes
3

Oh my gosh, thank you.

I spent so much time trying to figure something out. I can't believe I didn't think of that sooner. :joy:

1 Like