Forum Discussion
MarkShnier__You
Qrew Legend
I think the only solution in your case is to have a short abbreviation for the multi select field and then create a formula field which will detect which choices were selected and provide a longer explanation in a vertical list.
Post back if you feel you need help with the formula.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
PatrickO_Neill
3 years agoQrew Member
Thanks Mark,
Have been trying that, having the labels within my multi select field of A, B & C - but from the form view the vertical list is a tile away from the user selection objects - is it possible to define the regions so they are closer.
If there was a way to query if multi choice option 1 was true and so on, the text would not have to be processed.
Rgds
Pat
------------------------------
Patrick O'Neill
------------------------------
Have been trying that, having the labels within my multi select field of A, B & C - but from the form view the vertical list is a tile away from the user selection objects - is it possible to define the regions so they are closer.
If there was a way to query if multi choice option 1 was true and so on, the text would not have to be processed.
Rgds
Pat
------------------------------
Patrick O'Neill
------------------------------
- MarkShnier__You3 years agoQrew LegendI'm not understanding your last post. Can you post a screen shot? Did you write a separate formula text field to show the selected choices with expanded text? Can you post that formula?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- PatrickO_Neill3 years agoQrew MemberHi Mark,
Currently have setup as per image 1 - I'm then using the text to look up the corresponding weight for the option selected.
Would like to setup as per image 2, with the multi choice only containing A, B and C and the text along side - however cannot present the text close to the options as shown in the image.
In each case I'm assigning a fixed weight to each option in the multi choice. For example first option will always have a weight of 1, the second 10 and the third 100. In the formula is there a way of determining which option is selected independent of the text message.
Using the text for looking up weights is not reliable if there is a capital 'OR' in the message - application seams to treat it was a logical 'OR'.
Rgds
Patrick
------------------------------
Patrick O'Neill
------------------------------- MarkShnier__You3 years agoQrew LegendOk, Those screenshots help me understand your question.
I had assumed from your question that you were referring to what is called a multi select field this is a field type where you can select multiple selections. In fact you have what is called a multiple choice field.
The main stream solution to this is that you should have a table of your choices. There would be columns in that choices table for the ABC and another column for the explanation. Then you would make a Relationship where one choice has many of our detail records.
You can then use the advanced settings for that table to set what is called the record picker fields, these are the fields which will be shown to the user when they go to pick records and through the relationship you can look up the A C C D choice and the detailed description down to your detail record and show it on the form.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------