Changelog

Versions read BETA release.major.minor (for example 0.9.3 = release 0, major update 9, minor update 3).

BETA 0.10.1

  • Rules rebuilt. You can now edit existing rules (Edit opens them in place), as well as duplicate them, move them up and down, and turn them on or off.
  • Conditions: hirer type, space, day of the week, start time, end time, length, date range, how far ahead it's booked, number of people, booked through (public form or staff) and under-18s. Each has "is / is not" or "at least / less than" options.
  • And / or: every condition in a box must match, and an "or" box adds another set of conditions that also counts. A rule with no conditions applies to every booking.
  • New actions: set the rate (£ per hour or day), set a fixed price, add a £ fee, and set a maximum length. These sit alongside discount, surcharge, minimum length, require approval and not bookable. Not bookable can show your own message.
  • Order matters for price rules: if more than one matches, the highest one in the list wins. Everything else adds up.
  • Check a booking: try a booking to see which rules apply and what it would cost.
  • Existing rules carry over automatically.

BETA 0.10.0

  • Analytics opens from Home and the top switcher. It has an Overview plus Bookings, Room usage, Visits, Equipment, Income, Hirers and Hire requests sections. Each starts with number tiles, with charts below.
  • Date ranges: Today, This week, This month, This term (from the Programmes term dates), This year, Academic year and Custom. You can compare with the previous period or the same time last year (▲/▼ on the tiles, dashed line on the charts).
  • Filters for each section: space, hirer type, booking status, equipment category, visit type, and staff member or department.
  • Every chart and table has a CSV button. Print / PDF report prints all the sections you can see for the chosen range.
  • Income shows Quoted, Paid (invoiced bookings count as paid for now), Projected and Refunds (separate).
  • No-shows: the kiosk flags a booking when no hirer has signed in X minutes after the start. Staff confirm or clear the flag in Analytics → Bookings, and only confirmed no-shows are counted.
  • Users & notifications: new Analytics access for each person: Full / View (no income) / Off. Default: admins Full, staff View.
  • Admin → Reporting → Analytics: when the academic year starts, and how long to wait before flagging a no-show.
  • Version label now reads BETA 0.10.0.
  • Live data: Analytics reads real bookings, sign-ins (including staff), loans, faults and invoices. From this version it also records new information: when and how each booking was made, cancellations (late if inside the lock-in, plus refunds), moves, approvals and declines with response time. Bookings, cancellations and requests from before 0.10.0 have no lead time or response time.
  • Cancelling a whole series keeps the dates that already happened in Analytics.
  • Possible no-shows: hire bookings from 5 October 2026 where no hirer signed in (by booking code or matching name).
  • Server (Code.gs): new saved keys anLog, anNs and anCfg. Staff can save anLog and anNs. Users now get anAccess. Public hire requests are stamped with when they were made. Redeploy Code.gs as well as App.html.

BETA 0.9.6

  • Version label now reads BETA 0.9.6.
  • New default logo: the RM Nexus wordmark (dark on light, white in dark mode). Reset in Admin → Logo returns to it.
  • Accessory quantities are per item and scale with how many are booked. Bundled = fixed amount; Optional = a maximum, and hirers pick 0 up to it with −/+ buttons (public hire form and staff add-on amendments).
  • Shared stock: an item's total is shared between the main add-on list and accessories in the same booking. The + buttons stop when stock runs out, with a short reason (e.g. "No more mic stands left to go with another one").

BETA 0.9.5

  • Version label now reads BETA 0.9.5.
  • Accessories on resource items (bundled or optional, own stock and serials), offered to hirers and handled in add-on amendments.
  • Pricing: charge each space hourly or by the day, with "A day covers up to" hours.
  • New booking panel: Confirm and Hold buttons, and equipment add-ons.
  • Kiosk: bookings awaiting approval can be hidden from or shown greyed out in the hirer list (Admin → Reception kiosk → guest codes).
  • Logo: four more brand colours, custom SVG mark upload, background width up to 128px.
  • Website widget: customise the time row and the space column.
  • Layout: pinned, more compact headers across Admin, Programmes and Resources; side-by-side sections on Organisation, Spaces, Hours and Display/UI; hire page progress bar, compact header, two-column Time and Details steps, equipment in its own scrolling panel, pinned requirement notice; "Review request" when payments are off.
  • Kiosk: a booking's guest code only works for visitors ("I have an invite code") once the booking is approved. Codes for bookings on hold or awaiting approval are rejected with "This booking hasn't been confirmed yet. Please speak to a member of staff.", on both the visitor and hirer routes.
  • Email tags: the Add-ons changed tags ({addon_changes}, {addon_reason}, {addon_list}, {addon_money}) now show in the preview and the tag picker. {reason} is filled from the reason staff give when moving, editing or cancelling a booking; choosing "No" to emailing the hirer is now respected by the server. {refund} is filled on cancellations when money was paid. Totals show pence correctly. Bundled accessories read "(included)" in {addon_list}.
  • Saved settings: day rates ({rateMode}, {dayRates}, {dayLen}) and cancellation notes are now saved to the sheet and sent to the public page.
  • Spaces: Bookable, On schedule and Public hire are separate. Shown-but-not-bookable spaces appear as unavailable.

BETA 0.9.4

  • Building log now includes staff sign-ins (Staff badge, role and department), with a Staff count tile. Staff in the building are part of the fire roll call and its printout, and can be signed out from the log.

BETA 0.9.3

  • Add-ons changed email: when staff amend a booking's equipment and tick "Email the hirer", the hirer gets the changes, the reason, their new add-ons and total, and any refund timing. Editable under Email templates. Staff also get a "Booking changed" notification.
  • Version label now reads BETA 0.9.3.
  • Equipment add-ons: shown in the booking panel with a price breakdown, added automatically to invoices created from a booking, and available as an "Equipment add-on" picker on invoices (items priced above £0).
  • Amend add-ons on a booking: change quantities, remove or add kit, give a reason, optionally email the hirer. Updates availability, the booking total (shows any refund due), draft invoices, and keeps a change log.
  • Resources → Upcoming hires tab: equipment booked on hires, grouped by day, with shortage warnings. Click through to the booking.
  • Programme kit lists in two columns.
  • Booking panels are full height on their own layer, with the calendar dimmed behind; notifications float without pushing the page.
  • Building log → Columns → Fire roll call print: choose which columns print during a roll call (In, Out and Date off by default).

BETA 0.9.2

  • Resources: the page header and toolbar stay pinned while lists scroll.
  • Check equipment pop-up: wider, pinned header, room kit in three columns and add-ons in two.
  • Faults open on Open and Loans on Out by default. Fault colours: Open blue, In repair Raw amber, Fixed green, Condemned red. Hover and press feedback on fault and loan buttons.
  • Loans: Lost or stolen is its own button next to Mark returned.
  • Condemned and lost units are retired: greyed out at the bottom of the unit list, not counted in quantity, lending or clashes. Found-and-returned or un-condemning brings them back. Fault records can be deleted (with undo).

BETA 0.9.1

  • Resources: Where it can be used. Each item has a home location and an Allow / Default / Disallow switch per room. Portable kit is allowed everywhere by default; room kit only in its home room. Disallowed rooms don't show the item on their hire card or as an add-on, and programme kit warns if a session's room isn't allowed.
  • Email templates: "Loan overdue" and "Loan return receipt" are added automatically to saved settings that came from v8.
  • New exportProgrammes() fills the Raw Spaces · Programmes workbook with readable tabs so it can become the Programmes Sheet.
  • Drive permission widened to full Drive (needed to create the data folder and workbooks).

BETA 0.9.0

Versioning restarts as a beta ahead of the full launch.

Data split into workbooks. Admin, Spaces & Visitors, Programmes (your Programme Manager Sheet), Resources and Analytics each have their own workbook. Records are one row each, settings are JSON, and only what changed is written. The Audit log is in Admin only. Records older than 24 months are archived each morning. Run migrateToV9() once to copy the v8 data; the v8 Sheet is kept as a backup.

Resources (new section).

  • Inventory by room plus portable kit, with photos, make/model, value, last checked, manual link and notes. Compact, Relaxed and Grid views.
  • Optional per-unit tracking: serial number, asset tag and condition for each unit, so you know exactly which one is on loan.
  • Faults: Open → In repair → Fixed, or Condemned (marks the unit out of service).
  • Loans to staff or participants: contact details, due date and deposit (£ or % of the item's value). A loan details panel. Returns record condition with a note, and a full, partial or kept deposit (damaged, lost or stolen items keep at least 10% by default). Lost and found-and-returned tracking.
  • Return receipts and overdue reminders are emailed to borrowers, with refund timing. Staff get new-fault, overdue and returned alerts.
  • Kit for programmes: a default for every session and per-session changes, with clash warnings.
  • Public hire: "Check equipment" lists each room's highlighted kit, and hirers can add priced extras to a booking.
  • Access per person: Full access, Report & lend, or No access.

Also: Admin tile on Home and Admin in the top switcher; separate sending addresses for Spaces & Visitors and Resources; notification emails grouped by section; new Loan overdue and Loan return receipt email templates; the website widget reads the new workbooks.

v8.3

  • Home: an Admin tile next to Resources and Analytics (2 tiles on top, 3 below), plus Admin in the top switcher. The Admin tab is removed from Spaces & Visitors. Programmes and Admin icon squares are fixed to Raw purple and black.
  • Guest codes (Reception kiosk → Guest codes): set a prefix, suffix, characters (numbers / letters / both), fixed or random length, and whether to leave out look-alike characters. New bookings get a unique random code; existing bookings keep theirs.
  • Kiosk Hirer form: booking code box (Don't ask / Optional / Required). A matching code shows the session, fills in the name, and the hirer ticks to confirm. Hirers who confirm a code skip "Which booking are you here for?"
  • Emails: new {booking_code} tag. The default Confirmation adds a "Have a group?" line with the code.
  • Fixed: the Sign in button on the kiosk agreement step is back to normal size; going from Admin back to Spaces & Visitors no longer gets stuck.

v8.2

  • Kiosk: new School group sign-in (after Participant). Teachers and helpers (add as many as needed), number of pupils, rough age range and whether they have a register. Counted as one entry; pupils and teachers are added to the In the building total. Fully customisable under Reception kiosk → Sign-in fields → School group form (wording, which questions, required, age choices), and your own fields can be ticked for School group.
  • Kiosk: visit types show 3 + 2 in landscape, 1 / 2 / 2 in portrait. Shorter header and smaller logo on every screen except the start screen. Staff screen renamed "Employees", smaller heading beside the search. In/Out switches are rounded rectangles; rows are tighter.
  • Kiosk: the access question is now labelled "Access needs" with the full wording as a tip.
  • In the building: tiles that make up the total are highlighted; School groups, Under 18 and Access needs are greyed and moved to the end. New Teachers and Pupils tiles.
  • Building log: School group columns (teachers, pupils, age range, register). The Visitors sheet tab and sign-in emails include them too.
  • Public hire: each space card shows capacity, optional tags and extra buttons (web link, download, or Check equipment). Set them in Admin → Spaces → Public hire card. The header and step tracker stay pinned at the top, Back / Continue at the bottom.
  • Programmes: edit panel header stays pinned; rows and cards highlight on hover and when selected; icons on Add programme and the Compact / Relaxed / Grid buttons.
  • Start screen: Resources and Analytics tiles added as "Coming soon" (hidden from the public). Tiles stay in 2 columns.
  • "People & notifications" renamed Users & notifications. Terms & policies table aligned. Name examples read "e.g. John/Jane Doe".

v8.1

  • Website widget: the time row and space column are shaded so they stand out (day, week and month).
  • Kiosk buttons have icons (choose per button, or None).
  • New kiosk question "I may need help to leave the building in an emergency" (on by default for everyone; edit or turn off in Sign-in fields). Shows an "Access needs" tag with a wheelchair icon in In the building, the fire roll count and the printed list.
  • Fixed: after signing out, Sign in did nothing and returned to the start screen. Sign in now opens Google's account chooser and then the staff deployment. Switch account and Sign out land on the chooser too, never back on an anonymous page. The old appengine sign-out step has been removed.
  • CONFIG.STAFF_URL must now be set to the staff deployment's /exec link (a warning is logged if it's blank).

v8

  • Super admins: only super admins see People & notifications and the protected settings (Staff, Spaces, Hours, Hirer types, Pricing, Rules, Terms & policies, Reception kiosk, Building log, Privacy & data, Public access, Integrations). They can give each admin extra areas. The server enforces it. Until someone is ticked as super admin, every admin keeps full access.
  • Lock-in (Terms & policies → Changes & cancellations): bookings lock a set number of hours or days before they start. Staff (and optionally admins) can't move, edit or cancel them; the server puts locked bookings back. Hirers see the notice before booking.
  • Rich text for Terms & Conditions and arrival instructions: bold, italic, underline, H1–H3, bullet and numbered lists, indent and links.
  • Proof for each rate (Hirer types → Proof needed): member code (checked on the server, never public), charity number, company number, email ending or a question. The hire page shows rates as cards with what each needs, and staff see the proof on the booking with a register link and "Mark as checked".
  • Google Calendar: calendars live in one account. Each person chooses Off, Shared calendar or Invites for their bookings (account menu), and super admins can set it for anyone (Integrations).
  • Side menus in Admin and Programmes collapse with «. Side menu colour: Default, Darker or Raw orange (Display/UI).
  • Start screen background: theme, solid colour or a dimmable image. The two buttons keep their look.
  • Kiosk thank-you screen wording is editable.
  • In the building follows the Settings width setting.
  • Sliders drag smoothly.
  • Website widget: day, week and month views, and padding, corner roundness, background and border (Admin → Website widget).

v7.2

  • Programmes view-only: a "View only" banner is always shown. Only Programmes, Calendar and Term dates are visible. Add programme, Publish to website, Last published and Archive programme are hidden.

v7.1

  • Fix: people with Spaces “Public view” and Programmes access now open Programmes properly, and the schedule no longer shows underneath it.
  • Fix: Switch account / Sign in no longer show Google's “unable to open the file” page. They sign out first, then return to the app.
  • Security: programmes-only and public-view accounts no longer receive booking, visitor or settings data.

v7: 1 October 2026 (first upload to GitHub)

  • Account menu (top right): switch account, sign out, and sign in for the public.
  • Public view for anyone without Raw Material access. Admin → Public access chooses Schedule / Public hire, busy-only or titles, and booking from the schedule.
  • Booking several spaces at once (Admin → Rules), for staff and for public requests.
  • Staff bookings can be saved as Pending / reserved.
  • Invoices: emailed with a PDF attached, Stripe Payment Link, uploaded logo, price-list / discount / already-paid presets, and paid invoices marked PAID with no payment details.
  • Card payments are off: requests are invoiced instead.