How to detect change in a value?

I have a column whose values get reshuffled on entering into an inline list, and also gets reshuffled on coming out of an inline list. How can I detect that the values in the column has changed? In other words, how do I create a column that can detect if a value in another column has changed or not?

Presumably you’re looking to detect the change in the Glide Table, and not in the Google sheet, yes?
Also, I guess it’s safe to assume that these changes happen as a result of a user doing “something”. ie. tapping a button or similar?

I could probably come up with a way to do it for a single row, but an entire column might be a challenge. If an entire column, what would you expect to happen if some values change, but not all?

1 Like

Yes, change in the glide table. The change happens when user clicks on an item in an inline list which is linked to an action Reshuffle. It has to happen only in a single row. And going back from the inline list does the Reshuffle action again. Any other action can also be tried.

Okay, so just thinking out aloud here…

What you could probably do is have a User Specific Column, and set the value in that column to be the same as the column you want to “watch”, just before the reshuffle action. Then have an if-then-else column that compares the values in the two columns. Something like true if they are the same, or blank if not. Then if the value of the “watched” column changes as a result of the reshuffle, this should be reflected in the if-then-else column.

2 Likes

Thanks for the idea. Here’s my use case which I am trying to use the above idea. Now, I feel it may not be possible with the above idea.

I have an inline list. When user clicks on one item of the inline list, I have an action which sets the value in a Status Column to Online. When the user comes out of the inline list, I want to detect that the user is currently not inside the online list. There is no action linked to the Back arrow to come out of an inline list. Is there some other way, I could detect this and make a change to the Status column?

What you could do is use CSS to hide the back button, and then add a custom back button to the Inline List details screen. When the user taps that button, you can have a multi-step action that checks the status, makes any necessary changes, and then finishes with a “Go Back” action.

You can hide the back button with the following CSS:

<pre><span><style> 
[data-test="back-button"]
{ display: none }
3 Likes

Awesome! Thank you much! CSS to hide the back button is a great idea.