pierandrea

function assignEditUrls() {
  var form = FormApp.openById('yourFormKey');
    //enter form ID here

  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('yourWorksheetName');

    //Change the sheet name as appropriate
  var data = sheet.getDataRange().getValues();
  var urlCol = ; // column number where URL's should be populated; A = 1, B = 2 etc
  var responses = form.getResponses();

drblue

#!/bin/bash
## Fix OneDrive for Mac CPU usage
## 
## Seems this is still a problem 5 years later after I created this little gist.
## I have long since stopped using OneDrive (luckily), but according to
## comments below, I have added the new path for OfficeFileCache for macOS
## Mojave (10.14) and Catalina (10.15).

## Run this on macOS Mojave (10.14) and Catalina (10.15)
find ~/Library/Containers/ -type d -name OfficeFileCache -exec rm -r {} +

ccstone

---

REFERENCES FOR LEARNING & USING APPLESCRIPT Modified: 2018/06/19 18:47

---

NOTES

AppleScript is a rather peculiar scripting language to learn.

jalcantarab

JSON Puller - Google Apps Script

Transforms the data of a given Spreadsheet Sheet to JSON.

• The frozen rows are taken as keys for the JSON.
• The data taken for the values is only that after the frozen rows

Set up:

exportJSON(Spreadsheet) - transforms the data in the given sheet to JSON.

cannikin

Use Raspberry Pi and Pi Cam for Prusa Connect

I couldn't get the script from p123ad to work on my Pi Zero W 2 with Camera Module 3 (all kinds of ffmpeg errors). There are several built-in tools for working with the camera now, so I tried to figure out if I could use one of those instead.

Behold this version, which uses the built-in libcamera-still tool to actually interact with the camera and save a JPEG. That image is then uploaded to Prusa Connect, same as the original script.

Instructions

1. Go to the Cameras section at https://connect.prusa3d.com
2. Add a new camera by clicking "Add new other camera"