### BASICS

#### Getting Started

- Getting Started with Panorama X -- whether you are a brand new Panorama user or are moving up from a previous version, you'll find great tips for getting out of the blocks quickly.

- Tutorial -- basic step-by-step lessons for learning Panorama X, including data entry, searching, sorting, analyzing, creating forms and basic programming.

- Panorama Help Wizard -- learn how to get the most from Panorama's online help wizard, including choosing a realm, searching for a specific topic, and opening multiple help windows.

- Panorama Video Training -- learn how to get the most from Panorama's video training wizard, including finding a video, zooming the video, opening related help topics, and purchasing on-demand training videos.

- Panorama Server -- sharing a database across multiple computers, or even across the entire internet.

- Release Notes -- detailed list of what's new in every Panorama X version.

#### User Interface

- Menus -- overview of Panorama X menu bars.
- Toolbars -- using and customizing window toolbars.
- Undo -- using the Undo command to reverse one or more recent actions.

- View Menu -- accessing and creating the data sheet, forms and procedures.
- View Organizer -- rearranging, copying and deleting views.

- Data Sheet -- a window that displays the database information in rows and columns.
- Forms -- display data with a customizable graphic layout.
- Procedures -- basics of procedures for automation.

### DATA

#### Files & Views

- Auxiliary Databases -- automatically opening multiple databases associated with each other.
- Creating a New Database -- creating a new database.
- Find & Open -- searching for a database on the hard drive and opening it.
- Join Databases -- joining another database into the current database (relational join).
- Open Favorites -- quickly open commonly used databases.
- Open Recent -- quickly re-open recently used databases.
- Open View -- using the Open View window to quickly access any form, procedure or data sheet.
- View Organizer -- rearranging, copying and deleting views.
- View Search -- persistent, comprehensive search of procedures and forms in one or multiple databases.

#### Fields & Data

- Adding New Fields -- adding one or more fields to a database.
- Automatic Field Calculations -- performing formulas automatically when data is entered into a field.
- Automatic Field Code -- running a short program when data is entered into a field.
- Construct Multiple Fields -- using a template to quickly add multiple fields to a database.
- Date Patterns -- control how dates are displayed or converted to text.
- Dates -- working with dates.
- Deleting Fields -- deleting fields from the database.
- Field Blueprint Dialog -- examining and modifying the raw specification of a field.
- Field Properties Panel -- examining and modifying field attributes.
- Field Properties -- available field attributes.
- Field Width -- adjusting the width of a field in the data sheet.
- Fields -- introduction to database fields.
- Hiding and Showing Fields -- temporarily hiding fields in the data sheet.
- Limiting the Maximum Number of Data Sheet Columns -- adjusting the maximum number of columns displayed in data sheet windows.
- Line Item Fields -- are used for repeating items within a record
- Merging Adjacent Fields -- merging two fields into one.
- Numeric Data -- numeric data (fixed and floating point).
- Numeric Patterns -- control how a number is displayed or converted to text.
- Rearranging Field Order -- rearranging the order of fields in the data sheet.
- Smart Dates -- keyboard entry of dates.
- Splitting a Field -- splitting a field into two fields.

#### Searching & Sorting

- Date Search Options -- searching dates within a database.
- Favorite Searches -- saving and recalling favorite searches.
- Find & Replace Dialog -- finding and replacing a word or phrase (with an option to use a regular expression).
- Find/Select Dialog -- using a dialog to search for specific data.
- Formula Search -- searching with a formula.
- Numeric Search Options -- searching numbers within a database.
- Record Search Options -- searching via record attributes.
- Refining a Selection -- selecting a subset or superset of a previous selection."
- Searching -- searching a database to find or select information.
- Select Duplicates Dialog -- opens the standard Select Duplicates dialog sheet.
- Selecting with the Context Menu -- searching for information related to the current cell.
- Sorting Data -- sorting data into a specific order.
- Text Search Options -- searching text within a database.

#### Analyzing Data

- Summary Workshop -- tool for quickly summarizing, analyzing and charting large amounts of data.
- Crosstab Workshop -- tool for two dimensional summarizing, analyzing and charting large amounts of data.
- Summarize & Analyze Dialog -- is a one stop dialog for creating and filling in summary records based on pre-selected criteria.
- Summary Records -- are temporary records used for calculating totals, subtotals, and other summary information.
- Expanding and Collapsing the Summary Outline -- to see more or less detail.
- Summarize & Analyze Favorites -- saving and recalling favorite summaries.
- Ranking Summaries -- ranking summary values

#### Morphing Data

- Merging Adjacent Fields -- merging two fields into one.
- Morph Field Dialog -- morphing the contents of an entire field.
- Morph All Fields Dialog -- morphing the contents of the entire database.
- Shifting Data Left & Right -- sliding data left and right.
- Splitting a Field -- splitting a field into two fields.

#### Relational Links

- Linking with Another Database -- techniques for relating multiple database files so that they work together.
- Relational Database Management -- linking together multiple databases based on common data.
- Join Databases -- joining another database into the current database (relational join).
- Relational Workshop -- tool that assists in composing relational lookup(, superlookup(, lookupall( and arraybuild( functions.

#### Import & Export

- HTML Export -- custom exports into an HTML file.
- Import Database -- importing another database into the current database.
- Text Export Wizard -- custom exports into a text or HTML file.
- Text Export -- exporting a database into a text or HTML file.
- Text Import -- importing text into an existing database.

### FORMS

#### Basics

- Forms -- display data with a customizable graphic layout.
- Creating a New Form -- creating a new empty form, or a duplicate of an existing form.
- Graphics Mode -- is used to edit the graphic design of a form.
- Creating a New Form Object -- with the Object Library.
- Object Library -- is used to create new objects in a form.
- Object Inspector Panel -- is used to view and modify the attributes of selected objects in a form.
- Selecting Form Objects -- so that they can be modified.
- Smart Resize -- adjusts the sizes and locations of the other selected objects to match the change of one object.

#### Shapes

- Line Object -- draws a line within a form.
- Oval Object -- draws an oval or circle within a form.
- Polygon Object -- draws a polygon within a form.
- Rectangle Object -- draws a rectangle or square within a form.
- Rounded Rectangle Object -- draws a rectangle with round corners within a form.
- Star Object -- draws a star within a form.

#### Text Editing & Display

- Automatic Form Construction -- creates a column of form elements for editing data fields (or variables).
- Font Awesome Icons -- are over 600 ready-made icons built right into Panorama.
- Line Item Grid Constructor -- creates a grid of form elements for displaying and editing line item fields.
- Rich Text -- is used to display styled text, including bold, italic, colors, tabs, even images.
- Text Display Object -- is used to display text using a formula.
- Text Editor Object -- is used to edit text in a field or variable.
- Text Label Object -- displays a short, fixed, text item within a form.
- Text Object Background Color/Gradient -- text object background colors and gradients.

#### Buttons

- Data Button Object -- is used to create checkboxes and radio buttons.
- Displaying Data in a Grid -- fundamentals of displaying data in a grid (Text List/Matrix).
- Image Display Data Buttons -- checkboxes and radio buttons created from custom images.
- Image Display Push Buttons -- push buttons created from custom images.
- Matrix Clicking -- handling clicks in a Matrix Object.
- Popup Menu Button Object -- is used to create popup menus anywhere on a form.
- Push Button Object -- triggers a procedure when it is pushed.
- Scroll Bar Object -- is used to create scroll bars.
- Segmented Button Object -- is used to created segmented buttons.
- Slider Object -- is used to create sliders and knobs.
- Stepper Object -- is used to create numeric steppers for use with Text Editor objects.
- Tab Panel Buttons and Selection -- button options for a Tab Panel Object.
- Tab Panel Object -- switchable tab panels.
- Text List Appearance -- customizing the appearance of a Text List Object.
- Text List Object -- displaying a grid of text.
- Web Browser Object -- is used to display web pages from within a Panorama form.

#### Images & Media

- Fixed Image Object -- is used for fixed images (images that never change).
- Font Awesome Icons -- are over 600 ready-made icons built right into Panorama.
- Image Display Animations -- animated images.
- Image Display Colors and Gradients -- displaying pure colors and gradients
- Image Display Data Buttons -- checkboxes and radio buttons created from custom images.
- Image Display Object -- is used for dynamic images (images that change depending on the data).
- Image Display Push Buttons -- push buttons created from custom images.
- Web Browser Object -- is used to display web pages from within a Panorama form.

#### Text Lists & Matrixes

- Displaying Data in a Grid -- fundamentals of displaying data in a grid (Text List/Matrix).
- Matrix Clicking -- handling clicks in a Matrix Object.
- Matrix Constructor -- quickly creating a Matrix Object from a template.
- Matrix Database Integration -- synchronizing a Matrix Object with a database.
- Matrix Geometry -- customizing the size and geometry of Matrix Object elements.
- Matrix Header and Horizontal Scrolling -- setting up a custom header for a Matrix Object grid.
- Matrix Object Frame -- setting up the arrangement of items within a Matrix Object.
- Matrix Object -- displaying a grid of items with a custom arrangement.
- Text List Appearance -- customizing the appearance of a Text List Object.
- Text List Constructor -- quickly creating a Text List Object from a template.
- Text List Database Integration -- synchronizing a Text List Object with a database.
- Text List Multiple Columns -- displaying multiple columns in a Text List Object
- Text List Object -- displaying a grid of text.
- Text List Programming -- programming a Text List Object.
- Text List Searching -- searching within a Text List Object.
- Text List Selection -- selecting items in a Text List Object.

#### Printing

- Automatic Mailing Label Construction -- creates a mailing label.
- Automatic Report Construction -- creates a tabular report with columns of data.
- Custom Report Headers and Footers -- setting up custom report headers and footers.
- Custom Report Margins -- specifying the top, left, right and bottom margins of a custom report.
- Printing Multiple Column Reports -- printing reports with two, three or more columns (for example mailing labels).
- Printing Multiple Page Records -- Panorama can print up to 9 pages for each record in a custom report (for example multi page invoices, etc.)
- Printing Summary Information -- printing a database that has been organized into categories with summary records.
- Report Tile Object -- component for assembling a custom report.
- Reports -- Panorama has a very flexible system for printing custom reports, labels and forms.
- Tiles In Action -- basic rules for using tiles to print custom reports.
- Variable Height Records -- custom reports with different heights for each record.
- View-As-List Forms -- displaying a custom data layout as a continuous sheet.

### AUTOMATION

#### Formulas

- Formulas -- basics of formulas: components and grammar.
- Formula Workshop -- formula workshop wizard for testing and experimenting with formulas.
- Constants -- values embedded into a formula.
- Arithmetic Formulas -- mathematical operators and functions.
- Date Arithmetic Formulas -- performing calculations on dates, and converting between dates and text.
- Text Formulas -- manipulating text with a formula (concatenation, extraction, rearranging, etc.)
- True/False Formulas -- logical boolean calculations.
- Variables -- storing and retrieving individual items of data, not part of a database.

- Characters and Unicode Values -- working with individual characters of text.
- Coordinates -- working with points and rectangles.
- Credit Cards -- working with credit card numbers.
- Cryptography -- encrypting and decrypting data, and calculating hash values.
- Database Functions -- functions that access database information, including the data itself and information about the structure of the database.
- Financial Calculations -- financial calculations based on interest rates.
- Functions -- index of all functions available for use in Panorama formulas.
- Geography -- working with geographic information, including zip codes and lat/long coordinates.
- Linking with Another Database -- techniques for relating multiple database files so that they work together.
- Mouse and Click Status -- accessing the mouse (location, buttons) and keyboard status.
- Operators -- index of all operators available for use in Panorama formulas.
- Quotes -- text constants embedded into a formula
- Scientific Calculations -- performing scientific calculations (trigonometry, logarithms, etc.)
- SuperDates -- date and time combined into a single value.
- System Info Functions -- find out information about the current status of the computer and operating system.
- Time Arithmetic Formulas -- performing calculations on times, and converting between times and text.
- Using Fields in a Formula -- accessing database fields within a formula.
- Values -- the raw material that formulas work with -- numbers and text.

#### Programming

- Action Menu -- simple way to create your own menu items.
- Code -- basics of programming code.
- Control Flow -- making decisions about what code should be executed in response to changing conditions.
- Procedure Editor -- editing named procedures.
- Procedure Recorder -- recording database actions as code.
- Procedures -- basics of procedures for automation.
- Program Error Handling -- handling errors and exceptions that occur when a program is running.
- Scripting -- embedding scripting languages (AppleScript, shell scripts, Python, Ruby, PHP, Perl, etc.) into Panorama program code.
- Statements -- index of all statements available for use in Panorama procedures.
- Subroutines -- writing code that can be called from other code.

- Accessing the Clipboard -- reading from and writing to the system's clipboard.
- Alerts -- displaying a variety of standard modal alerts.
- Automatic Field Code -- running a short program when data is entered into a field.
- Channels -- provide a standard way to interface with external resources (email servers, phones, web sites etc.)
- copyindentedcode -- The copyindentedcode statement copies the selected code with 4 space indent (for pasting into the Panorama forum).
- Custom Dialogs -- creating custom dialogs using forms.
- Custom Menus -- creating custom menus, menu bars and pop-up menus (and customizing standard menus).
- Custom Statements -- creating your own custom statements that can be used in your code.
- Database Navigation & Editing -- using program code to navigate within a database, and to add and remove database records.
- Debug Instrumentation -- conditional logging of the internal state of Panorama program code.
- Drag and Drop -- dragging data to and from a Panorama form.
- Generating & Analyzing HTML -- generating HTML code from data, and extracting data from structured HTML.
- Internet Access -- accessing information from web servers.
- Program Access to Databases -- using a program to create, open, import or export databases.
- Programmable Database Administration -- using a program to access and/or modify the structure of a database.
- Programmable Form Management -- using a program to work with forms.
- Programmable Graphics -- using program code to create and modify graphic objects in a form.
- Programmable Outlines -- using a program to create and manipulate data outlines.
- Programmable Printing -- using program code to print reports, mailing labels, etc.
- Programmable Searching -- using program code to search and select data.
- Programmable Sorting -- using program code to sort a database.
- Programmable Text Export -- using a program to export text from a database.
- Programmable Window Management -- using a program to arrange windows.
- Programming Database Fields -- using a program to add and remove database fields.
- Speech Programming -- using program code to convert data to speech (voice).
- Supressing Display -- temporarily disabling display of changes in a program (to reduce "flickering" and increase performance).
- Timer Workshop -- provides a tool for monitoring timers and testing timer configurations.
- Timers -- executing recurring periodic background code at fixed intervals.
- Transforming Data -- using program code to modify data in bulk.
- Triggers -- finding out what event triggered the execution of program code.

### Licensing

- Creating a New Panorama X Account -- setting up a new account.
- Managing Your Panorama X Account -- account expiration, adding credits, monitoring account activity, managing logged in computers, modifying contact information/passwords.
- Managing Account Roles -- configuring a Panorama X account for a team, assigning privilege levels for administrators, developers, and general users.
- Panorama X Account FAQ -- frequently asked questions about Panorama X accounts and pricing.

### INDEX

- Index -- index of all help topics.
- Release Notes -- detailed list of what's new in every Panorama X version.

Copyright (c) 2021 ProVUE Development, All Rights Reserved