gchron Posted June 15, 2009 Share Posted June 15, 2009 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. Link to comment Share on other sites More sharing options...
jamesducker Posted June 15, 2009 Share Posted June 15, 2009 Wouldn't it be nice. Unfortunately, can't be done. A simple feature that would be so useful in the next version... -) Sorry. James Link to comment Share on other sites More sharing options...
IdealData Posted June 15, 2009 Share Posted June 15, 2009 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. Link to comment Share on other sites More sharing options...
comment Posted June 15, 2009 Share Posted June 15, 2009 Exactly - and not very difficult either: Scroll_Checkbox.fp7.zip 1 Link to comment Share on other sites More sharing options...
Raybaudi Posted June 15, 2009 Share Posted June 15, 2009 Hi comment on windows disabling the Freeze Windows is better. Can I know why did you use that script step ? Link to comment Share on other sites More sharing options...
comment Posted June 15, 2009 Share Posted June 15, 2009 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. Link to comment Share on other sites More sharing options...
LaRetta Posted June 15, 2009 Share Posted June 15, 2009 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. Link to comment Share on other sites More sharing options...
gchron Posted June 15, 2009 Author Share Posted June 15, 2009 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 Link to comment Share on other sites More sharing options...
maiton.vang Posted September 23, 2009 Share Posted September 23, 2009 (edited) 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 Link to comment Share on other sites More sharing options...
comment Posted September 24, 2009 Share Posted September 24, 2009 Your question is not clear. Link to comment Share on other sites More sharing options...
maiton.vang Posted September 24, 2009 Share Posted September 24, 2009 How can I change the Attribute "Alpha, Bravo, Charlie, Delta....." to "Hospital, Clinic, Urgent Care....." Link to comment Share on other sites More sharing options...
comment Posted September 24, 2009 Share Posted September 24, 2009 Go to the Attributes layout and change the values in the Attribute field - or delete the existing records and create your own. Link to comment Share on other sites More sharing options...
maiton.vang Posted September 24, 2009 Share Posted September 24, 2009 (edited) 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 Link to comment Share on other sites More sharing options...
comment Posted September 24, 2009 Share Posted September 24, 2009 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. Link to comment Share on other sites More sharing options...
maiton.vang Posted September 24, 2009 Share Posted September 24, 2009 (edited) 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 Link to comment Share on other sites More sharing options...
Miko Posted October 19, 2010 Share Posted October 19, 2010 can anyone explain how to return the list of checked items back to a paragraph separated list? thanks Link to comment Share on other sites More sharing options...
comment Posted October 19, 2010 Share Posted October 19, 2010 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. Link to comment Share on other sites More sharing options...
Miko Posted October 19, 2010 Share Posted October 19, 2010 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. Link to comment Share on other sites More sharing options...
Roeland De Windt Posted April 28, 2016 Share Posted April 28, 2016 (edited) 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 Link to comment Share on other sites More sharing options...
Steve Martino Posted April 28, 2016 Share Posted April 28, 2016 Sort by checkbox, descending then the field you want, ascending, and check the box 'Keep records in sorted order Link to comment Share on other sites More sharing options...
Lee Smith Posted April 28, 2016 Share Posted April 28, 2016 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 Link to comment Share on other sites More sharing options...
Roeland De Windt Posted April 28, 2016 Share Posted April 28, 2016 (edited) 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 Link to comment Share on other sites More sharing options...
webko Posted April 28, 2016 Share Posted April 28, 2016 I would make the right hand checkbox set two columns wide, while possibly also reducing the width of your portals to the sub-tables. Link to comment Share on other sites More sharing options...
comment Posted April 29, 2016 Share Posted April 29, 2016 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 Link to comment Share on other sites More sharing options...
Roeland De Windt Posted April 30, 2016 Share Posted April 30, 2016 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 2922 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now