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


Community Forums

  • The New FileMaker Platform
  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPad and iPhone
    • FileMaker and the Internet
    • FileMaker Pro Advanced 18
    • FileMaker Pro Advanced 17
    • Legacy FileMaker Platform Discussions
  • FileMaker Server Administration
    • FileMaker Server 18
    • Zabbix Server Monitoring
    • FileMaker Server 17
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Bar Codes (Printer, Scanners, Software)
    • Hardware & Networking
    • OS Level Database Automation
    • Product Ideas
  • JavaScript Integration
  • FMForums Affiliates & Sponsors
  • FileMaker Classifieds
  • FM Forums Operations
  • FileMaker Friday Night Chat's Topics

Blogs

There are no results to display.

There are no results to display.

Categories

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

Product Groups

  • Workplace Innovation Platform
  • Site Advertising
  • Development & Hosting

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Title


Industry


Location


Interests


Website URL


Skype


MSN


Yahoo


OS Version

Found 14 results

  1. In list view I want to be able to "grab" an object so I can move the record up or down in the found set. Is there a way to do this? It would be just like how an item on an list in an iPhone gets moved up or down. For example, on a play list in Music, I can change the order of songs to be played. Also, I would like to have this capability when I move my solution over to FileMaker Go Thanks!
  2. 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
  3. 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.
  4. 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
  5. 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?
  6. 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
  7. 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
  8. 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.
  9. 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.?
  10. 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!
  11. Totally not sure if I've put this thread in the right topic category, as I'm not even sure how to go about this. First, I'd like to be very clear on the fact that, if possible, this will be done without scripting. I'm hoping for some kind of calculation. IDK. Anyway, I'm trying to copy or Calc one field from an older record to its newest match (using BatchNum field to match). The two fields are different fields (FormNum is the ID number field) (RefID is the the reference field for FormNum ). RefID would allow the user to find the last time the same arrangement of data (FormNum being its ID number) was used. It's meant as sort of a skipping stone effect, if that makes sense. My thought was to create a filtered value list of some kind and just set RefID with the highest ID number from FormNum, prior to the newest entry. Or organize by newest Date Created, prior to the newest entry. Again, IDK. I'm quite stumped and hope this rambling makes sense to you very helpful people. Thanking you in advance....
  12. 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
  13. 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.
  14. FileMaker Coaches' Corner - Tip 5 - Portal Record Moving via Sort https://youtu.be/pVt432ZlTVs For this Coaches’ Corner tip, Kristian Olsen explores using sorts to move a portal record up or down. The key is Sorts! Grab the sample file here: http://bit.ly/2FTJn3k http://www.fmcoachescorner.com Most Recent Upload https://goo.gl/Dbn9fm Get up to speed with the FileMaker Pro 16 Video Training Course! Top Rated Course by FileMaker Expert, Richard Carlton. http://learningfilemaker.com/fmpro16.php Experience Richard's dynamic and exciting teaching format, while learning both basic, intermediate, and advanced FileMaker development skills. With 26 years of FileMaker experience and a long time speaker at FileMaker's Developer Conference, Richard will teach you all the ins and outs of building FileMaker Solutions. The course is 50 hours of video content! Richard has been involved with the FileMaker platform since 1990 and has grown RCC into one of the largest top tier FileMaker consultancies worldwide. Richard works closely with RCC's staff: a team of 28 FileMaker developers and supporting web designers. He has offices in California, Nevada, and Texas. Richard has been a frequent speaker at the FileMaker Developers Conference on a variety of topics involving FileMaker for Startups and Entrepreneurs, and client-server integration. Richard is the Product Manager for FM Starting Point, the popular and most downloaded free FileMaker CRM Starter Solution. Looking for FM Starting Point free software download: http://www.fmstartingpoint.com Richard won 2015 Excellence Award from FileMaker Inc (Apple Inc) for outstanding video and product creation, leading to business development. RCC, Filemaker Videos, and LearningFileMaker.com are headquartered in Santa Clara, CA. http://www.rcconsulting.com/ Please feel free to contact us at support@rcconsulting.com FileMaker Pro is simply a powerful software used to create custom apps that work seamlessly across iPad, iPhone, Windows, Mac, and the web Transform your business with the FileMaker Platform Free FileMaker Training Videos Channel https://www.youtube.com/user/FileMakerVideos 50 Hour FileMaker Pro 16 Video Training Course-FileMaker 16 News-Online FileMaker 16 Training Videos https://www.youtube.com/watch?v=KpQqLLDcZ8I Playlist https://www.youtube.com/watch?v=KpQqLLDcZ8I&list=PLjTvUZtwtgBTMCfjM6LLwBAwGf_yXfvd_&index=13 Top 10 New Features in FileMaker 16-FileMaker 16 News-FileMaker 16 Instructional Videos-FileMaker 16 https://www.youtube.com/watch?v=urh8iHOCxkg Playlist https://www.youtube.com/watch?v=urh8iHOCxkg&t=130s&index=1&list=PLjTvUZtwtgBTMCfjM6LLwBAwGf_yXfvd_ Sharing your Database with Other Devices and Users-FileMaker 16 News-FileMaker 16 Database Sharing https://www.youtube.com/watch?v=GF82vkYtCtA Playlist https://www.youtube.com/watch?v=GF82vkYtCtA&index=8&list=PLjTvUZtwtgBTMCfjM6LLwBAwGf_yXfvd_ Introduction to FileMaker WebDirect 16-FileMaker 16 News-Online FileMaker 16 Training Videos https://www.youtube.com/watch?v=uaZKIpBjMAM Playlist https://www.youtube.com/watch?v=uaZKIpBjMAM&list=PLjTvUZtwtgBSVV1-4pFG4SHAhCIP3Yy-I&index=17&t=10s A database management system (DBMS) is a computer software application that interacts with the user, other applications, and the database itself to capture and analyze data Official site provides the SDK, Developer's Guide, Reference, and Android Market for the open source project http://learningfilemaker.com/FIAS.html https://sites.google.com/site/filemakerprotrainingd2n/home/filemaker-training https://drive.google.com/file/d/0ByHcthu5EL9NSmowQm9OUDdZZ1k/view?usp=sharing Free FileMaker videos check out ...http://www.filemakervideos.com Download the FileMaker Pro 16 & FileMaker GO 16 for mobile devices training videos at http://www.learningfilemaker.com Download FileMaker Go 16 video training at http://learningfilemaker.com/FMGO-16/fmgo16.php Download FileMaker 16 Full Video Training Bundle at http://learningfilemaker.com/subscription.php FileMaker Video Training Review-FileMaker 16 Video Course Review-FileMaker Pro 16 101 Course Review https://www.youtube.com/watch?v=mF6Uor0KmKo Playlist https://www.youtube.com/watch?v=mF6Uor0KmKo&list=PLjTvUZtwtgBT8tNHuzF6cOKC_37zCTQl6&index=18 Use FileMaker to create an app with the FileMaker Training Series FileMaker Pro is a cross-platform relational database application from FileMaker Inc. Comment, Like & Share Our Videos. Feel Free to Embed any of Our Videos on Your Blog or Website. Follow Us on Your Favorite Social Media https://www.facebook.com/FileMakerVideos https://twitter.com/filemakervideos https://plus.google.com/+FileMakerVideos/videos #FileMakerCoachesCorner #FileMakerPro16Training #FileMakerPro16Videos Playlist: https://goo.gl/ycpCqW Google RSS Feed : https://goo.gl/hxtYvW
×
×
  • Create New...

Important Information

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