Bikur Cholim בקור חולים

Wednesday, March 16, 2016

Sorting Records - Part I

Sorting Records:
FileMaker Pro stores records in the order in which you add them to the database file. 
You can sort records to temporarily rearrange them based on entries in a field or a set of fields.
You can sort on several fields at once. 
The first field you select arranges the records based on the field's contents. 
The second sort arranges records when two or more records have the same value for the first field you selected. 
You can sort records in ascending order, descending order, or a custom order based on a field's value list.
FileMaker Pro keeps the records in the sorted order unless you un-sort them, or perform a find request.

Note about Sorting:
If you publish your database on the Web, you can specify that records be sorted before they are delivered to the Web user's browser, or you can let the Web user define a custom sort order.”
Why does a Find request do that???
How do you set distance in between columns in Layout?
How do you set a form (= Layout) that doesn’t allow a new record to be created?
For example, the “Dashboard” file, which serves as a shortcut point to all files in the Field Maintenance System, only needs this particular form.

Why can’t the Tool panel in the Status Area in Layout Mode be Floating? This would help if there is a file which occupies only the quarter of the screen vertically and full width of the screen horizontally (like the “Dashboard” file in the “Field Maintenance System”).
Why isn’t there a Tip for every Tool, Object or Menu Bar Icon when hovering over it with the pointer (Mouse)?
See: http://www.filemaker.co.uk/micro-print/Traffic_Function_Spec.pdf

Date: 03/09/2009
Q. Can you make sure that the lists are all sorted:
  • Date items in reverse chronological order
  • Number items in chronological order
  • Alphabetical items in chronological order


No comments:

Post a Comment