Panorama's relational model supports one record-to-one record links, range-to-one record (shipping and tax tables, for example), and one record-to-many records. Panorama X streamlines data entry with features like Clairvoyance™ (auto-complete), automatic capitalization, input and output patterns, default values and the unique smart date feature that understands human friendly dates like today, friday or last monday. Proposed modifications are previewed in real time as they are changed, and actual database manipulation occurs at 10k-50k records per second. Multiple parsing/manipulation rules can be chained together for complex transformations, and sets of parsing/manipulation rules can be saved for later re-use.

Modify all fields in a single operation.

Recalculating entire field (with formula).

Search & replace words, phrases or regular expression patterns.

Splitting combined names into separate first/last names.

Entire datasets can be rapidly altered based on parsing/manipulation rules set up from pop-up menus (advanced users can also use arbitrary formulas and regular expressions). Fields can be added, removed, rearranged, hidden, merged or split at any time. Panorama allows huge data sets to be bent, reshaped or refactored at will.

You can even integrate code written in AppleScript, shell script, Python, Ruby, PHP and more.

Programmabilityįor advanced users, Panorama X includes a full-featured programming language, including conditional logic, subroutines, alerts and dialogs, full menu control, background timers, asynchronous internet access, and much much more. It can also be attached to a button, or set up to trigger when a specific event occurs. The recorded code is automatically added to the Action menu, where it can be played back at any time. Just turn on the 'watch me' recorder and Panorama will automatically write the code for you as you search, sort, and perform other database tasks. Recordabilityīasic automation doesn't require any programming at all.

That's why every aspect of Panorama X operation can be automated - database manipulation, modifying database structure, even graphical layout tasks can be automated. If a task is going to be performed more than 2 or 3 times, automation is the best way to ensure that the task is performed rapidly and accurately.

Here at ProVUE, we're big believers in automation.

Simple database for mac