Reference Data using bar-codes and an integration

Answered
Avatar
Nick Michailides

Has anyone on here used barcodes to populate reference data from an integration outside of Canvas? I have an instance were we have QuickBase as the primary location for our data and we use Canvas to collect that data and send it into QuickBase. My Question is has anyone used an integration where one may update an existing record rather than creating a new record? Our situation would be to scan a barcode to gather information on an asset and there could be 15 different fields on the form, however, you may only need to update one of those 15 fields. Rather than creating a new record, we would want to just update the existing record living in QuickBase. 

Have any of you come across something like this?

0

Comments

3 comments

Sort by Date Votes
  • Avatar
    Sara Kaplow, Community Manager

    Hi Nick,

    So I don't have a QuickBase account to try this out, but I think it might be possible through Zapier: 

    I'd be curious if anyone has a setup for this already that might be able to share (and I'll ask around here as well). 

    0
    Comment actions Permalink
  • Avatar
    Karen Champion

    I would be interested in how this can be done also.  we need apprentices to submit their hours each month.  we would like to keep a running total of hours spent against a list of work processes and provide a visual bar chart to show progress of hours completed against hours needed to complete for each separate process.

    0
    Comment actions Permalink
  • Avatar
    Sara Kaplow, Community Manager
    • Edited

    Hi Karen,

    Are you using QuickBase also, or would you be open to using another integration? I think what you're trying to do could be done with a Zapier integration to Google Sheets. Here's our help topic about setting up that part: https://help.gocanvas.com/hc/en-us/articles/115006823308-How-to-Use-GoCanvas-with-Zapier. From there, you could set up charts and graphs in Google Sheets based off the data you have coming in, just like you'd do in Excel. 

    0
    Comment actions Permalink

Please sign in to leave a comment.