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 displayed for every single item. The source of that value can be from any table in your app or any multiple relation in the current 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.
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. When we change the option to Whole row – we can then display that 'value' in a Relation Component.