Update "Note" (Shift-F2) for every field following standard format with external link

[lukenoaa]

Every field should have a note that gives enough information to fill out that field. Suggested format with example:

• Field: projectContact
• Description: The list of people and organizations that should be contacted to get more information about the resource, that curate the resource or to whom putative problems with the resource or its data should be addressed.
• Example: Jane Doe, John Doe
• PID: http://rs.tdwg.org/dwc/terms/projectContact

Issues:

1. That PID (http://rs.tdwg.org/dwc/terms/projectContact) is not actually valid, and I can't find a solid reference to projectContact in the DwC docs.
2. To include all the pertinent information (eg, name, address, organization, email, phone) for multiple contacts, would a JSON format work better and make it easier to get onto GBIF? If yes, how to put JSON content into an Google Sheets cell?

[lukenoaa]

@baydenwillms As we discussed this morning.

[baydenwillms]

@baydenwillms As we discussed this morning.

@lukenoaa The closest matches to 'projectContact' I could find in DarwinCore terms (from a CSV file that also includes deprecated DwC terms) are the following: recordedBy, identifiedBy, georeferencedBy, measurementDeterminedBy, bibliographicCitation, and references. Unfortunately none of them are really for contact info. 'references' is used as a citation to a publication. The other terms are related to the physical collection of the data or for citations.

[baydenwillms]

As for the JSON of contact info, we likely cannot attach it directly to a cell as we can with other types of data (for example, the RGB color value of a cell's fill color is an attribute of the cell itself (attribute name backgroundColor), that can be accessed via Gspread):

        # Determine the background color based on the presence of '*'
        if actual_term.startswith('*'):
            bgcolor = Color(0.0, 1.0, 0.0)  # Google sheets Green
        else:
            bgcolor = Color(1.0, 1.0, 0.0)  # Google Sheets yellow

        format_requests.append((**cell, **CellFormat(backgroundColor=bgcolor**)))

but we could easily 'stringify' the JSON to a single line which can be parsed easily, and add that as a comment/note to the cell or as the data value of a cell.

[lukenoaa]

The project contact information will be covered by Miwa's new checklist terms (should be DwC-compatible):

• recordedBy - A list (concatenated and separated) of names of people responsible for the submitted dataset
• recordedByID - A list (concatenated and separated) of the globally unique identifier for the people responsible for the submitted dataset
• institution - An institution having custody of the object(s) or information referred to in the record.
• institutionID -An identifier for the institution having custody of the object(s) or information referred to in the record.

[lukenoaa]

New issue:

• The note for sample_name on the sheet amplicon_prep_data (or its equivalent in the new template) should probably refer the user back to the sheet water_sample_data (or its equivalent in the new template), because it's critical that every value for sample_name in water_sample_data has an exact match in amplicon_prep_data.