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.99Views1like6CommentsQR Code to access record in QB App
I'd like to create a QR code that pulls up a record in the QB app on a tablet when scanned with the tablet's camera app. This QR code would be a field in my Packing List table. When the packing list is printed out by our office staff, the QR code will be printed as well. Our warehouse team would like to scan the QR code and be taken straight to the record of the packing list in the QB app on their tablet instead of looking for the record in the app. I've had some success generating QR codes but having trouble directing to a record. Here's my code for the QR code. "<img src=\"http://chart.apis.google.com/chart?cht=qr&chs=120x120&chl="&[QR Code URL]&"\"alt=\"\"/>" where [QR Code URL] is 'https://cfkent.quickbase.com/db/bpc9xkysz?a=dr&rid=[Record ID#] ------------------------------ Howard Fu ------------------------------96Views0likes18CommentsExporting 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 ------------------------------65Views0likes8CommentsMobile button save and add
I have an add record form for a barcoding application. I have one receipt to many objects. Users would enter a receipt then add object records to take a picture of each object and assign a barcode. The button works great in desk top but the record id from the parent doesn't go to the child in the mobile app. any ideas here? code for the button: var text STYLE = "background: green;" & //button color "color: white;" & //text color "text-align: center;" & //text alignment "text-decoration: none;" & //none, underline, line-through "font: 18px Calibri, sans-serif;" & //text size, font, & style "border: 3px solid #505050;" & //border width, style, & color "border-radius: 5px;" & //roundness of button corners "width:100px;"& //button width "padding: 5px 50px;"; //space between text & button var text RID = If(IsNull([Record ID#]),"%%rid%%",ToText([Record ID#])); var text URL = URLRoot() & "db/" & [_DBID_OBJECT_PICS]& "?a=API_GenAddRecordForm" & "&_fid_9='"& $RID & "'&z=" & Rurl(); ------------------------------ Dan McLaughlin ------------------------------31Views0likes5CommentsName and rename pictures and attachments in attachment fields
Is there a way to name a picture attachment as you upload it into a record from the Quickbase mobile app? Also, is there a way to rename an attachment that is already in the record? Quickbase automatically gives it a file name when taking a picture using phone camera with a string of numbers which isn't meaningful. ------------------------------ Brian Hunot ------------------------------31Views0likes5CommentsHiding Green Save button on mobile
Is it possible to hide the save button on mobile? There is an old thread with some iol type advice. Anyone know if this still is a viable option? The reason is - since there is no way on mobile to direct to another URL (ie NextURL), I need to create a custom save button that redirects. I am trying to force my user to use my custom save button. My specific use case is I have a button that takes people to a specific form on a record, in edit mode. When they save, it just automatically lands on the default form in view. ------------------------------ Mike Tamoush ------------------------------30Views0likes3Commentslink to file based of related field in parent table
Hello, I have two tables Project and Documents Project has a bunch of internal information and the documents are supplied by client / staff Each document has a specific type and related to the project via the job number, all associated files relate correctly in a table report, but it is a lot of steps for the staff using mobile devices. What I am looking to do is basically have a URL field that will look at the related project files and the type of the file and provide a hyperlink for easy download / viewing. I have made a hyperlink inside of the child table that opens the correct file, but when i try to lookup that field on the parent it doesn't populate. EG. Projects tab Project number - 12345 Documents tab - Document report: Related Project Type Name URL 12345 Plan file1 working link 12345 Photo image1 working link I would like to be able to move that "working link" for the most recent project (in this circumstance it will be the only plan associated at this time to the project) to the main project page. Thanks for any help ------------------------------ Matt Melrose ------------------------------30Views0likes2CommentsBulk Barcode scanning on the mobile
I am needing to scan a pallet full of barcodes into an inventory system .. does anyone else have experience with doing this using the mobile app? So far, I can only figure out a 3-tap minimum solution of tapping into the field, tapping the barcode button, then tapping save / next. With 300 barcodes to scan, per pallet .. I'm thinking I might just be better off buying a barcode scanner. ------------------------------ Malcolm McDonald ------------------------------28Views0likes11CommentsScroll Down Automatically on Mobile Form
Hello Quickbase Community. Is there a way to get a Quickbase mobile form scroll automatically to a specific place after having reloaded the page? We have a very long form, which will be used from Android phones, the form contains questions which will be answered with two different buttons each, as the user answers the questions they will have to keep scrolling down and answering. I need a way to make Quickbase scroll down to wherever the user was before pressing one of the buttons, so that he doesn't have to manually scroll after each answer. I tried using fragment identifier, by adding for example "#tdf_362" at the end of the redirect URL (see 2nd screenshot), which worked nicely for the desktop view, but didn't work for the mobile view. The buttons update a checkbox field in the background and then reload the page on edit mode, here's the code of one of those buttons. URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" & "&rid=" & [Record ID#] & "&apptoken=xxxxxxxxxxxxxxxxxxx" & "&_fid_206=1"& "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=er&rid=" & [Record ID#]) Here's a screenshot of the form in mobile view: Here's second screenshot which shows error when trying to use the fragment identifier: Just in case this is useful, the error I'm getting in console says: qb.mobile.js:1 Uncaught TypeError: Cannot read property 'is' of undefined at Object.isPageLoaded (qb.mobile.js:1) at qb.mobile.js:1 at Object.execCb (require.js:29) at $.check (require.js:18) at $.<anonymous> (require.js:23) at require.js:8 at require.js:23 at z (require.js:7) at $.emit (require.js:23) at $.check (require.js:19) Thank You for taking the time for reading this post, any thoughts and ideas are appreciated! ------------------------------ Alberto Tablada BlueWell Group ------------------------------28Views0likes6CommentsQR Code Image appearing as broken image on mobile app
I've got an app that is utilizing QR codes for scanning items into QuickBase and the QR codes appear fine when I'm on my desktop but they don't appear at all when I'm on the mobile app. I'm able to scan from the app and click the broken image to go to a record but the actual barcode does not appear. Any idea what the issue could be? My formula to generate the QR code is below for reference: "<img src=\"http://chart.apis.google.com/chart?cht=qr&chs=120x120&chl="&[Product Name] & "\"\"/>" ------------------------------ Niraj Shah ------------------------------25Views0likes0Comments