Forum Discussion
MarkShnier__You
3 years agoQrew Legend
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
------------------------------
- MarkShnier__You3 years agoQrew LegendFor any suggestions you have about forms, the appropriate way to give feedback is that you go to the My Apps tab at the top left hand of your screen and there is a little side tab on the left to Give Feedback. Then you can let people know on this forum that you made that suggestion and try to solicit other people to include that in their wish lists.
Quickbase will not be changing the way that forms behave on the current form builder because as it happens Forms are in the process of being completely overhauled as they have been basically remained unchanged for the last 20 years. So it is a good time to put in suggestions as they will have their ears wide open as to what feature should be designed for new forms. Many users think that when they give feedback it just goes into a deep dark black whole but in fact every single one of them gets read by the appropriate Product Manager. Ideas with higher rankings from multiple users carry more weight.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------- JoshPayette3 years agoQrew MemberI was responding before your second response came through - what you mentioned about redeveloping the forms makes sense, and I will use the appropriate feedback channels. I wanted to make one more post to acknowledge your follow-up.
------------------------------
Josh Payette
------------------------------
- JoshPayette3 years agoQrew MemberThanks 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
------------------------------