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 TABLE SERVICES|
|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.|
|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.
|DATA IMPORT & MIGRATION
Data can be imported from a Microsoft Excel spreadsheet or CSV file directly into Custom Tables. We can save you data entry time by taking your exisiting Excel files and importing them to the corresponding tables and fields, linking to records and adhering to duplicate criteria.
If you have been using Act! prior to the availability of Custom Tables you may have created multiple fields and mutiple rows in a grid fashion to capture information. This data could be better utilized in a Custom Table and the data can be Migrated. We can help you in designing a Custom Table and migrating your Act! field data to the table's fields.
| 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! 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.|
CRM MAKES WORK EASIER
Let us help automate your business.
ACT! CERTIFIED CONSULTANTS
We provide Act! Custom Tables Design and Implementation Services, Child Tables Customization, Act! Custom Tables Unique Features Implementation Services, Act! Custom Tables Record Type Tabs and List Views Configuration Services, Act! Custom Tables Data Import and Act! Field Data Migration Services, Act! Custom Tables Document Templates and Email Templates Customization Services, Custom Tables Advanced Queries Build, Custom Tables Insight Dashboards for ACT! GROWTH SUITE, ACT! CRM CLOUD, ACT! CRM PRIVATE CLOUD, ACT! CRM SELF HOSTED Products with the Act! Custom Tables Add-on.
Platinum CRM Consulting provides
remote and on-site services (travel charges may apply) for Act! CRM Customers in the United States: Alabama (AL), Alaska (AK), Arizona (AZ),
Arkansas (AR), California (CA), Colorado (CO), Connecticut
(CT), Delaware (DE), Washington DC (DC), Florida (FL),
Georgia (GA), Hawaii (HI), Idaho (ID), Illinois (IL),
Indiana (IN), Iowa (IA), Kansas (KS), Kentucky (KY),
Louisiana (LA), Maine (ME), Maryland (MD), Massachusetts
(MA), Michigan (MI), Minnesota (MN), Mississippi (MS),
Missouri (MO), Montana (MT), Nebraska (NE), Nevada (NV), New
Hampshire (NH), New Jersey (NJ), New Mexico (NM), New York
(NY), North Carolina (NC), North Dakota (ND), Ohio (OH),
Oklahoma (OK), Oregon (OR), Pennsylvania (PA), Rhode Island
(RI), South Carolina (SC), South Dakota (SD), Tennessee
(TN), Texas (TX), Utah (UT), Vermont (VT), Virginia (VA),
Washington (WA), West Virginia (WV), Wisconsin (WI), and
Wyoming (WY) and Canada: Alberta (AB), British
Columbia (BC), Manitoba (MB), New Brunswick (NB), Newfoundland and Labrador
(NL), Northwest Territories (NT), Nova Scotia (NS), Nunavut (NU), Ontario
(ON), Prince Edward Island (PE), Quebec (QC), Saskatchewan (SK), Yukon (YT)