Advanced Drop-Down Lists

ADVANCED DROP-DOWN LISTS is designed to help facilite data entry. With Advanced Drop-down Lists, you may attach to your ACT! fields either:

• a conditional drop-down list or,
• a dynamic drop-down list (group names, contact names, company names)

What are conditional drop-down lists?

Conditional drop-down lists are lists which items change depending on another field value.

For instance, let's say you have a "Product" field and a "Product option" field. You want the drop-down list of the "Product option" field to be listing only options related to the product specified in the "Product" field. With Advanced Drop-down Lists, you may create different lists for each product and each list will be displayed only if the corresponding product is displayed in the "Product" field.

1. The "Product" field is set at "Product A". "Product option" drop-down list displays a list of options specific to "Product A"	2. The "Product" field is set at "Product B". "Product option" drop-down list displays a list of options specific to "Product B"	3. The "Product" field is set at "Product E". "Product option" drop-down list displays a list of options for "Other products".

What are dynamic drop-down lists?

These are lists that contain data that is created on-the-fly. With Advanced Drop-down Lists, you may create drop-down lists that contain:

• the list of your groups;
• the list of the sub-groups of a group;
• the list of contacts or companies belonging to a group or a sub-group;

For instance, let's say you want to track who the accountant of your contacts is. You have a field named Accountant. You have a group called Accountants which contains all the accountants in your database. You could set up the Accountant field drop-down list to read the Accountants group, so that it displays the accountants names or company names. The list is dynamic, in the sense that it is always up-to-date without the need to refresh it to include contacts that you may have added to the Accountant groups.

This list displays the names of all the groups of the database	This list displays the name of the contacts in one group

Can I setup an Advanced Drop-down List to include 1000's of contacts?

Yes, although this may affect speed. If it takes too long for the list to load, you may setup your list to not read the data dynamically. In this case, you have the option to create a data file with the contacts names (or company names) so that the program reads the data file instead of querying ACT! This will significantly reduce the loading time. Though this data file will not be updated automatically when a contact is added to the group, a refresh button will be displayed at the bottom of the drop-down list to allow a manual update of the data file.

This list displays the company names of the members of one group

It is not dynamic, hence the Refresh button

Other Products by Exponenciel

1-to-1 Contact Link— Add a button to your layout to quickly go from one contact to another. Ideal to create bidirectional links (to link spouses) or a unidirectional link (to link a contact to his/her lawyer, accountant, boss, etc.). There are no limit to the number of relationships you may create. FREE TRIAL
Advanced Do Not Call Lookup— Comply with the new FTC rules for telemarketing which require that telemarketers scrub their call lists every 31 days. Advanced Do Not Call Lookup allows you to quickly check phone numbers, contact, group or company records and build lookups of record that you may call or not call so that you can flag or delete them. FREE TRIAL
Advanced Drop-Down Lists— Advanced Drop-Down Lists helps data entry. With Advanced Drop-Down Lists, you may attach to your fields drop-downs items which depend on the value of another field. You may also create dynamic drop-downs which read on-the-fly the contact or company names of the members of one group. The ultimate flexibility in data entry that you were looking for! FREE TRIAL
Advanced Field Protection— Advanced Field Protection enhances the existing ACT! Field protection feature. It is designed to give you control over which user may enter data in your ACT! Fields. FREE TRIAL
Advanced Internet Services— allows you to connect and query Internet services with your ACT! data by simply clicking a button. You may connect to phone directories, map services, search engines, industry directories and more in a snap. FREE TRIAL
Advanced Lookup By Group— Create cross-sections of groups, combine groups, exclude a lookup from a group, reverse lookups, find groupless contacts and more. FREE TRIAL
Advanced Sales Lookup— Lookup Sales/Opportunities by Product, Type, Quantity, Amount, Sales Stage or Forecasted Close Date. A must-have for all users of the Sales/ Opportunities module. FREE TRIAL
Advanced Sales Lookup, Export and Reports— Designed to help you manage your Sales Opportunities by combining three functions: elaborate Sales Lookup features; the ability to export your sales data to a CSV (Comma delimited) file for easy import into another program; and it allows you to create reports in Excel with formatting, sorting and totals in place. FREE TRIAL
Advanced Scheduling System— Advanced Scheduling System offers a completely new calendar interface to manage your activities in time slots. View at a glance which slots are available or occupied. Ideal for managing the calendar of your sales or technician teams, conference rooms, shared resources. A must for doctors, trainers or any professional with a fixed appointment schedule. FREE TRIAL
ColorCode— Change the color of your activities with one click, based on who they are scheduled for, what they are regarding, etc. FREE TRIAL
Custom Fill — Automatically create ID numbers for your contacts, do calculations involving field values, populate a field based on another field value, insert a date stamp, and more. FREE TRIAL
DBSwitch— Associate a layout with each of your ACT! databases so that they open directly in the proper layout! Also allows you to define database-specific file locations (like documents, document templates, etc.). A must-have for multiple database users. FREE TRIAL
Excel Contact Reports for ACT!— Create contact reports in Excel with formatting, sorting and totals in a snap. Because it uses templates, there is no need to edit your reports once created! All fields may be exported. Sort your reports by whatever field you like (3 sort levels). FREE TRIAL
Excel Templates for ACT!— If you can create a Word template with ACT!, you can now create an Excel Template with ACT! We've made this as simple as possible, mimicking the way you create templates in MS Word or in the ACT! Word Processor. FREE TRIAL
Excel Templates with Quote/Invoice Maker for ACT!— An enhanced version of Excel Templates for ACT!. You'll be able to merge Sales/opportunities data in your Excel spreadsheets, making the generation of quotes and invoices a snap. FREE TRIAL
LayoutSwitch — Allows you to associate a layout with a type of contact or group, so that when you view contacts or groups the layout associated with the current contact or group is automatically displayed. FREE TRIAL
LookUp Store— Quickly save and retrieve lookups. Automatically brings you back to the active contact that was present when the lookup was saved. FREE TRIAL
MyCalendar — A fully customizable colored calendar in HTML. FREE TRIAL
TriggerCalc Allows you to make any type of calculations using your ACT! contact, company or group fields. Two versions are available. FREE TRIAL
TriggerCalc Pro The Pro version supports more than 50 mathematical, conditional, date/time, string, format, financial and statistical functions. It even supports multi-level functions. FREE TRIAL

Technical Support Information
exponenciel

TOP

CONTACT US  1-800-806-5288
Copyright © 2008 SJR Productions, Inc.
All brands and product names are trademarks or registered trademarks
of their respective companies.