Details about this thread
  • State Suggested Answer
  • Replies 4 replies
  • Answers 2 answers
  • Subscribers 84 subscribers
  • Views 240 views
  • Users 0 members are here

Dropdown list content depending on formula

Yves Bourgarel

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

    It is possible with Dependency SetOptions.

    André Lopes
    Lampada Global
    Skype: andre.lampada
  • 0 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. Slight smile

  • 0

    That said, you can split this implementation in 2 steps:

    1. To create a dropdown field having user names as keys/values, to be updated as per your previous formula
    2. To create a secondary dropdown whose depends on the 1st.
    André Lopes
    Lampada Global
    Skype: andre.lampada
  • 0 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