How to calculate run time from hour meter reading
I own a small utility company and have several operators check in plants. They record the day's meter readings (cumulative hour meters and water meters) in QuickBase. I need to calculate run time based on the previous reading compared to the current reading. I have dozens of facilities, hundreds of meters to read and thousands of reads. Tables: Facilities, Equipment, Reads. The readings are taken on random dates (no defined interval). I have the read table related to itself so that the previous read can be "selected". This has been working but I would like to be able to import a list of reads but I don't know how to populate the record ID required for finding the "previous" read. I think I'm looking for a way to dynamically/logically calculate the key field.36Views1like6CommentsExporting QR Codes in bulk for label making and inventory
Hello All, I use quickbase to keep track of industrial equipment as well as inspect and keep records of said equipment. Each piece of equipment has QR code linked to it directly in quickbase. I am trying to export both the data and the images so II can print them out with a Brady labeler. My issue right now is the only file format offered is CSV which does support images. I am curious if anyone else has run into this issue and has a solution. ------------------------------ Phil Heron ------------------------------26Views0likes8CommentsBackup entire Apps in Quickbase
Dear Expert, Due to our business closing down, I would like to ask how to backup entire apps in QB ? I notice File attachments is not backup as well here. I would like to back up entire apps, along with those tables and possible attachments, dynamic rules and etc. Appreciate for you help if I can execute this backup in easy way . Thank you ------------------------------ Quickbase Admin ------------------------------24Views0likes4CommentsAutomatic download of QuickBase data to Excel spreadsheet
I'm using a data connection ("From the web") in Excel to automatically download the data that I need from QuickBase. The only issue I'm facing now is that from time to time my data connection seems to "forget" my QuickBase credentials and the data download fails, until I go into Connection Properties and click on "Edit Query". When I do this, Excel attempts to open the QuickBase report in a browser window within the Edit Query dialog box and asks me to enter my QuickBase credentials. Once I re-enter my credentials, the data download executes successfully. I've attached a screenshot of the Edit Query dialog box. I don't want to have to do this every time. Is there a way to store the credentials within the connection string? Thanks in advance. Juan16Views2likes12CommentsConcatenate text fields to create an address
I have a spreadsheet that I plan to upload to QB that has text fields for: Address Street Info (Text Field) City (Text) State (Text Abbrev) Zip (Text) If I create a text formula that concatenates these strings together, will QB recognize this as an address?13Views1like2CommentsPossible to download a report as a csv (or xls) with a button push?
I have a button that allows a user to open a report, and then if they want save as spreadsheet. Is there any way the button can download the report as a spreadsheet automatically? ie, skip the go the the report stage? Essentially, I want my users to be able to download a template, but this template isnt static. It may change periodically based on data in the system, so I can't simply upload a template file. Also, I want the user to get the template on demand, so I can't set it up as a subscription. Ideas? ------------------------------ Mike Tamoush ------------------------------12Views1like4CommentsImporting data -
I am trying to Import a large data set that would update existing records in my 'Leads' table. The problem is that some of the Record ID#'s that I am trying to import do not exist. It may be for instance that the record was previously deleted. So, because the record ID doesn't exist anymore, I get an error message: "Error: Some record IDs specified were not found in the table." And I have to manually search for the Record ID that doesn't exist, and remove it, before I'm able to upload. Aside from going through one-by-one and locating which record ID is not valid, is there a way to update my records and either 1) create new records for the ones that aren't already present, or skip those and do the rest? (screenshots attached) ------------------------------ Mathew Crist ------------------------------11Views0likes4Comments