Pendragon Forms Feature Listing

Memory Usage
  • Palm OS Application: Approx. 250KB (0.25MB).

  • Each Record: Typically 64 bytes per field. Maximum of 64KB per record.

Form Limitations
  • Maximum of 64 forms per device.

  • Maximum of 250 fields per form.

23 Field Types
  • Text (up to 24KB per field)

  • Numeric (IEEE-754 double precision)

  • Currency (Range +/- 9,999,999.99)

  • Yes/No checkbox

  • Completion checkbox (used for automatic "Remove Completed Records" synchronization option)

  • Time Checkbox (runs NULL or the date and time when the box was checked)

  • Option 1-5 List (can be relabeled, e.g., ABCDE)

  • Popup List (up to 512 characters per list)

  • Multi-Selection List (up to 32 option per list)

  • Lookup List (up to 1000 items or 32KB per list, with manual entry override). Ability to cascade multiple lists

  • Exclusive Lookup List (same as Lookup List, but limited to selections from the list)

  • Subform List (jumps to a subform)

  • Single Subform (limits to one subform per parent)

  • Jump to Section List (Jumps to another part of the form)

  • Section (target for Jump to Section Lists)

  • Read-Only Text

  • Date and Time (1 minute precision)

  • Time

  • Date Only

  • Signature (bitmapped signature capture)

  • Button Field (for launching scripts)

  • Slider Field (analog scale)

  • Sketch Field (full screen, pen and marker drawing tools)

Field Attributes
  • Hidden- Hides the field from the user

  • Read-Only - Makes the field non-editable

  • Required - Makes the field required

  • Key Field - Specifies which field is the default display key

  • Auto Default - Field's value defaults to the last entered value

  • Default Value - Specify a default value for a field

  • Lookup List Name - Attaches a lookup list to a text field to speed up data entry

  • Script - Attach a script to a field to set properties at runtime or to calculate values or navigate to other field

  • Maximum/Minimum Value - Limits entry in numeric fields

  • Primary Key - Maintains uniqueness for primary key index

  • Non-Updating - Prevents a column from updating the corresponding database field.  Provides for one way transfers on a field by field basis

  • Non-Printing - Prevents a column from being printed by the print engine

  • Column Name - The name of a field that appears in the database table

  • Integer - Only whole numbers can be entered in numeric/slider fields

  • Max Length - Constrains length of text or numeric entry

  • Pattern - Specifies that user must enter characters of a certain type

  • Do Not Upload - Data is not transferred to desktop database

  • Subforms - Runs a Matching Fields report to show which fields on parent form match fields on subform.

Enhanced Synchronization
  • DAO Synchronization Conduit - Synchronizes directly with Access 97 databases and ODBC databases via the Microsoft Access database engine. 

  • ADO Synchronization Conduit - Synchronizes directly with Access 97, Access 2000, Access 2002 (XP) and ODBC databases via the ActiveX Data Objects database engine. 

  • Server Synchronization - Pendragon SyncServer (available separately) permits users to synchronize via remote desktops or handheld TCP/IP connections. 

Form Attributes for Strong Validation
  • Hide Delete Button - Prevents deletion of records via the deletion screen.

  • Hide Record View Button - Prevents the user switching to Record View.

  • Hide Back Button - Prevents the user from retracing previous screens, limits to script based navigation.

  • Hide End Button - Prevents the user from exiting the form prematurely.

  • Hide Form in List - Hides the form in a list.

  • Subform - Prevents the user creating records in subforms.

  • Field Level Validation - Fields are checked as they are entered.

  • AutoExecute - Automatically creates a new record when switching to the Forms application.

  • Don't Sort on Subform Screen - Prevents automatic sorting of the form records in the new Subform screen.

  • Disable Record Overwrite Protection - Bypasses the insertion safety feature for a specified form (see the White Paper).

  • Default to Field View - Viewing one field at a time (Field View is the default setting for entering and viewing records.

  • No End Button (Field View or Record View) - Forces the user to go through each field and prevents premature form exit.

  • Hide Section Skip Button - The user will not be able to bypass a section.

  • Disable Text Field Icons - User cannot use buttons that insert data and time into a text field.

  • Disable Field View - Handheld user will not be able to switch from Record View to individual field view.

  • Default Record View - The Record View (11 records at a time is the default view for entering new records and reviewing existing records.

  • Record Level Undo - A final validation discards all changes to a form if the user does not accept changes.

  • Disable Auto Navigation - Disable features that speed data entry (e.g. date and time field automatically pop up).

  • Auto Repeat This Form - When the user finishes filling in the last field on the form for one record, the form cycles back to the first field of a new record.

  • Disable Action Menus - User cannot use handheld Menu button options (Clone, Mark all Changed, Acquire GPS, Acquire Barcode, Print, Print All).

  • Use Backup if Available - Allows the handheld user to use the VFS Backup if a media card is present and ignores backup if not.

  • Require Backup Media -  Requires external memory card to create new records, view or modify existing records.

  • Disable Backup - No VFS Backup even if a media card is present.

  • Password Protection - User must enter a password before entering a form design.

  • Disable Form Deletion - Handheld user cannot delete form design from handheld.

  • Merge Changes - Allows multiple handheld users to update shared records and merge modifications into the database.

  • Read Only Reference Form - Store a large number of records on the handheld for lookup from a second form.

  • Storage Limit - The absolute data limit for each form on the handheld.

  • Archive Date - The cut-off date for placing records on the handheld.

Barcoding
  • Support for the Symbol Technologies SPT-1500 and SPT-1700 series laser scanning solution and the Symbol CRM 150 Springboard module  and PSC Momentum Springboard module for Handspring Visor.

  •  Scripting support allows bar codes to be processed before they are placed into data fields.  The bar code symbology is also available via scripting variables.

  •  Support for external bar coding equipment from DynaSys Technologies (Co-Pilot) and American Microsystems (Model 4000) (9600-N-8-1 ASCII, CR terminated).

Fast Database Engine
  • Sort/Search 500 records in under two seconds

  • Forward and reverse sorting

Microsoft Access Desktop
  • Microsoft Access 97, or Access 2000/Access 2002(XP) support.

  •  Automatically generate Microsoft Access form designs for data entry.

  •  Automatically generate a Pendragon Form from an external table or query (including ODBC).

  •  Map a form to synchronize with external databases or queries (including ODBC).

  •  Manage the list of authorized users.

  •  Assign users and forms to groups for large scale distribution (and revocation) of forms designs.

  •  Form Categories on the Desktop - manage large numbers of forms.

  •  Improved Error Handling.

  •  Export to ASCII and Microsoft Excel.

  •  Script Checker

Return to Pendragon Forms Product Page