Archive for July, 2009

Working With “Groups”

I am not taking about group trips, but groups within ClientBase.  Last week an agent sent me an email asking why a client she knew was part of a particular group was not showing up in a report.

The secret is to remember that GROUPS in ClientBase are available in PROFILES, RES CARDS and INVENTORY (and more, but those are the biggies). And they are mutually exclusive.

The easiest way to remember is to think specifically for that particular task.

  • If you are working a group trip and you want to make sure all of the RES CARDS are together, you want to create a group for the RES CARD.
  • If you are working with a group from Church, you want to make sure all the PROFILES are together in that group.
  • If you want to know all of your suppliers who sell River Cruises, create a PROFILE group for that group of vendors.

Remember, the same group can also apply for profiles, res cards,  and inventory. For instance, if you have a Church group that is looking to go on a cruise in December.  Create a group and call it “Church Cruise” and assign it to profiles, res cards, and inventory.

To create a group,  GLOBAL DEFAULTS–>GROUP LISTS–> ADD

GROUP

Then name the group and select the areas you want to use to track. (Testing, Client, Invoice, Payment,Res Card, and Inventory)

Group1

Click OK and the group will appear in the drop down list of the appropriate areas.

Why groups? Right now I am working on a dozen families that are going to be at Beaches the same week. It is a group (but not technically per the vendor). I have all of the clients, res cards, and invoices tagged. That way when I want to see a list of people going, I can query the profile manager by the group.  If I want to see the individual reservations, I can query the res cards by that group.

I STRONGLY suggest creating your groups this way and NOT typing them in the field manually. It is too easy to make a typo and any typo will throw off the computer. You can create a group on the fly as well. Just click the blue underline and go from there.

And here is a tip.  When the group is no longer “active” you can delete the group from the list (it will not show in the drop down) but it will leave the group in the proper records. Caution: you need to know the exact name of the group down the road. Another alternative is to re-name the groups that are inactive beginning with “zz” that way they show up at the bottom of the drop down list.

Did this site help you out? You can always buy us a beer!

Tags:

Date Formulas: A GREAT Shortcut

Many times you want to use a date in the future or in the past to develop a query.  Let’s say you wanted to see how many inquiries you received during the past 30 days. Rather than figuring out the exact date, use a formula.

Instead of dates, you work with numbers separated by commas. The first number represents the days, the second the months and the third the years. Named days can also be used as well as the + and – signs to indicate future and past dates.

And in addition to this, did you know that when you enter a date the long way, there are some shortcuts?  Enter any number between 1 and 31 (or 30, 29, or 28 depending on the month) and ClientBase will assume you mean this month and year and will fill it in for you. Looking for a date later this year? Just type in 1015 (no slashes needed) and ClientBase will know you mean October 15, 2009.

These can be used in any date field:

If You Want This

Enter This

1st day of this month:

=1,0,0

Last day of this month:

=31,0,0

1st day of this year:

=1,1,0

Last day of this year:

=31,12,0

Seven days from now:

=+7,0,0

Last Monday (will show today if today is Monday)

=Mon

A week from last Monday

=Mon-1

Next Monday

=Mon+1

Three months from now

=0,+3,0

Six months ago:

=0,-6,0

One year from now

=0,0,+1

Did this site help you out? You can always buy us a beer!