Reference Data using bar-codes and an integration

Answered

Follow

Nick Michailides

• February 26, 2019 16:19

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

• 

  Sara Kaplow, Community Manager

  • February 26, 2019 17:06

  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

  Permalink
• 

  Karen Champion

  • March 27, 2019 04:24

  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

  Permalink
• 

  Sara Kaplow, Community Manager

  • March 27, 2019 13:33
  • 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

  Permalink

Please sign in to leave a comment.