Hi ya'll - investigatory question here...
I was hoping to find a way to do this in desktop...but somebody mentioned that JS might be a better direction for this, so I'm trying to do some research on that.
In short: I am trying to do this:
Filtering to show the next row in a sequential list when I refresh.
For this data hosted on Public
I would like to find a way to iterate through each row in the below sheet using a refresh command (F5 in desktop - but any designated key would work) and the INDEX() value.
So..refresh 1.. returns 'Show'=
refresh 2... returns 'Show' =
refresh 3... returns 'Show' =
... A resource hinted that using that I might be able to use the JS api + parameters in the URL to manipulate the URL on reload, so that it increments when a user reloads the browser page. Does this sound like something the JS api could handle (are there any examples of this anywhere you can think of?).
The community team is going through older posts that never received an answer and following up. Are you still searching for a solution to this question? If so, let us know. Otherwise, please share what you've found!