- Filtering Tips
- Record Editing Tips
- PC Side Data Usage
- Calculated Field Tips
Filtering Tips
Filtering On Boolean/Checkbox Fields
You can filter on Boolean/Checkbox fields in JFile by using 0 or 1 as the
filter string. 0 means unchecked, 1 means checked.
Filtering Out
Blank Fields (or Non-Blank Fields)
You can filter fields based on whether or not they contain any data at all with
the * character, which stands for 'contains any data'. By inverse
filtering on this string, you can filter fields that are completely blank.
Record Editing Tips
Editing
Strings Longer Than a Full Screen
You can more easily edit fields that contains lengthy data (more than 1 screen's
worth) by tapping the field name itself, which will bring up a "Edit Full
String" dialog box which allows simple editing of the entire field.
Number
Pad Number Entry
You can enter numbers into integer and floating point number fields via an
on-screen numeric pad by tapping the field name - this will automatically bring
up the number pad for numeric fields.
PC Side Data Usage
Converting
JFile Databases to CSV (comma separated value) Format
Included in JFile (both demo and registered versions) is the jconv5.exe PC application -
it can convert to and from JFile .pdb format files and .csv (comma seperated value) files which almost any PC based
database or spreadsheet (such as Excel, Access, Filemaker etc.) can handle. See the
jfile.html file for more information on using the converter, but feel free to email
us if you have further questions on this.
Where Can I Find the .PDB Files
to Convert
The .pdb's themselves should be in your c:\palm\<username>\backup
directory with file names similar to what you called the database itself. Note
that in the above directory, that <username> will be some Palm-selected
abbreviation of the name you called your PalmOS hardware unit.
Calculated Field Tips
Concatenating
String Fields
If you use the '+' operation on two string fields in JFile, the resulting
calculation field will be the concatenated string.
Time and Date
Calculations
You can use the '-' operation on two time fields to determine the number of
minutes between the two time fields. Similarly, you can use the '-'
operation on two date fields to determine the number of days between two date
fields.
