Feature requests from a newish user
Good morning all! I'll start by saying if there is somewhere better to put feature requests, I will happily submit this through a formal channel! I have been building out a new system on Quickba...
Forum Discussion
I suggest making a table of facilities with the Key field set to Facility Name a relationship to select a to choose the facility. You can then use the existing field to build the relationship to preserve the existing data. The record picking when you have such a drop down field is excellent as you can enter small part of the words for the choices and the drop down will pretty instantly filter down.
So I think that the QuickBase developers might argue that you were trying to misuse a multiple choice field when you're trying to get more than 100 choices. They are never likely to expand that limit.
I'm not quite sure what you were doing with the pipeline but using this method you may have to have your pipeline add additional records to the facilities table.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
So I think that the QuickBase developers might argue that you were trying to misuse a multiple choice field when you're trying to get more than 100 choices. They are never likely to expand that limit.
I'm not quite sure what you were doing with the pipeline but using this method you may have to have your pipeline add additional records to the facilities table.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Thanks for the response, Mark! What you said makes sense. The reason I did it the way I did is because my Facilities table had more columns than facility name, but I wanted user selection to only be the facility names. I didn't recall seeing an ability to make the record picking work in this way, but if it's possible I'll take another look.
Regarding the 100 item limit to select boxes, I am still not sure whether the limitation actually does anything, particularly if it's a field pointing at another table. All across the web we have select boxes with far more options. Additionally, my select box does have over 100 items in it since I have it point at an empty table for values, then use a pipeline to build out that table, so the 100 limit is not truly a hard limit within Quickbase. It seems to exist just to exist. Ultimately, not a big dealbreaker for me!
But like you said, perhaps the record field is the better tool for this, so I will check that out. I appreciate your feedback and the guidance you provided as it relates to the proper way to submit feedback as well as the pain points I mentioned in the original post!
------------------------------
Josh Payette
------------------------------
Regarding the 100 item limit to select boxes, I am still not sure whether the limitation actually does anything, particularly if it's a field pointing at another table. All across the web we have select boxes with far more options. Additionally, my select box does have over 100 items in it since I have it point at an empty table for values, then use a pipeline to build out that table, so the 100 limit is not truly a hard limit within Quickbase. It seems to exist just to exist. Ultimately, not a big dealbreaker for me!
But like you said, perhaps the record field is the better tool for this, so I will check that out. I appreciate your feedback and the guidance you provided as it relates to the proper way to submit feedback as well as the pain points I mentioned in the original post!
------------------------------
Josh Payette
------------------------------
