Using Quickbase to Establish a Lab Sample Tracking System
September 30, 2016

Using Quickbase to Establish a Lab Sample Tracking System

Anonymous | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User

Overall Satisfaction with QuickBase

It's being used in the R&D department to catalog a searchable database of commercial DNA samples, and associate their genotypes with them. We needed this database to be searchable by any field; for each sample to have multiple mutations, and for each mutation to be associated with multiple samples. We also needed each sample to be locatable within a box, so that we could find them when they were being used for experiments.
  • Searching for any attribute - necessary when an object has multiple important attributes that you need to search by or cross reference
  • Linking to outside databases - hard to do in any other program without merging the databases
  • It very difficult to associate both multiple attributes to one object and multiple objects to one attribute at the same time in the same database.
  • I'd also like to see some sort of quick tutorial, most of the things that I figure out I did so just clicking around.
I think we have. I use it for tracking R&D sample's genotypes, phenotypes, and physical locations within our lab. It needs to be used for multiple search functionalities - for example if we need to test samples that have a particular mutation in as particular gene, we search by genotypic mutation. Then we will need to find it for testing, so we then need its physical location within the lab.
I did need some help in establishing relationships between attributes of R&D samples from a much more experienced Quickbase user. I could make simple associations, but I was unable to make concurrent associations searchable at the same time. So I think that simple tables are pretty easy to figure out, but the more complex, the more help is required, especially if you need very specific functionality.
  • Building and deploying business applications faster
  • Solving a specific business challenge
  • Building and deploying an application (or multiple applications) that meets our exact needs
Any time that our lab gets in a new set of samples that have a new set of attributes, the table needs to be updated. The process is very easy, just uploading a couple of Excel spreadsheets with different sets of data, and the associations between the two different sets remain intact once they're initially set up.
Complex databases, with multiple associations between databases I think are much better suited to Quickbase. I think the more complex the better suited Quickbase is for the application. Simple tables, where there is only one association are just easier to use Excel for, as it is easier to import/export data, and perform extra functionality on the data, like calculations or searches, things like that.