Conditional dropdown based upon a calculated field

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
I am a new Quickbase user and would appreciate any direction on limiting a dropdown's choices based upon a calculated field in the same table.  Hiding a field using dynamic form rules will not affect the dropdown, so that won't work.  

I setup a full conditional dropdown with three tables using the help screens but then tried to redirect the conditional field to a formula field on the same table and the logic worked.  Unfortunately the user gets an error message saying that the conditional field must be entered (even though it is calculating correctly).  It seems that a conditional dropdown needs to refer to another manually entered dropdown, not a formula field.


Any help would be appreciated

Thanks, Ron
Photo of Ron

Ron

  • 50 Points

Posted 3 years ago

  • 0
  • 1
Contact me off line via the info in my profile and I will have a quick look at your app.
I spoke to Ron and all is good now.
Photo of Ron

Ron

  • 50 Points
Mark was very helpful, I highly recommend him.