UPC FORMULA

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • Answered
Hi all. I need help with UPC Formula. I would like to scan a UPC and have it populate in a Field. Can anyone provide me with this formula please. I'm new to Quickbase. Thanks in advance for your assistance!
Photo of Nalin Chandra

Nalin Chandra

  • 120 Points 100 badge 2x thumb

Posted 3 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,786 Points 50k badge 2x thumb
A UPC is just a text field.

If you purchase a low cost device you can typically attach it in line with your keyboard. They are often called "wedge scanners" as they simply,y replace the data entry method of typing into that particular field.
Photo of Nalin Chandra

Nalin Chandra

  • 120 Points 100 badge 2x thumb
Thanks for your quick response Quickbase Coach. I scanned it under Text Field and nothing is populating. 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,786 Points 50k badge 2x thumb
Maybe you have a hardware problem. Can you scan to word or excel?
Photo of Nalin Chandra

Nalin Chandra

  • 120 Points 100 badge 2x thumb
Does not work on Excel and on Word. I'm trying to scan S/N on a radio. It has a bar code with 15 number/letters
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,786 Points 50k badge 2x thumb
Sounds like a hardware problem. Not a Quick Base problem.
Photo of Govind Anand

Govind Anand

  • 124 Points 100 badge 2x thumb
Hi Mr.QuickBaseCoach, sorry to interrupt in this thread but i am really stuck in a problem with resetting a dropdown on whenever another dropdown changes. Please help me. I am new  to quickbase and tried Form Rules for achieving this but couldn't make it.    Thanks You.
Photo of Nalin Chandra

Nalin Chandra

  • 120 Points 100 badge 2x thumb
Hi QuickbaseCoach. I have 1 last question, hopefully. Scanning works now :) I need to have a checkout table. I want to scan employee's badge and to have info populate from employee table. how would I go about doing this?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,786 Points 50k badge 2x thumb
Whatever you are scanning will need to be set as the Key field to the table. Typically employees in a company are assigned and Employee number which is also used for payroll purposes. If you are fortunate, that will be the bar code for the badde.

But if you are going to scan, the. There is a trick as you will be doing direct Entry of the Employee number and not using a drop down field. I’m going to look for a previous post I did and come back here.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,786 Points 50k badge 2x thumb
Here is a link to the post I was looking for

https://community.quickbase.com/quick...