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	17	1140	March 3, 2023
Quick way to get to the bottom of the table	3	1001	July 8, 2019
Adding info from the row bellow in a table	6	926	March 4, 2022
How can I filter by the last row added?	6	1166	March 22, 2023
Set the value for new rows in a column Select List from a lookup table	2	485	February 9, 2022

Projections With Last & Slice

Related topics