Single Value

I select to get the last value. However, it showed me the first value.

I believe it’s showing the same number because it’s acting as “1 unit”, so the Get Single column can’t tell the different from start to end.

Create another column using the “Split Text”, select the original column as the target and delete the comma that is placed in the text field. This should automatically separate all letters/numbers into individual selections, then change the Get Single target to the new column and set to “Get Last”.

If I’m understanding your layout correctly, this should fix your issue.

That seems like a bug, but first I want to ask what type of data source you are using for your tables?

Also, in your case you may want to use a Rollup → Max instead. If your goal is to get the greatest number, your rows may not be in numerical order for some reason, so a Rollup will be safer.

3 Likes

Not sure what you mean by this, I think OP is targeting a full column and that’s the correct use?

1 Like

I thought he was trying to get the very last number in that column, I must’ve misunderstood.

Yeah, but that’s the correct use of the single value column from what OP showed, so I thought it might be a bug.

2 Likes

I gotcha, I must’ve just misread the layout of the image. I thought since the numbers aren’t separated in any way, the first value would also be the last value (the entire number).

I was under the impression that GSV would treat the number in the “Next #” column as 1 complete entity since there’s no separation, but perhaps I have a big misunderstanding of the use case.

I see now that they are just trying to make sure they get the last row created to view the most recent number entry, sorry about that.

1 Like

A Single Value column can be used in two ways.

  • If you point it at a column within a table or relation, then it will look at the values in all rows in that column and return a value from only one of the rows.
  • If you point it at an array column in the same row, then it will return only one of the array items.

Maybe you are confusing it with the use when looking at an array column, however in this case it’s a basic column and it’s looking at all rows.

2 Likes