scan to spreadsheet

Discussion in 'iPad' started by knannow, Jun 23, 2015.

  1. knannow macrumors newbie

    knannow

    Joined:
    Jun 23, 2015
    #1
    I have an excel spreadsheet-- will have a data base in it-- will have 7 or 8 columns of information. first column will have bar code number in it---

    with iPad I want to scan the bar code and I want the iPad to find the correct row / column that corresponds . I want it to find the item/ bar code

    Does this make sense? Help!
     
  2. soupcan macrumors 6502a

    soupcan

    Joined:
    Nov 21, 2014
    Location:
    Netherlands
    #2
    Unless you have an app for that, it can't do that on its own.
     
  3. knannow thread starter macrumors newbie

    knannow

    Joined:
    Jun 23, 2015
    #3
    you mean an app that does what exactly? Do you know one?
     
  4. ApfelKuchen macrumors 68020

    Joined:
    Aug 28, 2012
    Location:
    Between the coasts
    #4
    You want to use the camera in the iPad to scan a bar code, then automatically find the matching data record in the spreadsheet?

    There are apps that may do what you need, but perhaps not exactly in the way you envision - you'll have to read the descriptions and perhaps spend a few dollars to try them out.

    I searched the App Store for "spreadsheet bar code" and found several apps designed for inventory management that will create a new spreadsheet file that you can export. I also found one that may be what you're looking for "Csv File Editor with Import Option from Excel..." What's not clear to me is whether it will automatically search the spreadsheet, or whether you'd have to copy the code and paste it into the spreadsheet search feature.

    There may be another way to approach this, which is to use an app like Workflow. With that, you may be able to create a single script (sequence of steps) that you can run as if it was a single app - scan the bar code with a bar code app, copy the number to the clipboard, switch to the spreadsheet app, paste the bar code into the spreadsheet search, and execute the search.
     

Share This Page