Dropdown Menu from List

User Talk Base design
1

hi,

maybe an easy question, but how to create a dropdown menu (single select) with an item list from another sheet?

Greetings Nico

2

Hi, welcome to the SeaTable Forum!

In this case, what you need is not the column type “Single Select”, but “Link to other records”. By deactivating the setting “Allow linking to multiple records”, one cell is only able to be linked to one record in the same table or from another table.

You’ll see this feature is only better than a “dropdown menu”, as it displays more information about the records you would like to select from.

P.S. - as this is not a bug, I’m moving this post to General.

3

Thank you for your fast answer!

One more thing: How to collect/display linked records in another column?

Records in Column A&Column B should display in Column C

I tried diffrent ways, diddn work

best regards
Nico

4

You are welcome!

Well, what did you do exactly?

As we have extended the functionality to quote linked records in the formula, you should specify the exact field of the linking.

For example, you could use

{ColumnA.Name}&" "&{ColumnB.Name}

to do the trick:

image
image965Ă—408 15.2 KB

5

worked! Is there a way to display each entry in a new row in the same cell? Because in the details view, i like them as a “list” Not a long sentence…

I tried

"#1 "&{Leistung #1.Leistungen}&char10&{Leistung #2.Leistungen}

greetings Nico

6

Unfortunately, this is not possible.