Choices of relational select lists, based on other columns

[Isebar_DE]

Hello everybody,

I’m trying to display messages in a column based on a select list choice of the column in front.
→ But the choices inside the select list, need to be filtered by the values of the cells infront of the select list.

I did make a video to explain it better:

Relational tables new

Here’s the Doc:

[Jannis]

Hi @Isebar_DE,

I’ve improved your data structure a bit and did the changes you described.
Please review your document and let me know if this is how you envisioned it.

Best regards
Jannis

[Isebar_DE]

@Jannis so i think some of the improvement makes a lot of sense, but i still have to wrap my head around it.

But the filtering isn’t working correct yet:

[Isebar_DE]

@Jannis that is totaly correct:

[Jannis]

Hi @Isebar_DE,

you are right. I forgot to add a second filter, sorry.
Everything should work as expected now.
Please check your doc and let me know if anything works as you want it to work.

Best regards
Jannis

[Isebar_DE]

@Jannis this is it. It’s actually more than i asked for. You are my weekend hero!

[Jannis]

Thank so much, @Isebar_DE!

I’m glad everything works as you imagined.

I wish you a nice rest of the weekend.

Jannis