A question about the Single Value Column

I have set up a single value column that finds the value in the first row in another column and then repeats that value right down the page. (which is the normal way to use a single value column)
Now, how would i find the first value that is in any row, searching from top to bottom. (the first non empty row OR “cell”)

So for example the first word in the column is “dolphin” and it happens to be in the 25th row. I want the single value column to search that column and then when it finds the first value looking from top to bottom… repeat that word all the way down in the Single Value Column.

There are five options when setting up the single value column such as - first, last, random, from start, from end.
Is there any further documentation on how these options work and can they be used to solve my issue
Does anyone know of any other solution to my problem?

This may not be the most efficient or simplest way to do it, but…

  • Start with a Lookup column on the entire column
  • Take an Array Slice of that Lookup, returning the first element
  • Finally, a Single Value on the Sliced Array, taking the first element

1 Like

Wow i think that would work for sure. I haven’t used lookup columns much or the slice column (ever) but i’ll give it a try. From your example - the word cat is exactly what i’m looking for.
Thanks so much🤙

Okay it works… BUT!
I need the selection to come from a user specific column.
So the Animal column in your example would be a specific users choices. This “User A” selected Cat, Dolphin and Goat.
Typically, if the Animal column was set as a user specific column then the Single Value Column would also Display Cat as a choice that “User A” selected.
Since i am now pulling the data from the Slice Animals column, it seems that the user specific properties are lost in the process.
Have you got any other tricks to suggest?

No, the results should still be user specific. See below:

Hectic!! Okay i’ll check that now. My IF THEN ELSE which pulls from the Single Value Column doesn’t seem to display correctly - okay i’ll check.
Flip this will be so awesome if it works.

Just remember (or be aware) that all computed columns are calculated on each individual users device. So if you start off with a User Specific Column, then any/all subsequent columns that reference back to that will also be user specific. It’s actually impossible for it to be any other way :wink:

1 Like

Okay definitely good to know👍
With regards to the IF-THEN-ELSE column - it can’t seem to find the Single Value Column as an option in my drop down list.
Firstly could you show me the settings that you use for the splice column.
My Single Value Column that pulls from the splice column doesn’t display as greenish colour text (the colour for user specific date - i assume?)

LVL 1 SINGLE - is the typical format for Single Value Column (this is pulling from the first value in LVL 1 SELECTION - this is the old Single Value Column)
LVL 1 SINGLE copy - is the new Single Value Column (notice the Dog text is surrounded by a grey rounded rectangle? (this is the new Single Value Column)

That means it’s an array. You’ve done something wrong there. Show me how that column is configured.

This is how i set up the Splice Column - it spits out the right result but not i’ve used the right settings. What should i put in the Start and End fields?

And here is the Single Value Column settings.

I’m not sure why it makes a difference, but when configuring the single value column, you’re selecting the sliced array column from the wrong place.

You should find it near the top of the column list, without having to navigate to it via the table list…


Oh Okay let me check👍

Okay is see it, WHOOO HOOO!
It’s seems like it will all work fine🤙
I’ll give you feedback on whether it succeeds.

This is going to work ---- i feel it in my bones!!!:partying_face::boom::sunglasses:

1 Like

hehe, cool

1 Like

Okay i got it all sorted eventually. Basically it’s a dynamic user specific search, 5 category levels deep.
So only the appropriate results show up as options in the next selection. Difference being that i’m using inline lists for all the options buttons (as opposed to choice components)
So people click on the Inline list images and an action writes their choice into the data editor. Their current choice sets up the next set of choices available to them.
Really easy to navigate the multiple thousands of possibilities by narrowing down the search at each new stage of the search.

1 Like