info-edit

edit markdown captions stored in Google Sheets for infographics

Goal

One of the hurdles with infographiq development has been easy editing of captions and other text based content. Presently content contributors need to enter formatted text as markdown into the cell of a Google Sheet. We promote the eventual adoption of a content management system like WordPress to handle this aspect. Meanwhile we can rapidly prototype this functionality using the Shiny application development framework in R. This will enable editing of captions as markdown currently stored in Google Sheets from a simple app that provides a toolbar (Figure 2) for users to format text, such as species names in italics, bold for emphasis, bullets for lists and links. The Shiny app will read and update the appropriate Google Sheet cell using the googlesheets4 R package.

Example what you see is what you get (WYSIWIG) toolbar available from the shinymarkdown R package from a Shiny app.

Example: Olympic Coast National Marine Sanctuary

• Google Sheet: Master_OCNMS_infographic_content