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.
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] is already a list of rows, and there is no need to wrap it with
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.
Hey, thanks @Ryan_Martens2, that solved my problem perfectly.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.