Hello,
On our table, we have an interaction: Table > Interaction > Default sort by > date > Ascending
When the resource (google sheets) is updated, the retool table is not updating the order. You have to click the column twice (to change from ascending to descending, then back) in order for it to update. Why is this?
It seems like a querying issue that should be done by default. Can someone confirm how to fix this?
Thanks,
Hello @stxvc,
The default sorting mechanism in Retool does not automatically refresh when the underlying data changes. Sorting is only applied when a user interacts with the table, such as clicking a column header to toggle the sort order.
To resolve this, you can use the query1.trigger() method to re-trigger your query whenever the Google Sheets resource is updated. This will reload the data and reapply the default sorting as intended.
I hope this solution addresses your concern.