Hi Retool community! What I would like to achieve is going through a returned data set (from a query) one by one with the purpose of verifying the data. For each (unverified) element from the result the user will click a button and update the underlying table (status to verified). Ideally we now move to the next item.
Currently I re-run the initial query to get a fresh list of un-verified items. But ideally I get all items and keep track of verified items locally so I don't need to re-run the query every time. What is the best way to achieve this in Retool? I'm new in using Retool so any push in the right direction is much appreciated!