Search the Community

Showing results for tags 'sorting'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Categories

  • Custom Function Library

Categories

  • Journal

Community Forums

  • Community Resources
    • FileMaker Pro 16 Discussions
    • FileMaker Pro 15 Discussions
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Security Management
    • Security Concepts
    • Intellectual Property
  • FileMaker Server Administration
    • FileMaker Server 16
    • FileMaker Server 15
    • FileMaker Custom SSL Certificates
    • External Server Authentication
    • Stand by Server Deployment
    • Legacy FileMaker Server Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPhone & iPad
    • iBeacon Support
    • FileMaker IOS App SDK
    • FileMaker Discussions
    • Brain Food
  • FileMaker and the Internet
    • FileMaker Cloud
    • FileMaker WebDirect
    • Custom Web Publishing
    • Other Internet Technologies
  • Geist Interactive Product Support Forums
    • Visit Geist Interactive
    • Visit Modular FileMaker
    • FMPerception
    • Generator
    • fmQBO
  • 360 Works Official Product Support Forums
    • 360 Works General Support
    • MirrorSync by 360Works
    • SuperContainer by 360 Works
    • ScriptMaster by 360 Works
    • FTPeek by 360 Works
    • 360Works Email Plugin
    • DocuBin by 360 Works
    • Zulu – FileMaker, iCal & Google Calendar.
  • FM Forums Affiliate Sponsors
    • SyncServer Pro by LinearBlue
    • Open Source Frameworks
    • Monkey Bread Software (MBS Plugin)
    • FileMaker Plug-Ins
    • ISO FileMaker Magazine
    • User Group Central - Sponsored by FMPug.com
  • FM Starting Point - By Richard Carlton Consulting
    • Visit FM Starting Point
    • FM Starting Point - General Discussions
  • FileMaker Classifieds
    • FileMaker Product & Service Announcements
    • Professional FileMaker Training
    • Services for Hire
    • Services Wanted
    • Solutions Wanted
    • Tools Of The Trade
  • The Water Cooler
    • Member Lounge
    • Wants & Wishes
  • FM Forums Operations
    • FM Forums Feedback & Site News
    • Site Instructions

Blogs

  • Captain's Blog
  • FileMaker Weetbicks
  • FileMaker Security Blog
  • The FileMaker Rift
  • HOnza's Bits @ FMForums
  • SeedCode
  • CampSoftware, Hal Gumbert
  • FileMaker Hacks
  • Skeleton Key's Blog
  • Wing Forward Solutions
  • 360Works Articles and Tutorials
  • GoBillit
  • Filemaker - an amateur's view
  • Linear Blue
  • Surya Kanta Mekap's Blog
  • eXcelisys' Blog
  • Manjit Behera
  • Blue Feather's Blog
  • RCC's FileMaker News and Bits
  • Thorsen Consulting
  • DB Services Blog
  • FileMaker Magazine
  • Eye on FileMaker
  • Dev Talk
  • The Philosophy of FileMaker

Categories

  • Samples
  • Solutions
  • White Papers
  • Plug-Ins
  • FMGo

Found 11 results

  1. Hello, my ad-hoc steering committee... I'm shortly going to be tackling allowing an override of the default sort order. Once implemented, there would be a preference to override the default sort order for all(-ish) queries to sort alphabetically, rather than by export / creation order. I would love to get some feedback on this idea, in particular that I'm not either targeting too narrowly or too broadly. My thought is that this could be best implemented using 3 checkboxes. Sort almost everything alphabetically by default Sort Layouts alphabetically by default Sort Scripts alphabetically by default I think that for most users, sorting fields, TOs, references, etc by name by default will not cause a problem. Most of them won't even need a preference for that. They'd like it always on. I have, however, identified users that would like to retain general access to the imported sort order. I've identified Scripts and Layouts as two elements that very commonly are manually ordered. Most developers will group similar layouts and scripts, even assuming that they have a naming convention that would allow for meaningful interaction with these elements (say, Scripts) alphabetically. I also don't think there's any value to sorting Layout Objects in anything other than import order (by default), as the import order is a parent-child aware z-order. I'm also thinking that this will necessitate the addition of a column in the Results pane that stores the creation / import ordinal so that you have the ability to restore that order (or reverse that order) if necessary for a single query. Questions: Can you think of any other elements within FileMaker whose creation / manual order is far more important than their alphabetical order? This is oft requested enough that I'm considering changing the first checkbox (sort most items alphabetically) to ON by default. I think I will have fewer users asking how to change it back than I currently have users asking how to turn it on. Thoughts? While neither the Hierarchy Browser nor the Columnar Browser have a base implementation for overriding the sort order on an area by area basis, I might try to invent one if there's huge desire for it. I still that most users will never tweak the default, but I'm willing to be proven wrong. In a fever-dream, I thought that instead of adding checkboxes to the preferences, I would add menu items that could be toggled on and off. This only becomes of use if somebody sees being able to override this on a document-by-document basis, and really regularly, as a critical requirement. If this is you, I'd like to hear from you. I'm pretty sure that the overwhelming majority of users will turn it on, and never mess with it. Most will never even override that default sort to use the new import ordinal column. Any other thoughts or ideas related to this topic would be most appreciated. Thank you very much, Dave Ramsey
  2. Version 1.0.0

    26 downloads

    Being unsatisfied with solutions I found on the internet and wanting a solution without plugin I created a set of custom functions that can read a path out of a json-string. Syntax: json_path ( json-string ; path ) examples: json_path( $user_prefs ; "Privileges/Modules" ) json_path( $json_data ; "Menus/Menu[10]/MenuItem[5]/Label" )

    Free

  3. Hi, I was here a while back learning how to build a horse racing form. Thanks to those that helped, I've been producing a form for several months now. However, I never did figure out how to make the track averages and have FM calculate my speed figures. I'd like to give it another shot, as it will save me a tremendous amount of time. Right now I am doing all the dirty work in excel and importing the track averages and speed figures into FM -- so I'm using FM as a desktop layout program, which I suppose sounds crazy. I can get FM to produce averages in a summary report, but I need separate summaries to get my speed ratings (I think). I'll try and attach a photo of a mock-up layout that might be nice. A few things: There are ten tracks, and over 8oo possible race types i.e Tok_A1_12D (Tokyo, Allowance 1, 1200, Dirt). And I only indicate race types for races on dry tracks, so there is that attribute. Also all my records are imported into a single table - so 150,000 race records so far. Anyway, I thought things like 'do I really need to make 800 separate summary calculations?' But, if that's the way it is, then fine. And as before, I still do think I have some pretty basic conceptual misunderstandings about FM -- I appreciate all the help I can get -- even the slightest pushes in the right direction. R Ave = Class Average (for race type) W Ave = Win Average (for race type) Thanks, Paul
  4. Hi, i want to sort my records based on "three(3) of the most active customers", note..(i can sort my data by the most active customers but then i want to be able to only have 3 records in my found set. How do i achieve this.?
  5. I need a way to allow operators to move portal rows up and down in a portal. Is there a best practice that folks like? Perhaps point me in the direction of the preferred solution. Thanks in advance!
  6. Hi all, forgive me if this is in the wrong place. I could not easily figure out where to post, apologies in advance. I was wondering if there is a way to have a records sorted in order of "date/time" last viewed. The idea being to have a list which the user can easily see records they were last dealing with and to use that list as hot links to those records. An example of this functionality is how Microsoft word gives you a quick find list of recently created documents. Kindest regards Ozziggy
  7. I'm not sure which section to post this question in so hopefully this isn't too far off. A client came to me with a question I never considered and don't know how to answer. They are using Filemaker 11. If you have full access privilages in a database you can right click in a field and have the option for sorting by that field either ascending, descending, or by a value list. However, other privilege sets don't seem to have this option and they want them to have that option but not have full access. I tried setting their Available Menu Commands to All, but that does not change anything. Does anyone have any idea how to change this? To be honest I've never even noticed the sorting option before.
  8. I am compiling a library of books which have a "series" number, and a "volume" number. So for instance: Book Title, Series, Vol in series My book, 1, 3 His book, 2, 4 Her book, 3, 7 I want to sort this by a book's position within the whole series, so I need a calculation field to do this for me, which I can then ask FM to sort. What is the calculation I need to do this?
  9. We have a "Daily Log" database at work that's a little buggy, that I'm thinking of restructuring. I have a few ideas about how, but I'd like to get some suggestions before I start. The database is used to log events in an industrial plant. Log entries are made for different pieces of equipment when they are started/stopped or maintenance is performed. The main table looks something like: Daily Log Date Time User Log Comment Comment # It seems pretty straight forward, but where it gets confusing is how to handle the navigation, viewing and sorting to provide a user experience similar to making entries into a book of paper logs. The main layout should only show records for one day at a time (like turning the page in a log book). Buttons that trigger scripts are used to switch the day being viewed (previous date/next date/first/last) to jump to the group of records for the date requested. Each set of logs for a given day should be sorted in the order they were entered. But I'm not sure how to handle the sorting and filtering of dates. I don't want the user to have to enter the current date 50 times a day, so it should obviously be an auto-entered on creation field. But what if the user wants to go back and add a log entry to a previous date? Then the auto enterer date would be set as the current date, and that entry would disappear from the date they are viewing (a date some time in the past) and reappear on the current date's set of log entrys the next time the records are resorted or filtered via a find (or whatever other method ends up being used to handle the viewing of only one day worth of logs at a time). That's the major issue we have with the way it's currently structured. Without going into detail, the other issues relate to having to sort all records upon opening the DB, and slow performance. I'm open to any suggestions since I will be starting from scratch with the structure and importing the old records.
  10. Hi everyone! I am a bit overwhelmed by FileMaker and its capabilities, so I would greatly appreciate some help. Currently, I have a database of contacts throughout the entire United States, with separate groups. (Group A, Group B, Group C, Group D, Group E). I would like to create some kind of "dashboard" or "layout" for FileMaker so that I can see how many members of each group we have in each City and in each State in the country, possibly like a pie chart that adapts to the data. Could someone please explain to me how to go about setting this kind of layout up, so that I may browse these breakdowns on the fly? Best Regards, Jonathan Ross
  11. I have two sales people. I have assigned each person an employee number, 10 & 50. My question is with permission, I can control what screens, forms, reports they can see. But how do I control that they only see their sales data and not the other sales persons data. One solution I can think of would be to filter the data before each report is generated, but I was thinking there has to be an easier way. Any insight would be very helpful to me? Thanks Chuck One follow up question: If three people are connected to the same database, do you need to purchase three versions of file maker pro? If so, can you mix pro vs advance. Thus the Advanced is hosting can the other two user connect with a regular file maker pro version? Thanks again