A Coda puzzle with a subtle complexity — After finishing my second blog on sick leave about a month ago, I felt relieved for a few reasons. First of all I was happy that it all worked well, but also I was happy to escape the Coda inertia. …

A step by step guide to calculate regular time in your team — While I was reviewing parts of my code related to over time I noticed that it easily gets complicated, even when you do this on a regular basis. This blog intents to show in a few simple steps how you can create your own set-up to understand the regular hours…

Tips to make multiple rules work together — While finishing my archiving logic, more about it here and here, I had to make sure that the HRM employee could only unpack employees active this month or last month. While writing this part, I noticed I had to foresee additional limitations to avoid an unwanted data mix up. …

Using a button to retrieve your data smoothly — Why retrieving payroll data? In my previous blog I’ll explained how you can archive data. We had 8 columns with data per employee and stored this set of data in a single cell per employee related row. Once the payroll data is archived, the HRM employee has max one month to make changes, while…

Using a button to store a list of data in a cell — Our previous blog was about how to transfer the thisRow logic into a CurrentValue logic to make use of filters in a table on a canvas or in a button. …

Work smarter due to a clean approach — In many of my larger projects I use canvas buttons to update rows or if the match value is not yet present, to add a row. In the Coda Community it has been argued that one should better not use AddOrModifyRows because: The reason for that is that you’re more…

Compensating office hours, extra hours, weekends, holidays — In our previous blog we showed two ways of dealing with over time during a weekday. In one approach days with less hours will be compensated by over time before being paid out. In the second approach, we always pay overtime regardless of days with less hours. Complexity requires reflection…

Compensating office hours, extra hours, weekends, holidays — Not all hours are equally paid for all people. Often blue-collar worker get paid more during weekends and even more on on holidays. In case a holiday equals a weekend day, the pay ratio for holidays is taken. In Part I of this exercise we show how to use a…

Registering paid and unpaid leave — In our previous blog we focused on counting the days per month an employee takes sick leave. Happily most people enjoy paid holidays to stay home and they consume their days over a year in agreement with the employer. Accumulating paid holidays The basic business rule is easy. Each year you start fresh…