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!

0 André Lopes 3 months ago

It is possible with Dependency SetOptions.

André Lopes
Lampada Global

Skype: andre.lampada
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel
0 Yves Bourgarel 3 months ago in reply to André Lopes

Thanks André,

However this seems to be code related no?
I do not have access to the code, I'm admin but not a partner.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 André Lopes 3 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
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel
0 Yves Bourgarel 3 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
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel