<div dir="ltr"><div>Hi Eirik,</div><div><br></div><div> I had a very similar issue in our lab and the solution I came up with was to use a combination of pre-printed barcode labels (printed on special labels that are cryo and solvent safe) applied to small (1.7ml) tubes and an app called Scan-It To Office. Scan-It is a subscription app costing something like $5/month per device which depending on how many devices and length of field season can be very affordable. It allows you to VERY easily create custom data input forms within the app that can have many different kinds of data fields including automatically recording GPS coords, date, time etc etc, also can input barcodes, photos and so on. It then stores all records locally on your device (phone/tablet) until you sync it with a spreadsheet. It works with Excel or Google Sheets. Then it will send all of the records to your spreadsheet but maintain the last 1000 records on your phone until you delete them. Hence the data is very safe even if you are not near an internet connection.<br></div><div><br></div><div> The system works very well for us, but there are some downsides. Obviously the way we do it requires one to generate and organize barcodes. In our case we make a unique barcode for every specimen, though of course it could be done many other ways, and indeed you could just generate a unique code each time if you wanted to. One has to be careful about where the cursor is when uploading to the spreadsheet because if you highlight the first cell of an already populated sheet it will overwrite the cells. There are a few other minor issues, but if you are aware of them and plan around them it is an extremely versatile system that is pretty user friendly. If you want any other info I am happy to talk about it with you one on one. We also have an in-house relational database that allows us to connect the unique specimen ID number across spreadsheets and track specimen usage (sequencing) etc.<br></div><div><br></div><div>Eli Wyman</div><div>Kocher Lab</div><div>Princeton University<br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Jan 14, 2021 at 12:56 AM Eirik Rindal <<a href="mailto:eirik.rindal@nhm.uio.no">eirik.rindal@nhm.uio.no</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div lang="NO-BOK">
<div class="gmail-m_-7245171582241618390WordSection1">
<p class="MsoNormal"><span lang="EN-US">Dear all,<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">As a part of our digitization of the workflow in the Collections, we are looking for a mobile app to capture data during fieldwork. So when you collect a specimen, yu can use your cellphone to register data about «coordinate,
date, who collected» and so on. Does anyone have any recommendations in this respect?<u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><span lang="EN-US">We have had a look at the iNaturalist app and are looking for alternativs to this.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal" style="vertical-align:baseline"><span style="font-size:10.5pt;font-family:"Arial",sans-serif;color:rgb(68,68,68);border:1pt none windowtext;padding:0cm" lang="EN-US">Sincerely,<u></u><u></u></span></p>
<p class="MsoNormal" style="vertical-align:baseline"><span style="font-size:10.5pt;font-family:"Arial",sans-serif;color:rgb(68,68,68);border:1pt none windowtext;padding:0cm" lang="EN-US">Eirik Rindal, PhD<u></u><u></u></span></p>
<p class="MsoNormal" style="vertical-align:baseline"><span style="font-size:10.5pt;font-family:"Arial",sans-serif;color:rgb(68,68,68);border:1pt none windowtext;padding:0cm" lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal" style="vertical-align:baseline"><span style="font-size:10.5pt;font-family:"Arial",sans-serif;color:rgb(68,68,68);border:1pt none windowtext;padding:0cm" lang="EN-US">Natural History Museum</span><span style="font-size:15pt;font-family:"Arial",sans-serif;color:rgb(68,68,68)" lang="EN-US"><u></u><u></u></span></p>
<p class="MsoNormal" style="vertical-align:baseline"><span style="font-size:10.5pt;font-family:"Arial",sans-serif;color:rgb(68,68,68);border:1pt none windowtext;padding:0cm" lang="EN-US">P.O. Box 1172</span><span style="font-size:10.5pt;font-family:"Arial",sans-serif;color:rgb(68,68,68)" lang="EN-US"><br>
<span style="border:1pt none windowtext;padding:0cm">Blindern</span><br>
<span style="border:1pt none windowtext;padding:0cm">0318</span> <span style="border:1pt none windowtext;padding:0cm">
Oslo</span> <u></u><u></u></span></p>
<p class="MsoNormal" style="vertical-align:baseline"><span style="font-size:10.5pt;font-family:"Arial",sans-serif;color:rgb(68,68,68);border:1pt none windowtext;padding:0cm" lang="EN-US">Norway</span><span style="font-size:10.5pt;font-family:"Arial",sans-serif;color:rgb(68,68,68)" lang="EN-US"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Tlf: + 47 402 24 872 / 22 85 18 72<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
</div>
</div>
_______________________________________________<br>
Nhcoll-l mailing list<br>
<a href="mailto:Nhcoll-l@mailman.yale.edu" target="_blank">Nhcoll-l@mailman.yale.edu</a><br>
<a href="https://mailman.yale.edu/mailman/listinfo/nhcoll-l" rel="noreferrer" target="_blank">https://mailman.yale.edu/mailman/listinfo/nhcoll-l</a><br>
<br>
_______________________________________________<br>
NHCOLL-L is brought to you by the Society for the Preservation of<br>
Natural History Collections (SPNHC), an international society whose<br>
mission is to improve the preservation, conservation and management of<br>
natural history collections to ensure their continuing value to<br>
society. See <a href="http://www.spnhc.org" rel="noreferrer" target="_blank">http://www.spnhc.org</a> for membership information.<br>
Advertising on NH-COLL-L is inappropriate.<br>
</blockquote></div>