Discussions

 View Only
Expand all | Collapse all

Scanning including a Save and Add Another

  • 1.  Scanning including a Save and Add Another

    Posted 03-09-2020 19:31
    I have a use case where the goal is to very quickly scan bar codes into a Quick Base table.  The desired workflow is to be sitting on an Add Record form and have the scan also cause the form to save and refresh into the Save and Add Another page, without the user having to click the save button.

    Does anyone have a native or non native way to do this?

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------


  • 2.  RE: Scanning including a Save and Add Another

    Posted 03-17-2020 10:56
    Hi Mark,

    So the desired behavior would be you would hit 'Add Record' and then scan a barcode, it would cause the form to save and go to add another, then you could just repeat a number of times until you had scanned all the barcodes you had in front of you and end up with Item 1, Item 3, Item 3 records?

    ------------------------------
    Evan Martinez
    Community Marketing Manager
    Quick Base
    ------------------------------



  • 3.  RE: Scanning including a Save and Add Another

    Posted 03-17-2020 11:31
    Exactly, the issue here is that there are dozens or hundreds of packages to scan so speed of scanning is the issue.  So scan say 20 bar codes to create 20 records.


    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 4.  RE: Scanning including a Save and Add Another

    Posted 03-17-2020 11:56
    I haven't seen anything like that behavior for mobile as of yet but I can definitely bring it up with the mobile team and see if they have any thoughts. We are doing a survey right now on mobile experience and feedback for 2020 if you haven't put in that as feedback yet I would suggest it too so that it is on their minds. I get the feeling for mobile that would be something they would need to assess.

    ------------------------------
    Evan Martinez
    Community Marketing Manager
    Quick Base
    ------------------------------



  • 5.  RE: Scanning including a Save and Add Another

    Posted 03-18-2020 15:40
    Is your customer/use-case open to the idea of a third-party software and/or barcode scanner?  Does their workflow allow for a computer at their workstation, or is it completely mobile?

    ------------------------------
    Brad Lemke
    ------------------------------



  • 6.  RE: Scanning including a Save and Add Another

    Posted 03-18-2020 15:42
    Open to anything and the staff are on in the office.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 7.  RE: Scanning including a Save and Add Another

    Posted 03-18-2020 16:38
    How I would try to set something like that up would be to use something like the CodeReadr app on a phone, and set it up to be a one-two part scan. 
    • First, scan a qr code on their computer screen.
      • This code would be displayed by the record's form (I can share the code I use to display dynamically generated QR codes within Quickbase), and house the initial api_addrecord url code all the way up to the record ID#.  
    • Then they select the secondary field and scan the item which would complete the code and submit the url.
    In all fairness however, I've only done a little bit of research into the app and played around with their trial version - but it looked promising.

    ------------------------------
    Brad Lemke
    ------------------------------



  • 8.  RE: Scanning including a Save and Add Another

    Posted 03-18-2020 17:01
    OK, thx.  I think there must be some kind of App for that - just got to find it.  Maybe an App can scan a bar code and execute an API_AddRecord call.

    I will check out that app.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 9.  RE: Scanning including a Save and Add Another

    Posted 03-18-2020 17:11
    Mark,

    Please post back your results.   I have a case coming in the near future that will be the same problem.


    ------------------------------
    Don Larson
    Paasporter
    Westlake OH
    ------------------------------



  • 10.  RE: Scanning including a Save and Add Another

    Posted 03-18-2020 18:02
    Surprisingly,  I got this working on iOS using an App Store app called pic2shopPRO.

    It allowed me to enter this URL
    var text AddRecord = URLRoot() & "db/" & Dbid() & "?act=API_AddRecord&_fid_6=CODE"
    & "&usertoken=bxv4tx_wxxxxxxxxxxxxxxxxx";

    which resolves into this

    https://yqc.quickbase.com/db/bqdz8u7jx?act=API_AddRecord&_fid_6=CODE&usertoken=bxv4tx_wve_drafvuxxxxxxxxxxxxxx

    The app will replace with word CODE with the bar code.

    Th work flow seems ot be to scan a code on my phone using the camera function within the app. Then as I did supply an rdr to the URL, it just gives the success message from the API. then I hit the camera function in the app to get back to the camera.

    As soon as the camera sees a valid code it saves the record.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 11.  RE: Scanning including a Save and Add Another

    Posted 03-18-2020 21:09
    Mark,

    Many thanks.


    ------------------------------
    Don Larson
    Paasporter
    Westlake OH
    ------------------------------



  • 12.  RE: Scanning including a Save and Add Another

    Posted 03-18-2020 23:36
    Hi Don, contact me off-line if you want help setting this up.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------