Send notification when a record is *not* added.

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

I have an Access database pulling information from production servers, doing some manipulation of data, and pushing the results to QuickBase via ODBC connection (using QuNect).  Part of this process involves collecting performance statistics about each run (it runs every 30 minutes) and pushing those statistics to QuickBase as well.  Since this is all set up on a laptop sitting on my desk, and IT frequently pushes software updates to the machine that force a reboot, sometimes the process gets interrupted until I can log in to the laptop again.

So my question is around how I can use QuickBase to notify me when this process fails to run (so I know to go log in to my laptop).  The only indication I get that the process failed is that the statistics for that half-hour don't get loaded.  Thus I was wondering if I could create sort of an "anti-notification" that would send me an email when a new record was *not* uploaded.

Photo of Ryan

Ryan

  • 88 Points 75 badge 2x thumb

Posted 4 years ago

  • 0
  • 1
Photo of Drew

Drew

  • 482 Points 250 badge 2x thumb
I had a similar issue, I just went about it a different way.  Not foolproof or perfect, but worked for my needs until my approach changed.  I also pushed data from our system into quickbase every 30 minutes - in my case from SQL server. 

Create a record in some table (if you have a settings type table or table of variables works great).  Create a date field and a time field in that record (we'll call it 'last good run - date' and 'last good run - time')

As part of your access process, after successful completion of the run, the current date & time should be pushed into that record into those fields. 

Then you basically create a formula duration field in that same table that calculates how long it's been between now() and when that last good run occurred.  You can put in a highlight or something if you want to highlight the record RED if it has been more than 30 minutes.  Put it in a report or basic html page on your dashboard.  It's not an e-mail notification, but it is a notification on your desktop. 

Probably more elegant means out there, but that's similar to what I did in the past.  
Photo of Ryan

Ryan

  • 88 Points 75 badge 2x thumb
This sounds a lot like what I've been thinking of doing.  

We have a lot of people that work in our QuickBase app, and they are creating and editing projects all the time.  I was thinking of relating some of the more "trafficked" areas of the app to the table that holds the "duration since last update."  I would pull in a lookup field to those other tables that shows the current duration, and put it in a hidden area of their forms.  Every time someone creates or edits a record in the "high traffic" form, I would have a notification check to see if the duration was greater than an hour, and if so send a special notification to the Admins.  

It wouldn't be truly automated, nor would it be "real time" error reporting, but it should be pretty darn close and should get the job done.  As a backup I would create a subscription to the table that holds the duration, and have that send me a report only when the duration is greater than an hour.

The problem with this idea is that I could potentially get inundated with notifications if everyone is very active at the same time while the automation database is down.

I may have to break down and settle for a single subscription notice every morning.  I'd really like this to be more prompt than (potentially) 24 hours delayed, but that seems like the only stable and reliable way to do it right now.