Create numeric order in glide sheets

[Drearystate]

I think it would be almost as easy as flipping a switch from the compund actions button press. Think about it, the code is already there for the trigger to exist if a button is pressed. The same code can be duplicated and setup to trigger if criteria is met, thats all the button press is a crteria of the button being pressed.

[Manan_Mehta]

Yes this could be a game changer for so many things. Especially this specific use case.

[Jeff_Hager]

That would be awesome!

(This response applies to both or your posts @Drearystate, @Manan_Mehta)

[Food2Soil]

Its been a while since this idea was discussed so wondering if there’s a way to do ranks or increments based on certain conditions. Here’s my use case.
I have a list of 25 locations (say Location A- Location Y) ordered by a column 'Route Stop #‘s’ (1-25). So the google sheet looks like this:
Stop # Location Name
1 Location A
2 Location B

Some locations are on or off the route for the week. I want a dynamic column which generates another number based on where that location falls on that week’s route. For for e.g. Say location B which is master route stop # 2 is not on this week’s route. In that case I want a dynamic column which assigns #2 to Location C.

I’m sure there is an elegant way to do this. Am hoping someone can help. Thanks in advance!

[Robert_Petitto]

I don’t quite follow your route use case, but this is one the simplest ways to add an auto increment.

@Darren_Murphy

It works like so:

• Create a bare Glide table to use as a helper table
• Add a RowID column
• Add a Lookup column that targets the RowID column. The result should be an array of RowIDs.
• Use a Find Element Index column to find the RowID in the RowID array. This will give you an auto-incrementing Row Index.
• Add your Image array using a Single Value column, or relation + lookup column.
• Now use a Single Value column to address the Nth from start of the image array, where N is the row index.

[Darren_Murphy]

yeah, if I’m understanding the use case correctly then a variation of that should do it.

@Food2Soil - assuming that you have a boolean column that defines the status for each stop (in/out), then all you should need to do is create a relation to your list of Stops (using the boolean as a filter), then add a lookup to create an array of StopIDs via the relation, then expand the array using the RowID/Single Value method.

If you then need details related to each stop, you’d create a single relation back to your stops table, and add whatever lookup columns are necessary.

[Food2Soil]

Thankyou @Darren_Murphy and @Robert_Petitto for your help. Both solutions worked!

[Janeer]

Good examples, I also had some problems with numeric order in Glide. Now all is fine. Thanks!
new project more