0

Filter Choice (Dynamic)

RoSoft_Steven

Fred

Hi I have the table with 5 field Choice Dynamic each for one Level of the WBS.

All 5 field are Choice Dynamic , each deliverable an Budget is associated with your Level

I need two know how I Filter each level ? Where the formula works

10 replies

null
    • Fred
    • 2 yrs ago
    • Reported - view

    Can you provide a sample code you are working with?

    How is this different than your previous post?

      • Rafael Sanchis
      • Rafael_Sanchis
      • 2 yrs ago
      • Reported - view

      Fred 

      Hi Fred Now I need Filter for Level (Any Level) for example I need View  only the Deliverables Hidráulica Level 4 or Deliverables Ingeniería Basica Level 3.

      All Level 1 to 5 are Choice Dynamic.

      The all previous post you help me with a Formula for calculate the budget for each level of Level.

      WBS Table SetUp all the levels

      And in the Delivery table I select the deliverable for the  WBS 

      Thanks

      WBS_19_Julio.ninox
    • Fred
    • 2 yrs ago
    • Reported - view

    Ok, I'm looking at your DB. Can you walk me through what you want to do?

    What table are you in?

    What View are you talking about?

      • Rafael Sanchis
      • Rafael_Sanchis
      • 2 yrs ago
      • Reported - view

      Fred 

      Deliverable Table ( is where I have all Deliverables for each level wbs.

      Need to Filter Deliverables for example Level 3 Reconocimiento 

      Or Deliverables for example Level 4 Hidráulica 

    • Fred
    • 2 yrs ago
    • Reported - view

    Ok, I'm not sure where you want to filter. Is it in a formula? or table?

      • Rafael Sanchis
      • Rafael_Sanchis
      • 2 yrs ago
      • Reported - view

      Fred 

      Example I need the Deliverables Level 4 obras Electricas.

    • Fred
    • 2 yrs ago
    • Reported - view

    I get the issue now.

    When you have a cascading dynamic choice field (dC), Ninox can't properly execute the code in Level 2 - Level 5 to create the lists since it is dependent on what is selected in Level 1 and at the table level you see all records. And since they are choice fields there is no way to type in text to filter.

    One way I can quickly think of is to create another formula field with the text function: 

    text('Level 2')

    Then you can put that field in the table and then you can filter it.

      • Rafael Sanchis
      • Rafael_Sanchis
      • 2 yrs ago
      • Reported - view

      Fred Thanks Fred.

      That is a Ninox issue or is that the DB is no well design. 

      Regards

      • Fred
      • 2 yrs ago
      • Reported - view

      Well I would say that it is a limitation of cascading dynamic choice fields. 

      I don’t think there is anyway for Ninox or any DB to figure out all the possible combinations that the cascading fields could be at the table level.

      • Rafael Sanchis
      • Rafael_Sanchis
      • 2 yrs ago
      • Reported - view

      Fred Thank

      Now I think is better work with 5 Tables and use the Constraint, how I use in other DB but 4 level.

      ok thanks again.

Login to reply

Content aside

Categories

View all topics
  • Status Answered
  • 2 yrs agoLast active
  • 10Replies
  • 153Views
  • 2 Following