Can I add scroll bar at a checkbox list?

[gchron]

I just wanted to ask, Is there a way to have a scroll bar in my checkbox set filed.

I have a value list that takes data from a table. So I do not know how many are going to be all the items in my checkbox list. I would like to have the ability to add a scrollbar. I cannot see this in field properties.

[jamesducker]

Wouldn't it be nice. Unfortunately, can't be done.

A simple feature that would be so useful in the next version... -)

Sorry.

James

[IdealData]

As the data for the list is coming from a table you could display this as a portal WITH SCROLL BAR. Some scripting will be needed to set the data value selected from the portal.

[comment]

Exactly - and not very difficult either:

Scroll_Checkbox.fp7.zip

[Raybaudi]

Hi comment

on windows disabling the Freeze Windows is better.

Can I know why did you use that script step ?

[comment]

Because I never know what will flash on Windows, and because this is a simplification of a more complex file where Freeze Window was required.

[LaRetta]

I don't see a difference. What I DO see is that if you paste a second copy of All Attributes portal next to the first, and fire the first (with Freeze Window) then there is more jump.

But simply disabling Freeze Window[] with the one portal being viewed makes no difference.

[gchron]

yes you are right I can do that but I have to make a hole table with a relationship for just some attribute I need to check. The problem starts when I have more that 10 boxes

Thanks anyway

[maiton.vang]

Hello,

This is a very helpful file for a project i am currently working on. The file is called "Scroll Checkbox.fp7" posted on 06/15/09.

Can anybody help me on how can I change the Attribute IDs.

Thank You in advance.

Edited September 23, 2009 by Guest

[comment]

Your question is not clear.

[maiton.vang]

How can I change the Attribute "Alpha, Bravo, Charlie, Delta....." to "Hospital, Clinic, Urgent Care....."

[comment]

Go to the Attributes layout and change the values in the Attribute field - or delete the existing records and create your own.

[maiton.vang]

Great! Thank You so much for you help.

I was able to change the attribute. is their a way i can import the fm file to my orignal file and still keep all my info.

MV

Edited September 24, 2009 by Guest

[comment]

The technique is quite simple and requires only one relationship and one script - I'd suggest you use the demo file to see how it works, then implement it in your own file.

[maiton.vang]

Everything is working Great! Thank You for all your help.

In the scroll bar menu how can you make the "check" visible when you click in the check box?

MV

Edited September 24, 2009 by Guest

[Miko]

can anyone explain how to return the list of checked items back to a paragraph separated list?

thanks

[comment]

There is nothing to return back - the field already contains a return-separated list of checked items. It's only formatted to DISPLAY as checkboxes.

[Miko]

what i need to extract is the name associated with the number. so the field is filled with 1 as the object id and then the attribute as alpha for example. what i want to know in summary is have a list of all the attributes that correlate to that item. to return a list of all checked items by attribute not by object id. does that make sense? only cause the client wants to see what is assigned to the item in a short list rather than scroll a long portal of thousands of items to see which are checked.

[Roeland De Windt]

On 6/15/2009 at 3:36 PM, comment said:

Exactly - and not very difficult either:

Scroll_Checkbox.fp7.zip

Found this and works perfectly! Thanks for that. The reason why I prefer it over regular checkboxes is that value lists can change and cause problems on layouts when extend when more values are added in the source table, or when they are long in the first place. See attachment, on the right-hand side.

I applied it to a layout with a portal listing Departments. In a second portal, I use the values of checked items as a key to filter out another portal with Functions. I also added a similar portal below that one, listing Functions in UNchecked Departments. Still to do is adding yet another Portal, there will be Employees filtered by checked Functions. So this is a kind of cascading selection tool to limit the list of employees (200+) in the end. (Employees not shown in attachement.)

Now is there a way to sort the Functions (and Employees) portal so checked items float on top of unchecked items? This becomes important – especially in the UNchecked Department Function portal – so it is immediately apparent if other Functions (in UNchecked Departments) have been selected. (Example is the "Account Manager" that is checked and visible, but should be on top...)

Edited April 28, 2016 by Roeland De Windt
Added screenshot to clarify

[Steve Martino]

Sort by checkbox, descending then the field you want, ascending, and check the box 'Keep records in sorted order

[Lee Smith]

Hello Roeland, and welcome to the FM Forums,

4 hours ago, Roeland De Windt said:

Found this and works perfectly

 

Please update your Profile to show the version of FileMaker, OS and Platform you are using.

Lee

[Roeland De Windt]

1 hour ago, Lee Smith said:

Please update your Profile to show the version of FileMaker, OS and Platform you are using.

Updated, Lee! I had a hard time finalising my registration (with details) from my company IP. Had to do it from my home IP, and then I forgot all about those details.

2 hours ago, Steve Martino said:

Sort by checkbox, descending then the field you want, ascending, and check the box 'Keep records in sorted order

Impossible. As the checkbox field is in the current file, I cannot select it for sorting. Only related files can be selected for sorting, and this is not the case using this technique. I could (and am already) sort by the name field of the Department, Function or Employee, as those are related tables.

Edited April 28, 2016 by Roeland De Windt

[webko]

I would make the right hand checkbox set two columns wide, while possibly also reducing the width of your portals to the sub-tables.

[comment]

On 4/28/2016 at 2:43 AM, Roeland De Windt said:

Now is there a way to sort the Functions (and Employees) portal so checked items float on top of unchecked items?

It's possible, but not exactly simple. I am not sure it's such a good idea, though. If you have that many options, I would suggest using two portals - one for selected options and one for unselected ones. I have posted a demo of this method

 

[Roeland De Windt]

On 28 April 2016 at 0:15 AM, webko said:

I would make the right hand checkbox set two columns wide, while possibly also reducing the width of your portals to the sub-tables.

Webko,

Thanks for replying. The screenshot is a quick'n'dirty layout just showing the checkbox field to see what's going on under the hood. Will take them of the layout when done developing.

6 hours ago, comment said:

It's possible, but not exactly simple. I am not sure it's such a good idea, though. If you have that many options, I would suggest using two portals - one for selected options and one for unselected ones.

Comment,

Thanks. I came to the exact same conclusion and have it working: 1 portal for checked, and 1 for unchecked.