I have a table of events, sorted by their start time, and filtered to hide events whose end time has passed. In the table, this is working, so the first event in the table is always the next event, or the event that’s currently going on. I’m trying to create a variable outside of the table that gra…

Dear @Bon_Champion , I hope https://coda.io/formulas#Sort will give you the right direction :bulb: Best wishes for 2019 :stars: //JP

I have a similar piece of functionality in one of my projects. I use .min(), which isn’t dependent on the sort order of the rows.

.First() still doesn’t return the first row in a sorted table. Can someone from Coda explain how it’s supposed to work? Why do we need to duplicate complex sorting rules in formulas, when we’ve already got our table sorted?

Hi. Very short contribution. If I have to deal with getting sorted data quickly (especially the first information), honestly I often use Rank() function and refer to Rank rather than “first” [image]

Thanks, I didn’t know about .Rank()! Still doesn’t work though… I do Rank(thisRow, [VIEW NAME]) but the numbers it outputs are not right. The first row is ranked “2”. I must be getting something wrong? Edit: I would upload a screenshot but I get “Sorry, an error has occurred.”

Here is a very generic use of rank with numbers ranking, but it works also with alphabetical or dates. You’ve got to compare the current value (in my example Name) to thisTable values for the same parameters. Try this and let me know [image]

Thanks for helping me! I tried that (would never have guessed the formatting…) and it looked like it worked but… I have a filter toggle in place (basically “show client projects only” on/off) and the ranking works when that filter is on but not when it’s off. I still can’t upload images here (?!) …

I even tried this [image] Visual Position of the row in table Tips and Hacks Hi, here’s a tip to calculate visual position of the row in table -(if rowid, rank does not work for your case AND if you dont have ‘SORT’ applied) as you can see in image, visual position alwa…

.First() not returning the first row in a sorted table

Bon_Champion January 2, 2019, 5:21pm 4

Sort worked! Still curious why First wouldn’t return the first displayed row. The documentation could definitely be clearer in this regard.

Table.First() not returning a row?

Topic		Replies	Views
Table.First() not returning a row?	8	2080	April 27, 2021
thisTable.find(thisRow) Not Working?	13	854	September 18, 2022
Visual Position of the row in table Tips and Hacks	33	11962	June 26, 2023
thisRow = View.Last() does not respect sort order Bugs	4	1381	February 28, 2021
Cant filter rows, first row = all rows	3	143	July 8, 2024

.First() not returning the first row in a sorted table

Related topics