mhawksey

function getJSON(aUrl,sheetname) {
  //var sheetname = "test";
  //var aUrl = "http://pipes.yahoo.com/pipes/pipe.run?_id=286bbb1d8d30f65b54173b3b752fa4d9&_render=json";
  var response = UrlFetchApp.fetch(aUrl); // get feed
  var dataAll = JSON.parse(response.getContentText()); //
  var data = dataAll.value.items;
  for (i in data){
    data[i].pubDate = new Date(data[i].pubDate);
    data[i].start = data[i].pubDate;
  }

luetkemj

// This gist is now maintained on github at https://github.com/luetkemj/wp-query-ref

<?php
/**
* WordPress Query Comprehensive Reference
* Compiled by luetkemj - luetkemj.github.io
*
* CODEX: http://codex.wordpress.org/Class_Reference/WP_Query#Parameters
* Source: https://core.trac.wordpress.org/browser/tags/4.9.4/src/wp-includes/query.php
*/

hubgit

function listFilesInFolder() {
  var folder = DocsList.getFolder("Maudesley Debates");
  var contents = folder.getFiles();
  
  var file;
  var data;
  
  var sheet = SpreadsheetApp.getActiveSheet();
  sheet.clear();
  

jo-snips

<?php 

$args = array(
  'post_status'=>'publish',
  'post_type'=>array(TribeEvents::POSTTYPE),
  'posts_per_page'=>10,
  //order by startdate from newest to oldest
  'meta_key'=>'_EventStartDate',
  'orderby'=>'_EventStartDate',
  'order'=>'DESC',

mogsdad

Google Calendar Utilities

getEventsWithGuest

Gets all events that occur within a given time range, and that include the specified guest email in the guest list.

###Parameters:###

codearachnid

<?php
/**
 * setup when your post type is saved to add _EventStartDate & _EventDuration 
 * meta fields add your own post types (line 10) to mach filters for the meta 
 * data. Then use tribe_get_events to query both all desired post types (be 
 * sure to set for future status)
 */
function extend_events_startdate( $post_id ){
  //verify post is not a revision
	if ( !wp_is_post_revision( $post_id ) && in_array( get_post_type( $post_id ), array( 'post' ) ) ) {

hisnipes

<?

  // Gravity Form Hook to SQL Database for Today's Dishes //
  // the ### in gform_pre_render_### locates the id of your form //
  
  add_filter('gform_pre_render_5', 'todays_dishes');

  function todays_dishes($form){
      
      foreach($form['fields'] as &$field){

daichan4649

function convertSheet2Json(sheet) {
  // first line(title)
  var firstRange = sheet.getRange(1, 1, 1, sheet.getLastColumn());
  var firstRowValues = firstRange.getValues();
  var titleColumns = firstRowValues[0];

  // after the second line(data)
  var lastRow = sheet.getLastRow();
  var rowValues = [];
  for(var rowIndex=2; rowIndex<=lastRow; rowIndex++) {

varun-raj

function pullJSON() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheets = ss.getSheets();
  var sheet = ss.getActiveSheet();


  var url="http://example.com/feeds?type=json"; // Paste your JSON URL here
  
   var response = UrlFetchApp.fetch(url); // get feed
  var dataAll = JSON.parse(response.getContentText()); //

RadGH

/* 

Based on: http://wordpress.stackexchange.com/questions/42652/#answer-42729

These functions provide a simple way to interact with TinyMCE (wp_editor) visual editor.
This is the same thing that WordPress does, but a tad more intuitive.
Additionally, this works for any editor - not just the "content" editor.

Usage: