Highlight cells in the browser based on criteria. For example
show overdue dates in Red, near overdue in Yellow. Highlight
different types of employees such as Directors, Supervisors.
Advanced version allows you to customise.
Search database for a specific match, wild-card match. Tag results,
find next occurrence. Search only displayed fields or all fields
in the browser. Searches all data types.
Tag records displayed in the Browser and permform bulk operations
on them. For example, send all Tagged Records to a Report, Export
Tagged Records. Use in conjunction with other features such as
'Showing totals for only Tagged Records'/Mail Merge etc..
Take the results of the Browser (and optionally Tagged Records) and
generate a Merge Document via Microsoft Word. Allows you create
pro-forma documents to reuse and automatically populates Words
'Merge Field' list with source fields from your Browser.
Take the results of the Browser (and optionally Tagged Records) and
send a group of emails.
Where appropriate, use the link provided to directly send an e-mail
to a recipient.
Allows you to toggle the display of records from showing all filtered
records and only those you have tagged.
Displays a list of unique values in a column, directly from the database.
You can then select (Tag) which values you want to filter on from the
list.
Use the pre-defined column filters to limit the records displayed in the
browser, or create your own (Advanced Version).
Use the customised column filters to limit the records displayed in the
browser. Filter expressions can be simple or very complex - you can write
your own filter expressions with the built-in expression generator
Create your own Categories (Tree Heirarchy) to tag your data records, then
use these Filter function to limit the display to matching records, or even
limit the display to those records that don't match, match one, match more
than one of your criteria.
This filter tool displays a list of all table fields and allows you to enter
multiple criteria or even complex expressions using the built-in expression
generator.
The Filter Panel allows you to review your column filters (for all columns),
and with a couple of clicks, you can change or add additional criteria to your
current filters.
As its name suggests, copy the data to the clipboard.... but there is
a difference here. Our copy function retains the cell contents in their native
data type. Thus if you copy the Browser Window to the clipboard and paste it
into a program like Microsoft Excel, the data is correctly pasted into cells.
Select one or more columns, then carry our operations on just the selected
columns. For example 'Copy to Clipboard' will only copy the selected columns
to the Clipboard. Export will only export the selected columns.
You can customise the Brower to display whatever columns you want. You can
even save them for later recall. The 'Hide Columns' function temporariliy
removes one or more columns from the display
Restores columns you have hidden.
Allows you to freeze one or more columns, thus having a static fixed number of
columns and a scrollable area for the rest - very similar to 'Split/Freeze
Window' in Microsoft Excel.
Performs a Group Analysis on a selected Column. For example Analysing the Employee
Type Column on the Employee Browser, will group the browsers records by Employee
Type and give you the max/min and average Salary + Count of employees in each
group.
With 'Saved' Screens you can save the layout of a screen for later recall...
You can also save the 'Active Filter' and if you wish the 'Sort Order' too.
No limit to the number of 'Saved Screens'. Hiarchy
group.
Maps dates in the same manner as a 'Year Planner'. The Planner Panel is
scaleable and scrollable. Date related information is displayed/colour coded,
and can even be updated via the Panel.
Print the Browser Window, same columns as you are viewing. Print detail records
in a structed meaningful way. Not just a hardcopy. You can customise your output
to include exactly what you want.
Export data from the Browser to numerous difference file formats. Including
Microsoft Access/Excel, CSV, SDF, CSVQ, XML. Integrator will also export data to
Excel in a structured format - including formatting and automatic formulas for
and Summary Totals/Statistics you require.
Unlike a lot of other software, Security/Access Rights are enforced to prevent
users exporting data they are not permitted view.
Export data to a PDA. Providing it runs Microsoft Windows
Mobile Version 5 or Later.
You may customise the Browser display to suit your own requirements by using the 'Pick Columns' function.
You can sort the Records on display by simply double-clicking the header of the
column, or you can do multiple-level sorts by using the 'Sort Columns' feature.
It will even allow you to change the sequence to reverse order.
Key information relating to the currently selected record is displayed in the
Detail Panel. In addition Integrator exposes functionality in the Planner Panel
based on the data being displayed, eg.. Double-Click on an e-mail address to
to send an e-mail. Double-Click on a phone number to invoke the Dialer.
A summary total band is displayed on the browser (you can toggle it on/off). This
band displays summary statistics for various columns. The 'Advanced' version allows
you to customise the statistics and what is displayed.
Export your Browser Data for further analysis with Microsoft Excel. Integrator will
take you through the steps necessary to create a Pivot-Table and automatically
create it for you in Excel.
Present your data in one or more graphical forms, using the built-in pre-defined
graphs... simply use the Graph Function, select your analysis/presentation options
and the Graph will be displayed.
If your data can be resolved to geo-coordinates, then why not analyse your data
geographically... for example Plotting values in the UK by Territory.
Required Microsoft MapPoint 2002 or Later (Not Supplied).
It's quite often necessary to apply a change to a group of records. Integrator allows
you to 'Tag' the records you want to update, and then to simply pick 'Bulk Update' on
the appropriate column to change the tagged records values.
This feature is not available on all fields and Access Rights/Security may restrict
it's availability further.
Key Performance Indicators Dashboard functions are including in the Advanced Version of
Integrator. The fast graphical analysis functions are designed to highlight critical/key
metrics.
Wizards are designed to streamline operations... They are designed to prompt you for
relevant information and then to perform one or more operations thus saving you
switching forms, adding data to multiple tables.
Comprehensive Help is available in Integrator. Context sensitive Help Pages serve as a
manual. Field level prompts guide you through data entry steps. Tutorial guides in the
form of 'Show Me How To.....' animations accelerate your learning and understanding.
User setup includes features such as their default Language, pregferences, level of
expertise - as well as the usual password/login controls + a Role Based Security Model.
Note features vary across versions.
Transaction History will tell you 'who' has been doing what - right down to date/time,
the PC they used and even the actual data they changed.
Note features vary across versions.
As our software is modular, as you would expect you can modify the settings for each
module. Defaults and features can be turned on/off via the Module Configuration.
Note features vary across versions.
Database maintenance tools are standard across all version.
Tools for exporting configuration data from Integrator are included in the
Intermediate/Advanced Versions
Integrator automatically ensures that two people aren't given write access to
the same record(s)... unlike other software - it will however allow you to view
the locked record(s) and it will even tell you 'who' is currently updating it.
Advanced Security allows you to define access rights at form field level. You can
also enable/disable individual butons/functions. Furthermore record level security
allows you prevent individual records being accessed by specific users.
Security can also be applied to prevent specific data being exported or printed
Given a UK postcode, this function will connect to Google Maps and display the
map Location.
Requires Internet Connection.
Reminders can be attached to any date field on any form. The 'Browse Reminders' form
allows you to view all your reminders in one place and go directly back to the form
you created it on.
Categories are the ultimate in flexibility. This heirarchical control allows you
to create your own lists and sub lists and then to categorise your records
accordingly. You can even create multiple category lists.
Where they really shine is when you need to filter data on one or more of your
values.
Web Links allow you to add multiple Web Site Addresses (URL's) to a record for
reference purposes. For example you may want to link a suppliers Product to your
PPE Register, or link a Suppliers online MSDS to your MSDS record.
Attach multiple documents (Word/Excel or anything else for that matter)
to a record such as an employee or supplier.
Attach multiple Images/Photos to a record such as an employee or supplier.
Integrator will allow you to resize, rotate or flip the image. It also allows
to have the photo embedded in the Integrator database or linked to a file on
disk. It also includes facilities to export the image in a variety of formats.
Integrator allows you to enter multiple addresses (unlimited). You can also
categorise them to ease identification.
Integrator allows you to enter multiple contacts (unlimited). You can
categorise them to ease identification. Contacts can be either Mobile, Telephone,
e-Mail, Fax or NetMeeting Address
A collection of pre-defined reports are included in Integrator. These provide you
with a fast, effective way of outputing your data in hardcopy form. Remember also
that you can print the Browser window, and detail records if required.
Fully functional report writer, allow you to group/sort and filter data. Multiple
grouping band sections (headers and footers). Title and Summary Section(s),
Customised layout.
Edit report layouts, including pre-defined reports
supplied by Apex Software.
Instead of sending the output of your report to paper... send it to a Browser
window, you can then use all the in-built Browser functions to manipulate and
interogate the data.
Quite often reporting tools such as Crystal Reports will bypass your application
security thus allowing access to data which should not be available. Integrator's
reporting tools respect your security settings and automatically prevent this
data being reported.
The Advanced version of Integrator allows you to create multiple database
instances... you can think of an instance as an entirely separate copy of your
database. The only common data is application configuration, profiles and
security. You could use Instances for multiple businesses, or for a backup/test
version. Tools are included for creating/duplicating/deleting instances.
The Advanced version of Integrator allows you to attach a Note to any data
field simply by right-clicking on it and picking 'Notes', a red marker
is displayed next to the field to aid identifying which fields have notes.
This is very similar to the 'Cell Notes' feature in Microsoft Excel
Integrator supports multiple languages. You can switch languages instantly
on any form via the menu. You can of course specify your default language.
Integrator's Language files can be duplicated and edited, thus you have
the ability to customise the language or change the labels on any of the
forms to something more appropriate for your business needs.
Text fields can be converted to another language simply by right-clicking
on them and using the 'Translate' function, Google's Language Translation
service is used to do the translation.
You require Internet Access to use this feature.
Multi-Currency Support is built into Integrator's Modules. Additional features
include the ability to toggle amounts to different currency's, use rates set by you,
use rates automatically downloaded from your e-mail via a Service like XE.COM
Integrator's Browser's are intelligent enough to also normalise different currency
amounts on records in a Browser to the selected Currency being displayed in the
Totals section of the Browser.
You can configure Integrator to automatically download rates from your e-mail,
via a subscription to a service like XE.COM.
Integrator also maintains details of all past rates loaded..
In the 'Advanced Version' you can edit field properties on the forms directly, this
for example allows you to change the label, access rights, help text etc...
A VCard is a Contact Card object which is commonly used to transfer Contact details
between Mail Programs such as Microsoft Outlook. It typically contains Name, Address,
e-Mail Address and Telephone Contact details
You can add multiple Notes to most of our detail screens. Free form text up to 32,000
characters may be entered. You can also give the note a title if you wish. Notes fields
also support Rich Text Format - allowing you to use Bold, Underline, Italics, Fonts
and Colours.
