No project description provided
Project description
SLRs Little Helper
tl;dr: A tool to help with the SLR process.
Installation
# pip install slh-sh
# slh-sh --help
Rationale
Examples
Google APP Script to add links to drive files
function linkToDriveFile() {
var columnRange = SpreadsheetApp.getActiveSpreadsheet().getRange("G4:G203");
var files = DriveApp.getFolderById('11pjqVjFXfsBVjG4CC0mzMSZ2zeLCXNrE').getFiles();
console.log(fileName + ".pdf")
while (files.hasNext()) {
var file = files.next();
console.log(file.getName())
for (var i = 1; i <= columnRange.getNumRows(); i++) {
var fileName = columnRange.getCell(i, 1).getValue();
if (file.getName() === fileName + ".pdf") {
console.log("added" + file.getName())
console.log("added" + fileName)
columnRange.getCell(i, 1).setFormula(`=HYPERLINK("${file.getUrl()}", "${fileName}"`)
}
}
}
}
Tips
- Pause syncing on Google Drive while editing a PDF file.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
slh_sh-0.1.1.tar.gz
(22.8 kB
view hashes)
Built Distribution
slh_sh-0.1.1-py3-none-any.whl
(28.7 kB
view hashes)