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?13Views1like2CommentsImporting 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 ------------------------------11Views0likes4CommentsSuggestion to work around when ""Report too large. Maximum number of bytes in report exceeded"" error?
I want to queried all data from a table/report to save it into a local database. I've tried to export it into CSV format, however, got the problem as attached image. Please suggest ways to overcome it with: no filter applied one extracted data file only (like a svn dump file) I've read QB HTTP API and wonder if it can help to over come the "too large" issue?10Views0likes9Comments