search

nwfsc-auv / database-ps

NWFSC AUV Program Postgres database
0 stars 0 forks source link

Add Hyperlink to WoRMS for AUV Species Table #3

Closed Curt-Whitmire-NOAA closed 1 year ago

Curt-Whitmire-NOAA commented 1 year ago

@Curt-Whitmire-NOAA developed a Google Apps Script on the AUV Species Table to add a hyperlink to any numeric value under a column named "Aphia_ID". I've tested this on both the Inverts and Fish sheets.

When a user opens the Species Table, the script adds a new menu to the top labeled "AUV Tools" with a single tool called "Add Hyperlink to WoRMS". If the user adds an additional row for a taxon on either sheet, and specifies a numeric value for Aphia_ID, the user can click on the tool and the script should add a hyperlink to that cell.

Curt-Whitmire-NOAA commented 1 year ago

The App Script code lives within the Google Sheet, and can be accessed by clicking on the Extensions menu, and then selecting "Apps Script".