Conditional Dropdown Error

  • 38
  • 1
  • Question
  • Updated 3 weeks ago
  • Answered
  • (Edited)
Everything was working fine but now I'm getting an error. The table has not had any changes in months so it is weird how the conditional drop-down has stopped working.




Photo of Michael Curtis

Michael Curtis

  • 596 Points 500 badge 2x thumb

Posted 3 weeks ago

  • 38
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,702 Points 50k badge 2x thumb
Can you post a clearer shot of the pop up purple message?
Photo of Michael Curtis

Michael Curtis

  • 596 Points 500 badge 2x thumb
Here it is. The weird thing is System Sting Type (P) has a value and I have many of these drop downs currently working.


Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,702 Points 50k badge 2x thumb
Is that [System String Type (P)] field visible on the form?
Photo of Michael Curtis

Michael Curtis

  • 596 Points 500 badge 2x thumb
Yes it is I just moved it right next to the drop down.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,702 Points 50k badge 2x thumb
Does it fail on all records or just 1 record.  ie,  is the failure "data dependant"
Photo of Michael Curtis

Michael Curtis

  • 596 Points 500 badge 2x thumb
All records, when I go back to old record to try an edit the field it has the current option in red. It's working of a relationship string called "System String Type" maybe it is safer to go with a number.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,702 Points 50k badge 2x thumb
It's always safer to based the CDD on [Related Parent] (typically a numeric field), than a text field.
Photo of Michael Curtis

Michael Curtis

  • 596 Points 500 badge 2x thumb
Very weird I duplicated the field and the duplicate works
Photo of Michael Curtis

Michael Curtis

  • 596 Points 500 badge 2x thumb
The issue was the field existed in two spots and was throwing an error because of both of them having the same ID on the elements.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,702 Points 50k badge 2x thumb
So the field on which CDD was based the field was on the form twice.  so when that happens the "last" appearance of the duplicate field will win and it would have been blank.