I posed a question about whether there is an expression that will give you the “key” to the next record in a UX that has been shuffled according to a value in the spreadsheet. @LeventK indicated that JavaScript has an IndexOf function that does that task but that there isn’t a single expression in AppSheet that does the same work. After thinking about the matter, I came up with a solution that combines the following currently available expressions:
Select()
Orderby()
Index()
If you think such a work around might be useful to you, please see that solution I posted to the original thread.
Continuing the discussion from An expression for "next record" in a shuffled slice:
User | Count |
---|---|
42 | |
33 | |
24 | |
23 | |
14 |