Act Custom Table Services
With Act Custom Tables we help bring your complex data sets, unique businesses processes and specialized industry practices together in Act! to manage your business.
act custom tables, act custom tables services, act table customization, act database customization, act tables help, act premium tables, act crm tables, act table fields, act table design, act table templates, act table email templates
15248
page-template,page-template-full_width,page-template-full_width-php,page,page-id-15248,theme-bridge,bridge-core-1.0.6,woocommerce-demo-store,woocommerce-no-js,ajax_fade,page_not_loaded,,columns-4,qode-child-theme-ver-,qode-theme-ver-18.2,qode-theme-bridge,qode_header_in_grid,wpb-js-composer js-comp-ver-6.0.5,vc_responsive
 

Act Custom Table Services

ACT! CUSTOM TABLES

We help you unlock the full potential of Act! CRM using Custom Tables so you can bring complex data sets, unique business processes, and specialized industry practices together in Act! to manage your business.

 

Ditch those spreadsheets! We can help customize your Act! CRM Software to tailor it your business needs by adding custom tables to your database and designing it to capture information important to your business and making the input as simple as possible. Then having that information flow to the other areas of the program such as List Views, Documents, Emails and Insight Dashboards.

 

Act! CRM is not meant to be a one size fits all businesses CRM program and we can help in making your Act! CRM Cloud or Self-Hosted products unique for your business. We will work with you and/or your personnel remotely (on-site services are available) to customize your database, templates, reporting tools, etc. to capture, utilize and report on the information that is important to the success of your business.

ACT! CUSTOM TABLES DESIGN

We will work with you in the designing of your custom table(s) to include any information you need to track and streamline your processes. First step is to determine the database Record Type(s) of Contacts, Companies, Opportunities and Groups the custom table will be linked to and whether the table will be accessible on the record tab(s), navigation bar or both.

 

Next the fields will need to be added to the custom table. Most standard Act! fields types can be created for the custom table. Custom Tables also contains a few unique field types (see below) that are not availble in the standard Act! program.

 

Once the fields have been added to the Custom Table then the table’s layout needs to be designed placing the fields in an organized and logical order making the data input as simple as possible.

CHILD TABLE DESIGN

Utilizing the tables feature further, a Custom Table can be linked to another Custom Table. Examples are Claims to a Policy or Support Tickets to a Support Contract. The Claims or Tickets would be the Child Tables to the Policy or Contract Parent Tables. Related Child records can be viewed within the List View of the Parent table. We can help you with design and configuring your Custom Tables and associated Child Tables.

Act-Premium-Plus-Custom-Tables-Unique-Features

UNIQUE TABLE FEATURES

We can help you in implementing the additional features that are only availble in Custom Tables:
Sequential Fields feature (also known as auto-numbering) allows you to automatically populate a field with the next number in a sequence when creating a table record.

Cascading Dropdowns feature (also known as dependent dropdowns)allows you to display a field’s dropdown list options dependent on a selected value from a source field.

Conditional Formatting (such as Bold, Italics, Colors, ect.) can be applied automatically to field columns based on the field values. This allows important data to be easily identified and highlighted within the Custom Table.

CUSTOM TABLE TABS & LIST VIEWS

A default can be set for the fields displayed and the order of the displayed fields for the Custom Table Tab(s) and the corresponding List View. The fields displayed can be from the Custom Table or fields from the linked Record Types.

 

A table list can be Sorted by clicking on any of the column headers. Information can be Grouped by any column. You will be able to apply filters to find information and searches (see Advanced Queries below). If desired the list can also be exported to Excel or printed.

Act-Premium-Plus-Custom-Tables-Data-Import
Act-Premium-Plus-Custom-Tables-Document-Templates

DOCUMENT & EMAIL TEMPLATE CUSTOMIZATION

Custom Tables allows you to create and send mail merge templates that make use of the data stored in custom fields. Mail merges can be performed using either Microsoft Word or Microsoft Outlook, and they can be performed using one record or using multiple records.

 

We work with our customers to create standardized branded communications for their business and users. No more copy & paste – the design of document and email templates will enable you to save time spent on repetitive tasks.

CUSTOM ADVANCED QUERIES

We can build simple to complex Advanced Queries and save the Queries so they can be reused. These saved queries are accessible from the Custom Table List view’s Query selector for ease of use. Each time you select the Query it will display within the table view with the list of records that currently meet the query’s criteria.

Act-Premium-Plus-Custom-Tables-Advanced-Queries
Act-Insight-Dashboads-Design-Services

ACT! INSIGHT DASHBOARDS CUSTOMIZATION

We can create personalized Insight Dashbords to display metrics relevant to your business or role. Data can be pulled from all Act! entities, standard and custom fields and Act! Custom Tables.

HOW WE CHARGE FOR SERVICES
CONTACT US AND TELL US ABOUT YOUR PROJECT

  • HOURLY

  • For one-off needs or small projects we can bill you at a standard hourly rate.
  • SERVICE PLAN

  • We have service plans available to cover projects large or small, or use for on-going assistance. Your pre-purchased plan hours can be used for any professional services we offer. The more plan hours purchased the lower the average cost per service hour.
  • PROJECT

  • We can provide a flat rate for the scope of your project from beginning to end.