Forum Discussion
MarkShnier__You
Qrew Legend
6 years agoActually, I think that you need to pause and reconsider instead using a child table. One reason is this.
https://help.quickbase.com/user-assistance/quickbase_limits.html
So, you will soon run into a dead end and exceed the limit of 100 choices. by using a child table, you still will be able to make a Combined Text Summary field to roll up the Tags. In order to allow the users to quickly select the Tags without the slowness of the typical Add Child user experience there is a method to allow users to launch off a parent record and be presented with a list of Tags on a typical Quick Base table report with full access to the Dynamic filters and filter box at the top of the report. The user will click click click to select as many tags as they like (with dups prevented and a quite fade away pop up saying "Tag Added"), and then click to return to the parent record (Case) and observe that their tags have all been added. I call this the Quick Select method.
Contact me directly if you would like help getting this working. It usually takes under 1 hour to get this working.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Multi-select Text fields |
Multi-select Text fields can contain a maximum of 100 choices. Each choice can contain a maximum of 60 characters. When using a multi-select field, you can select a maximum of 20 choices. |
https://help.quickbase.com/user-assistance/quickbase_limits.html
So, you will soon run into a dead end and exceed the limit of 100 choices. by using a child table, you still will be able to make a Combined Text Summary field to roll up the Tags. In order to allow the users to quickly select the Tags without the slowness of the typical Add Child user experience there is a method to allow users to launch off a parent record and be presented with a list of Tags on a typical Quick Base table report with full access to the Dynamic filters and filter box at the top of the report. The user will click click click to select as many tags as they like (with dups prevented and a quite fade away pop up saying "Tag Added"), and then click to return to the parent record (Case) and observe that their tags have all been added. I call this the Quick Select method.
Contact me directly if you would like help getting this working. It usually takes under 1 hour to get this working.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
MarkShnier__You
Qrew Legend
6 years agoOh, and since the Tags are now child records, the reporting becomes trivially easy to do off the child table.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- OwenMorgan6 years agoQrew MemberI think you might be right. I was trying to avoid having too many relationships if it wasn't necessary.
Secondly because not all records have tags and some have just one and adding new ones is infrequent I like the simplicity of a simple search box without navigating away from the form
------------------------------
Owen Morgan
------------------------------