1 2 Previous Next 21 Replies Latest reply on Jun 14, 2017 10:29 PM by taylorsharpe

    Can I make checkbox value lists flow horizontally instead of vertical ?

    binu.alexander

      Screen Shot 2015-06-19 at 9.48.26 pm.png

        • 1. Re: Can I make checkbox value lists flow horizontally instead of vertical ?
          taylorsharpe

          There is no choice for that, but I question why and how you are doing this.  It look more like something you would want in a drop down from a value list, which among other things would take a whole lot less real estate.  What is the circumstance that you are needing this and maybe be open to other ideas on how to do it. 

          • 2. Re: Can I make checkbox value lists flow horizontally instead of vertical ?
            binu.alexander

            Thanks ...

             

            My Client is tracking Chapters being translated for a given set of books .  I am already generating the required chapter check boxes  dynamically ( for each book  )  using a conditional value list . It is working well as expected  .

             

            Screen real estate is not an issue the layout is almost empty .

             

            I just thought it will be easier to read from L > R  than  than from TOP > BOTTOM 

            • 3. Re: Can I make checkbox value lists flow horizontally instead of vertical ?
              siplus

              Select your field right bottom and drag towards up right, it will resize; when getting quite narrow (in height) and quite long ( in length) you will eventually reach what you seem to look for.

               

              It will look awful, though.

               

              Investigate using an array.

              • 4. Re: Can I make checkbox value lists flow horizontally instead of vertical ?
                Mike_Mitchell

                It's a little more work, but you could do this in a related table instead of a single field in the current table. Each record in the related table corresponds to a chapter. Generate the records based on the same method you're using to generate the value list. Use a matrix of single-row portals, starting with the appropriate row in each to point to the desired record. Then you can order them however you want.

                 

                Of course, unless you actually need the data to be in a related table (although it's arguably a better setup), the view might not be worth the climb.

                • 5. Re: Can I make checkbox value lists flow horizontally instead of vertical ?
                  beverly

                  sometimes...

                   

                  and SCROLLABLE horizontal portals and/or grids (ala spreadsheet) for portals would be so wonderful.

                   

                  make a feature request (all of us)!

                   

                  I've used brute force to place single instances of a value (from the list) in different positions.

                   

                  _ 1     _ 2     _ 3

                  _ 4     _ 5     ...

                   

                  But it's not flexible.

                   

                  There are workarounds that may involve repeating field (with the values, one per repeat) and scripts to push the value (of the repeat) into the real field (or remove upon second click).

                   

                  Remember that "value-lists" fields (such as the checkbox format) is really just a field with many values separated by returns. The ORDER of selection is not important. To test: put the same field on the layout, with one just plain and one formatted with checkbox (from the value list). When you check the boxes, notice the changes in the "plain field".

                   

                  Some possibilities, perhaps?

                   

                  beverly

                  • 6. Re: Can I make checkbox value lists flow horizontally instead of vertical ?
                    siplus

                    As correctly outlined by erolst in another parallel thread, this is a case in which the correct data model does not have a logical, intuitive, desired, natural etc way of being represented.

                     

                    If Horizontal portals are hard, at least allow for -90° rotation of existing, vertical ones.

                     

                    Loop

                      WriteLn('Time flows from left to right, not from top to bottom or bottom to top')

                      WriteLn('A lot of data in our databases is time-based')

                      Exit loop if (you_got_it)

                    End Loop

                    • 7. Re: Can I make checkbox value lists flow horizontally instead of vertical ?
                      Mike_Mitchell

                      Your pseudo code cracks me up ...  

                      • 8. Re: Can I make checkbox value lists flow horizontally instead of vertical ?
                        fmp

                        checkbox-field.jpg

                        Try using a value list with the numbers entered in staggered order. Eg, "1¶4¶7¶2¶5¶8¶3¶6¶9". Then size the field  so that it's 3 numbers wide.

                        1 of 1 people found this helpful
                        • 9. Re: Can I make checkbox value lists flow horizontally instead of vertical ?
                          Extensitech

                          Caught myself thinking about how we could stagger the numbers with a custom function.

                           

                          I must be in need of a weekend.

                           

                          Chris Cain

                          Extensitech

                          • 10. Re: Can I make checkbox value lists flow horizontally instead of vertical ?
                            user19752

                            This makes result like as

                            31.JPG

                            I'm doubtful this is better than default... user would think "why 2nd line don't have 4 values?"

                            If you change height to 4 lines, it shows 8 values horiontal, you can't force 10.

                            • 11. Re: Can I make checkbox value lists flow horizontally instead of vertical ?
                              Extensitech

                              The custom function would need to take as a parameter a desired number of rows or a desired number of columns.

                               

                              Cain

                              • 12. Re: Can I make checkbox value lists flow horizontally instead of vertical ?
                                sharon

                                This is clunky, but it might work;

                                 

                                Create several fields, each with 4 values in them, eg Chapters 1-4. 5-8, 9-12 etc. Create another calculation field which gathers all the data together for your use.

                                 

                                On your layout, make the fields wide enough to show all 4 values, and only tall enough to show one value each.

                                 

                                Will this do the job?

                                 

                                Sharon

                                • 13. Re: Can I make checkbox value lists flow horizontally instead of vertical ?
                                  beverly

                                  sharon, No calculation field needed!

                                   

                                  You can place the SAME field on the layout and assign different VALUELISTs to it:

                                   

                                  myfield first instance has 1-4

                                  myfield second instance has 5-8

                                  etc.

                                   

                                  The values will still "gather" as return-delimited in to the field. Only the DISPLAY of the checks will be in the appropriate place.

                                   

                                  I have even had ONE valuelist per value and placed the same field in unique ways, such as the columns. This was a good way for IWP, for example and gave the effect as you would in HTML/web where each input type checkbox or radio is a separate line of code. Another time the appearance was a circle (such as a clock) in the placement of each value, although this was radio buttons, not checkboxes. But the method was the same with separate valuelist(s), same field.

                                   

                                  Yes, this method is not very flexible (you have to precisely place the copies of the field), as you cannot just resize one field with all the values. And you must create all those distinct value lists to use.

                                   

                                  beverly

                                  • 14. Re: Can I make checkbox value lists flow horizontally instead of vertical ?
                                    richardsrussell

                                    Binu, there have been some clever ideas proposed above, and I'll bet that at least one of them will give you what you need. I just want to throw in a little extra info about how checkboxes work, so that they don't sneak up and take you by surprise.

                                     

                                    (1) Data Storage. You can set up a field as a checkbox so that the values will be displayed in the order you prefer, but that doesn't mean they'll be stored that way. They're stored, separated by returns (⁋), in the order in which you checked the boxes. Here, for example, is the exact same field, side by side with itself, the blue formatted as checkboxes and the purple formatted as an ordinary edit box. As you can see, the values appear in a different sequence because of when you did the checking. This may or may not make any difference to you, but you should be aware of it just in case.

                                     

                                    Checkbox Data Storage.jpeg

                                     

                                    (2) Numeric Only. If you define a checkbox field with the validation "Numeric only", you can't check off more than one box.

                                     

                                    (3) Legacy Data. If you've got a checkbox field that contains possible values Ann, Bob, Che, Dee, Eva, and Fay, and you've already checked off values for them in a lot of records, be advised that those values will still be there even if you subsequently change the display of the field by editing its value list. For example, if you decide you'd rather show Robert instead of Bob, that doesn't automatically mean that all the existing values of Bob will magically be converted to Robert. They'll still be there as Bob, just not visible (which might be even worse than losing them altogether). And if you take the word Eva out of the value list, that doesn't take the value Eva out of any fields where you've already inserted it.

                                    1 2 Previous Next