Set the value for new rows in a column Select List from a lookup table

1

Hi,

I’m wanting to set the value for new rows in a column Select List where that values come from a lookup table. I want the value come from the last item in the list.

I tried “List([lookup_table]).Last()” but that returned the full list of items in the table.

I would really appreciated it if anyone had any thoughts on the mater.

Cheers

Tony

2

If I get what you’re saying, I think you were very close to the solution already — just remove the “List()” wrapper on your formula: [lookup_table].Last()

[lookup_table] is already a list of rows, and there is no need to wrap it with List().

In fact, List([some table]) returns a list with one element, ie, [some table]. And taking Last() of that list will return the last (and only) element of the list, the whole table.

3

Hey, thanks @Ryan_Martens2, that solved my problem perfectly.

Cheers

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.