Hey- I’m trying to get the most recently added value in a table so that multiple stakeholders can see where a process was left off. I’m able to do this with =[Table].slice(-1) or =[Table].last() Both of these have the issue, though, that the result shows up as a projection but does not allow for p…

@chris_homburger actually was just reminded that you can use [Table].[Column].Last() and achieve the same result here. Should simplify things a bit!

Interesting @chris_homburger - let me see if one of our engineers can take a look. As a workaround, this actually works if you name the [Table].last() formula (“Last Call Added” as example), and then reference with the formula [Last Call Added].Value.Column.

@evan that is interesting—thanks! I found out your workaround is effective with =[Table].last(), but not with =[Table].slice(-1). I assume that’s something to do with the value type that slice() returns?

Weird - slice() does return a ref, but for some reason we’re not parsing it that way. We identified a potential mitigation on the eng side, but I’d stick with the named formula workaround for now if that works!

Ah, that’s even more elegant. Good catch, thank you!

Projections With Last & Slice

Jason_Tamulonis December 5, 2019, 6:44pm 7

@chris_homburger I wanted to let you know that we fixed the issue you were hitting. I’ve added some more detail here: Update: Formula Improvements - Type understanding

Topic		Replies	Views
Get last n rows from a linked table	18	1088	June 1, 2023
Quick way to get to the bottom of the table	3	970	July 8, 2019
Adding info from the row bellow in a table	7	903	June 2, 2022
How can I filter by the last row added?	7	1124	June 20, 2023
Set the value for new rows in a column Select List from a lookup table	3	477	February 9, 2022

Projections With Last & Slice

Related topics