Multi-select text to IDs
Hi I have a many to many relationship which I want to simplify by making use of multi-select text fields for the user to select from. But the challenge I have is that whilst I want my users to be...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendAre you willing to have the rid incorporated into the multi select field. for example presented as
Red (1)
Blue (2)
Green (3)
Purple (4)
Black (5)
Yellow (6)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Red (1)
Blue (2)
Green (3)
Purple (4)
Black (5)
Yellow (6)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Hi Mark,
Thanks for looking and thinking about this.
I've found a relatively simple solution, which heavily relies upon QB's efficiency with formulae and relationships.
1) Change the key field in the values table to the field with the selectable text values in (instead of RID)
2) In the main table, create 20 fields, using the 'Part' function to create separate fields for each selected item
3) Create relationships from the main table to the lookup table based upon these formula fields.
4) Lookup the Record ID via the formula.
Works a dream and needs minimal maintenance (what is required is a process to deal with when changes are needed to values in the shared field, but that doesn't happen often at all, and it's easy to create an exception report to flag it).
D
------------------------------
dmlaycock2000 dmlaycock2000
------------------------------
Thanks for looking and thinking about this.
I've found a relatively simple solution, which heavily relies upon QB's efficiency with formulae and relationships.
1) Change the key field in the values table to the field with the selectable text values in (instead of RID)
2) In the main table, create 20 fields, using the 'Part' function to create separate fields for each selected item
3) Create relationships from the main table to the lookup table based upon these formula fields.
4) Lookup the Record ID via the formula.
Works a dream and needs minimal maintenance (what is required is a process to deal with when changes are needed to values in the shared field, but that doesn't happen often at all, and it's easy to create an exception report to flag it).
D
------------------------------
dmlaycock2000 dmlaycock2000
------------------------------
- MarkShnier__YouYes, that is a good approach. I was going to suggest it if you were not willing to inflict the record ID being embedded in the multi select field.
It's just a lot more work to set up but a better user experience
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------