Jump to content

Search the Community

Showing results for tags 'sort'.

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


There are no results to display.

There are no results to display.


  • 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


Last Updated

  • Start


Filter by number of...


  • Start







Website URL




OS Version

Found 18 results

  1. Hi folks, I've been searching everywhere for a solution to what I am trying to accomplish and have not found one anywhere, so was hoping someone out there would be able to help. I am trying to create a custom sort in a solution. As in allow the user to choose any number of column headings and be able to sort in whatever order they wish. Now I know this is what you can do when you click the sort button. However, I don't want the user to use Filemaker's sort window as it will get very confusing for them to try and figure out some of the field names. My thought process so far is that I can create a couple of side by side portals that basically mimic the sort box. All the column headers would start in the left portal and they could click on a portal line to move it to the right portal. They can then move portal lines up and down within the right portal via arrows on each line until they end up with the sort fields in the order they want to sort in the right hand portal. However this is as far as I can get! I can't figure out a way to turn it into a sort. I know I have two options, using a value list to define the sort or a summery field. I'm pretty sure with the research I have done that I can define a value list that will be in the same order as my sort list. However, if I sort by this value list would that work, or does a sort by value list only work if the exact sort is the value list itself (for example a list of days of the week)? I should also mention I have considered creating a script that includes every possible variation of how the columns can be sorted, but I have around ten columns, and gave up counting possible sorts after reaching well over fifty with just four columns! I am worried this may be one step too far for me. I'm not even sure it is possible. I very much hope someone can wrap their brain around this (if it even makes sense) and can help. James
  2. Heads up: Our users have found that value lists in popup menus that formerly ignored pre-pended characters for sorting, now respect them. For instance, in FileMaker 12, values that were pre-pended with an asterisk were displayed in Alpha-numeric order by default — and the pre-pended asterisk was ignored: Now, in FileMaker 13, these characters are included in the default sort order, so all of the pre-pended values are now together at the top of the list: If anyone has suggestions on how I can restore the previous behavior (short of reverting back to FileMaker 12!), I'm all "ears". Thanks in advance, - - Scott
  3. I have a list which is generated from two separate tables, and consists of letters and numbers - for example Table A gives the list: 2, 3, 4, 4A Table B gives the list: A, B, 1 I would like to concatenate the lists and then sort them into order thus: Concatenated and sorted list; A, B, 1, 2, 3, 4, 4A Filemaker's sort mechanism allows you to sort records based on a value list. I can get them into this order with a sort using a value list like this (I've missed a few values out!) A, AA, B, BA, C, CA, D ......Y, YA, Z,1,1A, 2, 2A, 3, 3A ........24, 24A, 25 Has anyone got a custom sort function which will sort a list in the same way, or point me at the algorithm used to sort based on a value list? Thanks Brian
  4. Hello, this is my first post. I have a table (Employees) that contains some employees. Another table (Qualifications) contains some qualifications. The third table (EmpQualRelate) relates the two tables mentioned above, but also includes a "ranking value". Example: John Doe, has been related to the qualification "PHP" vith the ranking "3", and "HTML" vith the ranking "1". Jane Doe, has been related to the qualification "PHP" vith the ranking "2", and "jQuery" vith the ranking "4". I have a layout for Employees records, containing a Portal with the EmpQualRelate records. Everything working nice and dandy. My problem is: I want (read: need) to be able to sort the Employees record, by Qualification Ranking, ie. "PHP" ranking or "HTML" ranking or whatever is needed in the current situation. I must also provide this option in a userfriendly manner, and all 3 tables will be constantly updated. I used to keep al the data in the Employees table, as PHP ranking, HTML ranking etc. but this is no longer possible, as the number of Qualifications is rapidly growing out of hand. Help is very much appreciated.
  5. Hello Is it possible to capture the fields sorted by in a variable? I have a sub-summary report with multiple sub-summary parts. The script will be set to Sort Records with dialog so users can take out or rearrange the order of the fields. I'd like to capture the actual sort order and use the variable as a header in the report. I see sort state as a get function, but don't see a get function for sorted fields. Is it possible to capture? Thank you.
  6. I have a sub-summary part that provides summary data about my database according to record type. On the main database overview page, I created a portal with a self-join relationship (displays records from the same table as the layout it appears on) with relevant fields inside. Everything looks great, but the portal records are not also segregated by record type between the sub-summary reports. I have the records sorted by record type within the portal, but that just groups them. Right now, the portal looks identical in each sub-summary report. Is it possible to filter records so they only appear in the sub-summary part designated for their case type?
  7. Based on a large DB I have created a summary report (I'm not interested in the detail) which extracts products according to certain criteria and groups them under sub-summaries. The product at the top represents the most sales, and the product at the bottom - the least. I wanted to obtain a ranking no eg No1 at the top and had thought to define a field which would accept this number by inputting the rank using Replace Field Contents with a serial number. However, it inserts incremental numbers through the whole file rather than just for the sub-summary. For example: say, I have a file of 2000 different hats in 50 different colours. A red hat is the most expensive at $100, the black hat the least - $50, say. But I sell only 10 of the red hat and 1000 of the black hats. So, in my summary at the top I have Black hats $50,000 (at my proposed No.1) and Red Hats below it at only $5,000 (proposed No. 2). eg Black hats $50,000 Red hats $5,000 How can I create and populate a field which I can add to this report which will indicate the following: Black hats $50,000 Rank 1 Red hats $5,000 Rank 2 ?
  8. I am running into an issue of some records not sorting the same way. The user's UI has a portal viewing some related records; this portal is sorted by two fields. However, it doesn't appear that the 2nd field is having the correct sorting affect. This same table, when viewed in Table view with the same found set, and then sorted by these two fields, does appear to correctly sort. The relationship for the portal isn't itself sorted, so I can't seem to discern where the issue is. I have attached screen shots of the Table view (along with it's applied sorting options), and the portal (showing both the records as viewed, and then one with the sorting options). This is in FM11. Anyone have some suggestions? Thanks, Justin
  9. We have a portal in a layout for scanning in items for wholesale invoices, displaying records from another layout 'Wholesale Line Items'. Everything runs smoothly when scanning and entering items. A sorted packing list is printed, and we use this physical copy to pack the goods in boxes for customers. Many times, it would inevitably be necessary to change the item numbers of some items on the packing sheet, as we do not have some of them in stock and other items are substituted. For example, we scanned in the following items: Item No. Description 32249 Remote Control 01207 Coloring Book 12745 Craft Sticks 40523 Plastic Eggs RE-4002 Sports Watch The sort script is imbedded in the Print button for the packing list so the list prints as follows: 01207 12745 32249 40523 RE-4002 Let's say # 12745 craft sticks is out of stock, so we replace it with # 48752 (another type of) craft sticks. So the list becomes: 01207 48752 32249 40523 RE-4002 We would like to maintain it in this last order, without resorting. How can this be done? So, basically, we would like to have the first list sorted, but not the second list after we've made changes. We're using Filemaker 8.5 in Windows XP. Any help would be appreciated. Thanks.
  10. This seems like it should be simple, but I can't seem to figure it out. Thanks to this solution http://fmforums.com/forum/topic/68663-sorting-titles-ignoring-the-a-an/ I created a field that stripped all of the leading articles from titles I'd like to sort. The calculation works properly, and the resulting "Sort Field" with no leading articles looks right. Then I ran a sort on that field... and found that the titles still aren't sorting properly. This sounds so basic, I'm not even sure how to explain it any further, but the sort I'm getting is only slightly different than what I get when I leave the records unsorted, and I see them simply in the order they were entered. It's not exactly the same, though; one or two records move around, but overall, it's not sorted in the "alphabetical order disregarding leading articles" way one would expect. Is there some step I'm missing? Is there any way something could be hidden in my calculation field that causes FileMaker not to sort on it in the way that seems obvious? Thanks for your help.
  11. Is there any way to not keep records in sorted order when using the script step "Sort Records by Field"?
  12. Sorts are taking too long for me on FileMaker Cloud. A database solution on a local machine (no network) sorts 400 records in less than one second; the same sort via FileMaker Cloud (no Webdirect, no browser, just FileMaker Pro Advanced) takes 30-40 seconds. None of the usual suspects (such as unstored calculations) is involved. It just takes way longer. Richard Carlson says that FM Cloud (like WebDirect) forces all sorts to take place on the server. Does this mean that our AWS server is simply slow, and we have to live with that?
  13. When FileMaker sorts records it happens on the client machine. Consequently, sorting can be a very painful process for users over a slow connection to a database. In this article we show a very fast way in which records can be presented to the user in descending creation order, without sorting delays... Read the Full Article Here…
  14. Ok, I'm pretty new to PHP, so please be gentle with me :-) The page that I'm working on shows events listings by date. When the user initially comes to the page, all events that are in the future show on a results table. Said another way, all past events are already filtered out. By default, the events are shown in date order. The page has drop down menus to filter the results further. The drop down menus are dynamic from the Filemaker database, and they only show data from events in the future (not the past). The filter at issue here is the one for the Type of Event (conference, webinar, etc). On Filemaker, the data is in just one table - no related table, no portals, etc. I'm working on the KISS principle. The dynamic drop down menus work just fine in terms of searching and filtering the data, but I just have one problem with them -> they do not display the options in alphabetical order. I would think that some sort( ) somewhere would 'sort' things out (bad pun, I know, but I've been at this for a while), but I can't make it work. I cannot find any logic as to how they are currently sorted. I unsorted the records and changed the entries to numbers, and they now come up in this order: 8, 2, 3, 18, 13, 17, 5, 14, 21. And that order does not correlate with the order for any other field. It's about as logical as the winning lottery numbers. I'm using Filemaker 12. And the code that I'm using below. My Grandfather use to say that most solutions are 'awfully simple' or 'simply awful'. I'm hoping for the former. Many many thanks. Snowball a/k/a Cin <form name="form1" id="form1" action="home_results_new.php" method="post"> <p id="form1"> <br /> <b>Type:</b> <select name="type" style="width:200px;"> <option value="*">Select a Type</option> <?php //foreach ($valueListb as $myvalueb) { ?> <?php $displayedType = array(); sort($LineItems2_result->getRecords()); foreach($LineItems2_result->getRecords() as $LineItems2_row) { $my_type = $LineItems2_row->getField('type'); if (in_array($my_type, $displayedType)) { // already seen it continue; } ?> <option value="<?php echo $my_type; ?>"><?php echo $my_type; ?></option> <?php //} ?> <?php $displayedType[] = $my_type; } ?> </select>
  15. Seems like I used to know how to do this... And I'm sure it's been answered, but I can't seem to come up with the right search string. I've got a table w/12,000 records in it.Ton of fields, several unstored calcs. It sorts rather slowly using the Sort command. Solution, I thought: set up a self-join TO with the sort set up in the relationship. GTRR to the TO. It does seem to be quicker. (The self join is by a numeric field crossproduct relationship) But... it doesn't retain it's current location in the found set. That is, I want to sort with record X selected, and after sorting, still be at record X. How to do that?
  16. Hi there I'm working on a task at the moment which involves sorting around 65000 records on a data table. The table itself has many occurrences but I only need to sort on this particular occurrence, therefore my sort criteria (ClientID, Date) are based on this occurrence. The issue is that when I sort the data on my local PC, it takes maybe two seconds to sort, calculate and display. For the task in mind, this is perfectly acceptable as I won't be doing it too often. However, now this has been deployed on a server which is more than up to the task and exceeds the recommended spec, the sort takes several minutes with a countdown of records sorted slowly going from 65000 downwards. The network between the server and the client is again, up to speed and poses no issues in other areas. So, what's FM doing to make the sort so slow? The local sort is fine, so can I cache to a local client and sort from there? I don't get why the sort cannot utilise the speed of the server or where the bottleneck is occurring? Thanks in advance
  17. I have a portal showing all the students and their birthdays. I want to display only the children who have a birthday coming up this week. I tried filtering the portal with the following calculation; Students:Birthdate ≥ Get(CurrentDate) AND ≤ (Get(CurrentDate +7)) .... But no cigar. I have also tried sorting the dates by Students:Birthdate but it sort by year, then Month Name (which is not the mlnths in order) Mmm, got a few ideas about teh sorting but no clue about the filtering. Any help would be greatñy appreciated. Thanks so much
  18. Hi, After the weekend races and all the results are imported into FM, I mark (now by hand) the “Key Races”. I’ll find each horse who either won or finished 2nd. As in this screen shot of Cherry Summer you can see he won his last race on Oct 3. (1) Then I mark the preceding race. (now I’m using a ‘K’, but I intend to change it to a number — different problem). The point is to show which race produced winners. The screenshot shows I have put a 'K' in Cherry Summer's race on may 31 and changed the 4 to a 5. Then I find matching records for RaceID (31may15tok5) on the record I just tagged, and count the ‘K’s and enter the number in KRG. So before I updated this there were 4 'K's in the field KR and the field KRG showed 4s. It would be nice to have FM do this, but marking the previous race is my problem. It's not a terrible task now, but a while back I lost everything and it took me a month to get all the key races data back. I'd like to avoid that. Any suggestions? Thanks
  • Create New...

Important Information

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