reportRoles.js

function readRoles(stmt) {
	makeReport(stmt, {
		sheetName: "Roles",
		query: `
      SELECT 
        'Event Director' AS Role, 
        1 AS 'Ideal number of people doing it'
      UNION ALL
      SELECT 'Tuesday Promo', 1
      UNION ALL
      SELECT 'Wednesday Promo', 1
      UNION ALL
      SELECT 'Check-in', 3
      UNION ALL
      SELECT 'Welcome Liaison', 2
      UNION ALL
      SELECT 'Pairing', 2
      UNION ALL
      SELECT 'Rounding Up', 2
      UNION ALL
      SELECT 'Pre Announcements and Cake Admin', 1
      UNION ALL
      SELECT 'Do Announcements', 1
      UNION ALL
      SELECT 'Post Announcements and Cake Admin', 2
      UNION ALL
      SELECT 'Event Reporter', 1
      UNION ALL
      SELECT 'Friday Promo', 1
      UNION ALL
      SELECT 'Be floorwalker', 1
    `,
		formatting: [
			{
				type: "color",
				column: "Ideal number of people doing it",
				search: "",
				color: colors.lightBlue,
			},
		],
	});
}