Forum Discussion
MarkShnier__You
3 years agoQrew 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_Neill3 years agoQrew MemberThanks 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
------------------------------- 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
------------------------------