Find and append new unique values to secondary table
I have an app where I run a daily upload of data (much of it duplicate due to the nature of the source), but sometimes my daily upload includes a new record that needs to be added to a secondary table within the app. The key field in the secondary table matches one of the fields in my daily upload. I have set up a QB action that should identify new unique values in the field related to the secondary table's key and copy these records. But I am running into a problem. Sometimes my upload will include several rows with the same value in the field that I want to use to populate the secondary table's key field . When this happens, my action is registering an error. I only need the value in one of the duplicate lines to write to the secondary table, but I need to preserve all of the lines in the primary table. Any suggestions?
Script a button to print current record to DYMO
I'm finally moving a product pricing process from EXCEL into QB. The last step is giving a user(s) the ability to print product labels from QB to a local DYMO printer. What I had envisioned was a button on the record form that would take a half dozen or so values in the record and push them as values for the label. Has anyone here done this already? If so, are you willing to share any of your scripting? My JavaScript experience is extremely limited. This link is an example of printing to a DYMO via a JavaScript library, but I don't really understand how to set the values of QB fields as the values to send to the printer. http://developers.dymo.com/2010/06/02/dymo-label-framework-javascript-library-samples-print-a-label/ Any help would be greatly appreciated.
Exporting data from multiple tables into a single CSV
Is it possible to export data from multiple tables into a single CSV? My thought right now is to build a 'combined table', and use automations to populate that table with the records I want from the other 4 tables. Then it's a simple report on that new table. Is there a way to accomplish this without actually having all the records in the same table? ------------------------------ Mike Tamoush ------------------------------Any interest in an open source set of SSIS components for MSSQL?
Hello - Wondering if there are other users of Microsoft SQL Server who might be interested in a simple set of SSIS components (connection manager, data source, and data destination)? I realize there's a commercial ODBC driver out there (which looks great), but I found myself in an odd situation where, for specific reasons, buying software is off the table, but investing time is OK. I've already got some basic stuff working and my intent is to polish it up enough to be useful without needing to know the API: Connection manager for attaching Data source for querying Data destination for writing back (No generalized ODBC like integration where you can do mass deletes) For the data source I'm also going to add something I've found useful on other projects, which is emitting "maybe kinda close enough DDL" for generating your target tables (it just abuses SMO). I've already got this working and it applies some basic rules (sanitizing column names, prefacing the individual address fields with the parent name prefix, etc.) as well as does some very rudimentary guesses on data types. It's mean to be an assist, not an operation you completely trust. I already wrote a generalized "auto sync" process that says "get everything from a database" (simple C# app - creates and runs DDL, merges data over, etc.), but I'm in the process of taking subsets of that and putting things into simple SSIS components. Basic SSIS process - set up the connection manager with your API key and select the database, then in the data source, choose your table. That's it. Done. It's meant to be easy. The only "API-ish" bit I'm exposing (mainly because I'm lazy) is the query. For right now I'm planning on that just being a string you enter. (EX: https://help.quickbase.com/api-guide/index.html#samplequeries.html) I don't want to have to get too far into the weeds right now in building a custom UI for that. I'm currently testing on SQL 2016. If anyone else is interested in testing later, please let me know. I'm happy to ship out a sample DLL. Right now I've got the data source implemented as I try to figure out how MS wants the destination written. Code will eventually get to GitHub once I finish wrapping some basic UI elements around things. Thank you, Eric
API Tool In Excel
Here's an Excel based API tool I created that allows you to test various Quickbase API's. It was developed as groundwork for a far more ambitious Quickbase/Excel project I?m working on. So if you need something to create, test, or just play with API?s against your Quickbase apps, this may meet your needs. Enjoy! Ken http://home.surewest.net/firch/Quickbase/QB_API.xls
Automatically Import CSV Files
Are there any options other than Pipelines (using Dropbox or something similar is not an option) that can simply import a CSV file? All I want to do is automate what we can already do manually in QB by selecting a file on the network drive and import. I was doing this 20 years ago in Microsoft Access so surely there is a low code/no code solution to this. ------------------------------ Brett Hinman ------------------------------
"save as spreadsheet" erasing my leading zeros
I have a Text field that contains numeric account numbers that generally start with Zero (ie: 04201345). They show fine in Quickbase, but when i "Save as Spreadsheet", the account number field always erases the leading 0, (IE: 4201345) Is there a way to make sure those Zero's stay all the time? ------------------------------ Jamie Brown ------------------------------transfer data from live to development app
I currently have a live app that my company is working with. We needed to make some new changes to the app so I copied our current live app with all of its data to a test app. From here I have made all my necessary upgrades, how can I now transfer my live data into my test app? I want to do this and then just rename my test app to be the functioning one moving forward. Is this the wrong way of doing this? Sorry still quite new at quickbase.
Exporting 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 ------------------------------