Skip to Navigation


Articles of interest to QuickBase folks

How to Add Time Zones to Your Sales and CRM Application

Note: The advice in this article addresses how to accomplish this for states that have only one time zone. It won't work for states with multiple time zones.

Have you ever called a customer at 9:00 AM on the East coast only to find that your customer is on the West coast and its 6:00 AM and you just woke them? This happens all the time.

Many businesses use QuickBase for sales and CRM applications wouldn't it be great to add the time zone to your QuickBase application? If the customer is in CA it pops up Pacific. It it is NE you get Central. That way you can group your calls based upon time zones and never wake a customer again.

There are two fields used for this process. One is a State/Province field and the second is the Time Zone formula text field that looks at the State/Province field and displays the time zone based upon which state or province is selected.

Linked below are two files. The first is a listing of all the states and provinces in the US and Canada. The second contains a formula that matches the states and provinces with their respective time zones. Copy and paste the contents of the stateprovince.txt file into your State/Province field and the contents of the timezone.txt formula into your Time Zone field.


Now select any state and province and you will see its respective time zone.

This is also handy for reports. Should you want to list all your customers by time zone just filter your report by your new Time Zone field.

For more information on how you can use the formula Case statement check out Using the formula Case statement.

This post was the inspiration of Joe Acunzo of SoftTech. Joe is a Certified QuickBase Business Consultant and creator of


Thank You - Once again you guys totally rock!

: )  I can't get enough of this QuickBase stuff!

you're welcome

Hi Minda --

Thanks for the positive feedback. We're glad to see that we're delighting our users.



Post new comment

The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

© 2016 QuickBase, Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit