Dropdown list content depending on formula

Good morning,

This is a follow-up on my previous question :
View a field based on assigned to

I'm using the formula to show a dropdown field based on the assigned to
isInList(related($assigned_user_link,"last_name"),createList("Last Name of the assigned user"))

However I would like to go a little further and have the choices of the dropdown list to change depending on the assigned to.
For example :

If assigned to Bob, then dropdown field offers the choices "A, B, C"
But if assigned to John, then dropdown field offers the choices "C, D, E"
etc.

Any idea how to achieve that?

Thanks!

Parents

0 André Lopes 2 months ago
That said, you can split this implementation in 2 steps:

To create a dropdown field having user names as keys/values, to be updated as per your previous formula

To create a secondary dropdown whose depends on the 1st.
André Lopes
Lampada Global

Skype: andre.lampada
0 Yves Bourgarel 2 months ago in reply to André Lopes

Yes, that was my thought as well.
I wanted to check if i could do everything in one step, but perhaps we can't.

So i can make another calculated field that would indicate 1 if assigned to Bob, and 2 if assigned to John.
Then my dropdown list will be based on the 1 and 2

Reply

0 Yves Bourgarel 2 months ago in reply to André Lopes

Yes, that was my thought as well.
I wanted to check if i could do everything in one step, but perhaps we can't.

So i can make another calculated field that would indicate 1 if assigned to Bob, and 2 if assigned to John.
Then my dropdown list will be based on the 1 and 2

Children

No Data