Offline app: turtle tag history

[florianm]

Needs to run stand-alone on a laptop with R and RStudio (set up in office while online). Input: Turtle Tag ID, location Output: tag history, likelihood of correct sighting at given location

[florianm]

Current implementation:

• The exported wastd_data$turtle_tags (as CSV) are uploaded to a Google Sheet under my personal google account and shared with the shared Google account running on our data capture tablets.
• A second sheet is added with a QUERY formula =QUERY(Tags!A:H, "SELECT * WHERE F LIKE '%"&B1&"%'", 0) referencing the turtle_tags sheet. Field B1 is used for the partial search on turtle_tags$name (the encountered tag ID).
• Tablets can install the Google Sheets app, make the shared sheet "available offline" and add a homescreen shortcut.

Now tablet users can open the sheet from the homescreen shortcut, enter a partial tag ID (e.g. just the numeric part, or parts thereof), hit enter, and see relevant information about previous encounters with any tag matching the search string (where&when, tag location on animal and action performed).

TODO:

• add export of the entire state data to the autmoated data export
• use R pkg googlesheets to update the sheet with the tag data

[florianm]

Get https://googlesheets4.tidyverse.org/reference/gs4_auth.html to work out of band

[florianm]

https://cran.r-project.org/web/packages/gargle/vignettes/non-interactive-auth.html setup service token as application default credentials