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. Juan16Views2likes12CommentsPossible 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 ------------------------------14Views1like4CommentsConcatenate 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?13Views1like2CommentsHow to upload and download image/files with quickbase
Am trying to upload/Download an Image or a file using Quickbase Json Restful API. what is the best way to do that. Below is two options i have tried 1.) I upload the file to external server while saving the file name to quick base. The field type for this text field. 2.) I converted the image file to base64 encode via php and then created a field type File Attachment. The issue here is that base64 encoded files cannot be saved to quickbase via Restful API Json Call with field type set to File Attachment. here is how I did it with php <?php $file = 'photo.png'; $encode_File = base64_encode(file_get_contents($file)); ?> What is the best way to upload/download files via QB Json Restful API ------------------------------ Fredrick Esedo ------------------------------13Views0likes1CommentImport without duplication
I have source data in a .csv file. The source will update on a regular basis. I'd like to be able to import from source into QuickBase table 'Inventory', but not import values that already exist. It looks as if I can use the field 'IP' as the key but after that I'm not sure what steps to take. inventory.csv IP, host, OS 192.168.10.1, server1, windows 192.168.10.2, server2, linux Quick Base Table name: inventory Fields: IP, hostname, OS Thank you in advance, brian ------------------------------ Brian Dunbar ------------------------------12Views0likes4Comments