Posts

Showing posts from April 6, 2019

How to link spreadsheets with Google Script Editor?

Image
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box; 0 I'm trying to link two different spreadsheets - by that, I mean to different Google Spreadsheet files with each other. I want to be able to get data from one spreadsheet and do different functions in another. I already know how to share data between sheets, just not spreadsheets. Would love some help on this. Here's my code below: var app = SpreadsheetApp; // creates application var r_volunteers = app.getActiveSpreadsheet().getActiveSheet(); // creates spreadsheet, then gets active sheet named "raw_values" var housing_roster = app.getActiveSpreadsheet().getSheetByName("housing_roster"); // creates variable for housing roster sheet var totalOfVolunteers = r_volunteers.getLastRow() - 1; // -1 due to row of headers var sorting_range = r_volunteers.getRange(2, 2, totalOfVolunteers, 12

Ray Lankester

Image
Sir E. Ray Lankester Sir E. Ray Lankester in 1908 Born ( 1847-05-15 ) 15 May 1847 London Died 13 August 1929 (1929-08-13) (aged 82) London Nationality British Alma mater Downing College, Cambridge Christ Church, Oxford Known for Evolution, Rationalism Awards Knight Bachelor (1906) Darwin-Wallace Medal (Silver, 1908) Copley Medal (1913) Linnean Medal (1920) Scientific career Fields Zoology Institutions University College London Oxford University British Museum (Natural History) Influences Thomas Henry Huxley, August Weismann, Anton Dohrn Influenced E. S. Goodrich Raphael Weldon Author abbrev. (botany) Lank. Sir Edwin Ray Lankester KCB FRS (15 May 1847 – 13 August 1929) was a British zoologist. [1] [2] An invertebrate zoologist and evolutionary biologist, he held chairs at University College London and Oxford University. He was the third Director of the Natural History Museum, and was awarded the Copley Medal of the Royal Society. [3] Contents 1 Life 2 Career 2.1 Invertebrates and