Product tour

You can add, delete and search for data records, all from just one view. The "full view" shows a summary list of records, a detail record, child tabs for related tables, and search and sort tools.

Searching, filtering and paging tools retain the current view context, so you can focus on your work rather than wrestling with the system.

Create and apply filter conditions across multiple tables, e.g., "Find all courses with 2 or more students". Save and reuse your filters across multiple views.

Edit any field of a detail record without losing context, via the edit-in-place feature. Auto-completion and calendar widgets smartly appear as needed.

You can export all the records or any filtered subset into the comma-separated values format.

Unlike a traditional web application that relies on full-page refresh, apsona leverages Web 2.0 technology to make your user experience smooth and irritation-free.

Use the layout editor facility to make it look exactly the way you want it:

• rearrange fields via drag and drop
• add and rearrange sections in the detail area
• add custom text for every table

Use any date field of your data records (e.g., invoice due date or opportunity close date) as basis for rendering your data in a calendar layout.

View the data in any table in tabular format, with in-place editing on all the shown fields. Filter and sort the data in the tabular view.

Drag and drop fields to rearraange your layout easily.

Capture new information into your existing tables via new fields as your business needs change. When you add a new field, it will seamlessly appear as a choice in every report and filter you create.

No more corrupted data values—the system automatically validates common data types like dates, numbers and currencies. Your search and report results are much more accurate and reliable. This also speeds up searches, because most database engines are much faster on strongly-typed data.

Creating new tables is painless, and the table becomes available for immediate use. This lets you store data from many sources into one application – your contacts from Outlook, your invoices from Quickbooks and your activities.

References enable you to track multi-table relationships. For example, you might track all the activities associated with each lead, via a reference in the Activity table. Apsona enables you to use references for filtering and reporting, including exception reports such as "show all leads that have had no activity in the last month."

The report editor lets you create and edit reports containing data fields and calculated values from the main table and all related tables.

Show the data from any report in a wide range of visualizations: groupings, charts and matrices.

Use a simple HTML code fragment to publish your report data on any web page, providing real-time information on that page. This enables you to share your data with partners without giving them full access to your application.

The import wizard enables both import and mass update of your data tables.

The system automatically matches data types and validates all your imported data.

You can retain record UIDs and relationship information when importing data from other data services. As an example, the screen shot at right shows data import from salesforce.com.