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.commark.shnier@gmail.com------------------------------
Original Message:
Sent: 03-18-2020 17:10
From: Don Larson
Subject: Scanning including a Save and Add Another
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
Original Message:
Sent: 03-18-2020 17:00
From: Mark Shnier (YQC)
Subject: Scanning including a Save and Add Another
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
Original Message:
Sent: 03-18-2020 16:38
From: Brad Lemke
Subject: Scanning including a Save and Add Another
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
Original Message:
Sent: 03-18-2020 15:41
From: Mark Shnier (YQC)
Subject: Scanning including a Save and Add Another
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
Original Message:
Sent: 03-18-2020 15:39
From: Brad Lemke
Subject: Scanning including a Save and Add Another
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
Original Message:
Sent: 03-17-2020 11:56
From: Evan Martinez
Subject: Scanning including a Save and Add Another
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
Original Message:
Sent: 03-17-2020 11:30
From: Mark Shnier (YQC)
Subject: Scanning including a Save and Add Another
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
Original Message:
Sent: 03-17-2020 10:55
From: Evan Martinez
Subject: Scanning including a Save and Add Another
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
Original Message:
Sent: 03-09-2020 19:30
From: Mark Shnier (YQC)
Subject: Scanning including a Save and Add Another
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
------------------------------