main.js

var facultyURL = 'https://docs.google.com/spreadsheets/d/1p8r5qRrLbDJp1tmBXvZow9ygzn2EVv3f_m0lgONC1HE/pubhtml';

Tabletop.init({
  key: facultyURL,
  callback: processData,
  simpleSheet: true,
});

function mergeNameAndWebsite(name, website) {
  if (!website) { return name; }
  return '<span class="invisible">' + name + '</span>'
    + '<a target="_blank" href="http://' + website + '">' + name + '</a>';
}

function mergeTitleResearchNeeds(title, research, needs) {
  res = '';
  if (title) {
    res += '<h3>' + title + '</h3>';
  }

  res += '<p><span class="emphasis">Research Project: </span>' + research + '</p>';

  if (needs) {
    res += '<p><span class="emphasis">Student Researchers: </span>' + needs + '</p>';
  }

  return res;
}


function emailToLink(email) {
  if (!email) { return ''; }
  return ' <a href="mailto:' + email + '"> <i class="fa fa-envelope"> </a>'
}


function processData(data, tabletop) {
  if (!data[0]) return;

  var processedData = [];

  for (i in data) {
    var r = data[i];
    if (r.Display !== 'y') continue;

    // Add a row to the final dataset
    processedData.push([
      mergeNameAndWebsite(r.Name, r.Website),
      emailToLink(r.Email),
      r.Division + (r['Applying for Public Humanities Collaborative?'] == 'Yes' ? ', Public Humanities Collaborative' : ''),
      mergeTitleResearchNeeds(r.Title, r.Research, r['Student Researchers']),
    ]);
  }

  // Adding custom filtering
  $.fn.dataTable.ext.search.push(
    function(settings, data, dataIndex) {

      // This is a JavaScript object whose keys will
      // be the checked values (e.g. Arts, "Social Sciences")
      showOnly = {};

      $('input:checkbox:checked').each(function() {
        showOnly[this.value] = 1;
      });

      var divisions = data[2].split(',').map(function(x) {return x.trim()});

      for (i in divisions) {
        if (showOnly[divisions[i]] === 1) {
          return true;
        }
      }
      return false;
    }
  );


  $(document).ready(function() {
    var table = $('#results').DataTable({
      paging: false,
      info: false,
      ordering: true,
      data: processedData,
      columns: [
        {title: 'Faculty', width: '120px', className: 'td-center'},
        {title: 'Email', className: 'td-center',  orderable: false},
        {title: 'Division', width: '50px', orderable: false},
        {title: 'Research', orderable: false},
      ]
    });

    $('input[name="filter"]').change(function() {
      table.draw();
    });

  });

  var filters = [
    ['Arts', 'Art'],
    ['Humanities', 'Hum'],
    ['Sciences', 'Sci'],
    ['Social Sciences', 'Soc'],
    ['Public Humanities Collaborative', 'PHC']
  ]

  function renameCheckboxes() {
    var shorten = $(window).width() < 900 ? 1 : 0;
    $('#filters label').each(function(i) {
      $(this).text(filters[i][shorten])
    });
  }

  $(window).resize(renameCheckboxes);
  renameCheckboxes();

}