Kristi Smith Consulting | Business Solutions That Make Sense
  • Home

Guide to Proper Field Use

8/3/2011

 
Picture
Despite what you may be thinking, this blog does not pertain to baseball… (go Cubs!)

This month, KSC has decided to focus on Database Maintenance.  As we often learn too late, sometimes a little prevention can go a long way, and we want to provide you with the tools to develop good database usage habits sooner rather than later.  Tune in this month for free articles on internal processes, duplicates, and backups.

For starters, let’s talk about proper field usage.  The fields in your database are the labeled blank boxes into which you input your data.  The first step to making sure you and your team are using your fields correctly is to have a conversation about how to use them.  The goal is to have all database users on the same page about what gets inputted when and where.

For instance, if Bob has been putting secondary email addresses in a field on the notes tab, and Bonnie has been putting them in the important info field, it makes it very difficult to pull this information out in a search, or even for Bob or Bonnie to find each others’ data.

This brings me to my next point.  If you have data that consistently needs to be entered, you should have a dedicated field for it.  If you know you should be recording a contact’s favorite color, but you do not have a favorite color field, collecting that information in a uniform manner becomes a challenge.  You should consider customizing your fields to match your needs, or else your database may become overwhelmed with disorganized data.

Similarly, we advise you to try to limit the amount of fields you include.  It is important to remember that with each field comes the responsibility to fill it.  If you decide you need 100 fields on each contact record, you will also need to decide who is responsible for filling out these fields.  Additionally, with that many fields in existence, the database users may find it difficult to remember where all the data should go, or where certain fields are located, again leading to database disarray.

Overall, the most important thing to remember is that using your database strategically will in turn create a source of data that is also a very reliable tool.

These are just a few ideas to help you keep your database running smoothly.  If you would like an in-depth analysis of how you are using your database, call us at 847-520-0860 for information about our Strategic Business Reviews.  And please don’t forget to check in next week for the continuation of Database Maintenance Month!

Have you added a field to your database?  Which custom field do you find most useful?

JIm Doege
11/4/2011 12:45:22 pm

I have added several fields to my database and I will be adding a couple more. I agree that having the fields defined for the proper data is a MUST.

Tina Brandts
11/9/2011 01:56:49 am

Thanks Jim! Yes, we have seen and heard some unusual cases of misused fields. Ultimately, it has the potential to end in a data disaster, which is why we highly recommend using each field as indicated or creating and adding custom fields if necessary. You are a dream ACT! user!

Tina
Marketing Director
Kristi Smith Consulting


Comments are closed.
    Loading

    Picture
    Subscribe To Our Newsletter


    Archives

    September 2016
    August 2016
    July 2016
    June 2016
    May 2016
    April 2016
    March 2016
    February 2016
    January 2016
    December 2015
    November 2015
    October 2015
    September 2015
    August 2015
    July 2015
    June 2015
    May 2015
    April 2015
    November 2012
    October 2012
    September 2012
    July 2012
    June 2012
    May 2012
    April 2012
    March 2012
    February 2012
    January 2012
    November 2011
    October 2011
    September 2011
    August 2011
    July 2011
    June 2011
    May 2011
    April 2011
    March 2011
    February 2011
    January 2011
    December 2010
    November 2010
    August 2010
    April 2010
    February 2010
    January 2010
    December 2009


    Categories

    All
    8x8
    ACT! 2011
    ACT! 2013
    ACT! Activities
    ACT! Add On
    ACT! And Outlook Integration
    ACT! Backups
    Act! Connect
    Act! Customization
    Act! Database Maintenance
    ACT! Dynamic Groups
    Act! Emarketing
    Act! Features
    ACT! For Events
    ACT! For Mobile Devices
    Act! For Web
    Act! Personal Info Tab
    Act! Personalization
    Act! Premium
    Act! Premium Cloud
    Act! Promotions
    ACT! Reports
    ACT! Searches
    ACT! Social Media
    Act! Technical Support
    ACT! Tip
    Act! Update
    Act! V16
    Act! V17
    Act! V18
    Automated Marketing
    Automation
    Browser Issues
    Business Ethics
    Business Hours
    Business Humor
    Business Intelligence
    Business Tools
    Call Lists
    Chrome
    Cloud Communications
    Cloud Hosting
    Contact Layout
    Contacts
    Content Marketing
    CRM Integration
    Customer Appreciation
    Customer Relationships
    Customer Retention
    Database Conversion
    Digital Marketing
    DIY
    Drip Marketing
    Duplicate Entries
    Efficiency
    Email
    Email Marketing
    Events
    Export
    Exporting To Excel
    FAQ
    Favorite Contacts
    Favorite Lookup
    Fill The Pipeline
    Filtering
    History List
    Holidays
    How To
    Import
    Integration
    Intuit
    Labor Day
    Leads In ACT!
    LinkedIn
    Microsoft Office
    Mobility
    Newsletter
    Opportunities
    Organization
    Outlook Integration
    Payment Processing
    PayPal
    Payroll
    Productivity
    Prospects
    Queries
    QuickBooks Online
    QuickBooks Payments
    QuickBooks Payroll
    Relationship Building
    Sales Pipeline
    Sales Review
    Slack
    Social Media
    Social Media Marketing
    Spring
    Strategic Planning
    Subscription
    Summer Projects
    Swiftpage
    Sync ACT! To Mobile
    Task List
    Technical Issue
    Technical Support
    Trade Shows
    Training
    Upgrade
    Upgrade ACT!
    Voice Over Ip
    VOIP
    Web API
    Web Browsers
    Webinar
    Web Info Tab
    Windows 10
    WuFoo

Kristi Smith Consulting     |    (847) 520-0860    |    info@kristismith.com


This Web site is owned by Kristi Smith Consulting, LLC. Kristi Smith Consulting, LLC is independent from Swiftpage and is not authorized to make any statement, representation or warranties or grant any license or permission on behalf of Swiftpage regarding any product, service or Web site content. Certain materials made available on or through this Web site are owned by Swiftpage and cannot be used without the prior written permission of Swiftpage; such materials have been released to KSC as a Swiftpage Authorized Business Partner and are used with permission from Swiftpage ACT! LLC. | www.swiftpage.com | All images displayed are the property of Kristi Smith Consulting and may not be copied or used without prior written authorization from a Kristi Smith Consulting administrator.