Helpful real world Quick Base formula examples

Here are a few formulas you can use to make your reports and QuickBase a bit better.   First off, many times in reports you have dates but want to view the month name and have the report shown in sequence…here is a simple CASE formula to accomplish just that Second, using NESTED IF statements will solve many of your issues in QuickBase.  Here is the syntax and an example for a NESTED IF formula to set up what do do based on the field value in the “Status” field… Third, many times you are going to want to make actions based on whether a field is empty or NULL.  This is a bit complicated in QuickBase because you need to do the evaluation differently when the Field Type if TEXT. For most Field Types you can simply use  However if the Field Type is TEXT you need to evaluate it differently One thing to note, in the Field Properties for NUMERIC fields, there is a tickbox that lets you choose Treat blank values as “0” in calculations.  This is important in the IsNull calculations…you… Read More »Helpful real world Quick Base formula examples

Can Quick Base data be stored locally in Australia?

Most Australian companies are happy to use cloud based apps and SaaS solutions.  They trade the hardware, management and backup tasks for simplicity, scalability and cost based on use.  Most businesses are not concerned about the physical location of their data as… it is simply somewhere “in the cloud.”  However, some customers with very sensitive data may have a preference or even a requirement to store their data locally.  Like many US based cloud based software companies, Quick Base’s data centre and servers are in the US.  So, the short answer to the question is your “data” is always going to be processed in the US mainland.  Having said that, a practical solution for many customers is to maintain a copy of the data in Australia. MAINTAINING A COPY OF THE QUICK BASE DATA LOCALLY There are three main options to maintain a copy of the data in Australia – API tools, WebHook tools and an ODBC connector.  First, Quick Base provides API tools and functionality to copy the data either in mass via the API call “API_DoQuery”. A link… Read More »Can Quick Base data be stored locally in Australia?