The video above doesn't contain the latest updates to the Single Value column. We will update the video soon – but you can read about these below.
The Single Value column lets you display the same value for every row in a table. The source of that value can be from any other table, from a Multiple Relation or Query in the same table, or from an Array in the same table.
The first dropdown allows you to choose where in that source the single value will be retrieved. You have the options of:
- First = get the first or topmost value from the source
- Last = get the last or end value from the source
- Random = get a random value from the source
- From start = get a value X number of places from the start of the source
- From end = get a value X number of places from the end of the source
From start + From end
With From start and From end, you can add a row value, such as '2' rows from the start👇
Or you can choose a column value for the row and therefore the single value will become dynamic. In the image below you can see on the far left, we have a number column. In the Single Value Column we've chosen this column for the Row number.
Anywhere the value is 0, the Single Value chooses the top row from the source. Anywhere the value is 1, the Single Value chooses the second row from the top... etc.
Whole row
The Single Value column can also bring back the Whole Row as opposed to just a single value. This allows it to act somewhat like a Relation Column.
