Make your own Office Desk Booking with Apps Script

Build your own Office Booking system with Apps Script

Some context

What we can do with our Office Desk Booking ?

  • Manage a daily quota of presence
  • Manage team and number of persons in team
  • Assign teams per days
  • Book remaning open desks
  • Delete your booking
  • View 2 weeks, current one and next one

How we manage data

function getCustomBooking(){
var data = PropertiesService.getScriptProperties().getProperty('custom_booking');
// console.log(data)
if( data && data != ''){
obj = JSON.parse(data)
obj = cleanOldData(obj);
return obj;
return {}
function setCustomBooking(custom){ 

Deploy application

Get your version




Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

50 VS Code Extensions That Will Make You a Better Developer

Real life React Higher Order Component use case (withLoading)

One Hundred in Javascript Scientific Notation

Bundling Up Your Phaser 3 Games Using Parcel

Implementing a Minimal Angular Material Data Table

Safari Has Become The Second Internet Explorer

Is Safari Browser the Second IE?

Unraveling the Web Components!

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Stéphane Giron

Stéphane Giron

More from Medium

Build web service with Handbag Cycle

Code preparation for Hash Code 2022 with Apps Script

Seamless process automation with Server Side Triggers — UiPath

Making API call from Google Sheet