Registering sick leave and counting employers contributions — In our previous blog we ended with functions to check if the first working or the last working day of a month is marked as sick leave. In case there a sick leave on the first working day of the month and on the last working day of the previous…

Registering sick leave and counting employers contributions — When employees are absent due to illness, often the employer has to pay for a certain amount of days (or weeks) hence the government takes over. Rules differ per country, but the general idea is that there is some part to pay by the employer and an other part by…

Calculating breaks for bus drivers in the public transport — In my previous blog on the matter if one column (list) with time slots is better than two slots, we concluded that in most cases we are very fine with two. The examples in this blog are based two columns: departure and arrival times. The context My mission was to create time…

Should you use 2 columns if 1 can do the job? — Playing with time tables My co-worker created one column for the departure time and one for the arrival. It looks like below. I call it a time table for humans because it reads easily. You see the name of the line, the departure time, the arrival and the delta.

How to turn the column names into row values — This blog is a follow-up on my previous writing related to the Paperform Pack created by Scott. The main advantage of this (and alike Packs) is that you don’t have to worry about integrations via third parties like Zapier, Make and others. Second it comes with a refresh tool to…

Using the Coda PaperForm Pack from the Coda Guy — Once you use external form builders to get feedback you can choose between various providers like Jotform, Typeform and the one we deal with in this blog: Paperform. I previously used Paperform for some projects and appreciated the tool a lot. The great Coda Maker Scott (on Twitter The Coda…

You might want to replace it by something smarter — Last week I worked on a project that related months and employees to keep track of their paid holidays. The set up I received in Coda looked like below and the maker asked me if this was the way to move forward.

Booking the room and update your ‘stock’ — In my previous blog I showed how via a single button we move selected days towards a table where we can select the combination of our liking. This is the step 3 in the below image.

Select the days with rooms that fit your criteria — In our previous blog we shared the code snippet that allowed us to find the rooms within the budget for a certain number of people. We continue by adding a date picker to only get a sub set. This is important to: have a user friendly solution speed up the…