Useful Apps in the Quick Base App Exchange

Let’s be honest, the vast majority of apps created in Quick Base are proprietary, industry or customer specific apps and they are fiercely protected.  They are the secret sauce for many process focused businesses, they are literally some of the core IP of the business.  So it is no surprise, there is no way those great apps are going to be posted on the app exchange for anyone to download and use.  Many of the apps on Quick Base Exchange are thin, half-baked apps that are worth exactly what you have to pay – nothing! Having said that there are two times when some of the apps are quite useful.  First, when you are a newbie and just getting started with Quick Base, especially if you are going it alone, it is useful to install and play around with a few apps to get a sense for Quick Base’s capabilities and some of the tricks. ABC PROJECT MANAGER 3 For example, ABC Project Manager 3 created by Kirk Trachy is a simple example of how you can use Quick Base to keep… Read More »Useful Apps in the Quick Base App Exchange

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