So an app with hooks into your local DB, using the QR code as the key. You wouldn't want to keep it in excel because updating that from a mobile app would be a pain in the dick.
Also tie it into whatever task-tracking app you're using, so you can get info on what you're supposed to do to the thing you're looking at.
That seems fairly straightforward, honestly. Unfortunately I don't do mobile app development.
Yeah, that pretty well defines the problem... I was flabbergasted when I started grad school that nothing existed to accomplish this, but I've looked and it all falls well short. Graduated, so... Should use my degree and experience for something!
MS Access is almost taboo in the sciences for some reason, but realistically should be the ideal for this, especially how standardized this should be.
I think part of the dominance of Excel is that what you see is what you get, and everyone has experience with it in undergrad, even researchers from China.
In terms of task tracking, a notes field, and Outlook calendar would be the common ones.
Access is shit. If I were doing this, I'd probably go with Mongo. Less problems if you have specimens that have different field requirements, etc.
A notes field directly in whatever DB solution you use wouldn't be ideal unless you included some way to futz with it in the app. A better way might be to tie into Jira or some other task tracker, though I'm not sure how feasible that would be... you'd want it to do task lookup based on QR and user, presumably.
(post is archived)