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

.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.

2 Likes

Table.First() not returning a row?

Topic		Replies	Views
Table.First() not returning a row?	8	1841	April 27, 2021
Show First Row in a Database	3	660	January 22, 2022
Highlight fist occurrence (conditional format)	8	387	July 12, 2021
Automation that only effects the first row of a table?	7	617	November 19, 2019
thisRow = View.Last() does not respect sort order Bugs	4	1224	February 28, 2021