Choices of relational select lists, based on other columns

1

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:

Here’s the Doc:

2

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

3

@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:

SCR-20240504-myim-2
SCR-20240504-myim-21722×822 84.1 KB

4

@Jannis that is totaly correct:

SCR-20240504-nafq-2
SCR-20240504-nafq-21586×662 58.9 KB

5

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

6

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

7

Thank so much, @Isebar_DE!

I’m glad everything works as you imagined.

I wish you a nice rest of the weekend.

Jannis