Jump to content

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

Community Forums

  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Security Management
    • Security Concepts
    • Intellectual Property
  • FileMaker Server Administration
    • FileMaker Server 16
    • FileMaker Custom SSL Certificates
    • External Server Authentication
  • FileMaker Go & Mobile Strategies
    • FileMaker Go for iPhone & iPad
    • iBeacon Support
    • FileMaker IOS App SDK
  • FileMaker and the Internet
    • FileMaker REST API
    • FileMaker Cloud
    • FileMaker WebDirect
    • Custom Web Publishing
    • Other Internet Technologies
  • FileMaker Interface Features
    • Cards & Window Management
    • Interface Design Discussions
    • Layouts
    • Themes and Styles
    • Button, Popovers, Button Bars, SVG Icons
    • Tab and Slide Control Panels
    • Portals
    • Web Viewer
    • Conditional Formatting
    • Custom Menus
    • Value Lists
    • Tool Tips
  • FileMaker Schema & Logical Functions
    • Managing Scripts
    • Calculation Engine (Define Fields)
    • Custom Functions Discussions
    • FileMaker Query Language or FQL
    • Relationships
    • Charting
    • Remote Container Fields
    • Finding & Searching
    • Importing & Exporting
    • External Data Sources
    • Advanced & Developer Features
    • Reports, Printing & Publication
  • Brain Food
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • OS Level Database Automation
    • Hardware & Networking
    • Bar Codes (Printer, Scanners, Software)
    • Accounting Solutions
  • FileMaker Discussions
    • FileMaker Pro 16
    • FileMaker Pro 15
    • Legacy FileMaker Platform Discussions
  • 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
  • FileMaker Platform
  • Forum

Blogs

There are no results to display.

There are no results to display.

Categories

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

Found 11 results

  1. Default sort order override

    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. Apologies if this is in the wrong forum, new to FileMaker and unsure of how to articulate what I'm trying to achieve. I am trying to reorganize a database using FileMaker. My client's work is literary, and wants to be able to sort agents/editors by their publishing house/imprint. I am using the Personnel Files starter solution, as it comes with some of the features I'm looking for, particularly the "Personnel List". A quick summary of relationships: Publishing Houses [House] are parent companies. Sometimes they do their own publishing, but it's often left to children companies, or Imprints. There are House-specific publishers, editors, etc [People]. Imprints [Imprint] are composed the exact same way, with Imprint-specific People. They are owned by parent companies. For simplicity, lets assume that every House has 5 Imprints. Editors/Publishers/etc [People] have their own specific pages. House/Imprint use duplicate layouts (companies), same with different categories of People. I want to achieve the following: The ability to use the Personnel list to sort either alphabetically by name (as is done currently). I also want to be able to sort by Publishing House -> Imprint -> [People]. What do I need to know to do this? I envision a list of all Houses. Then, clicking on one, the imprints show up in an adjacent list. Clicking on the Imprint, People working for that Imprint pop up, and then clicking on one of them leads to their Details page (currently set up). In order to view details on the House itself, the House's own page would be set up as an Imprint. What are the gaps in my knowledge here? Where should I start? I am trying to create a system of increasing specification for finding data quickly.
  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. Custom Portal Sort

    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. Right Click Field Sorting

    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. Help with layouts and dashboards

    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
×

Important Information

By using this site, you agree to our Terms of Use.