Why I use Coda instead of Excel — “I set up calculations” is my close to standard response when asked what I am doing. In Dutch: ‘Ik maak sommetjes’ and then people gaze at me. Let me explain what this means: ‘sommetjes maken’. Most people use spreadsheets, Google Sheets but more often Microsoft Excel. For good reasons I…

Taking a list out of a table and manipulate it elsewhere — I have two tables. One with employees and one with the hours they work per day. Some employees recieve a fixed salary per day worked, while others are paid for the actual hours and as such enjoy also over time when working longer days or in weekends. What I needed…

Filtering on CurrentValue and relate it to other columns — In the blog below I showed how you can use the filter options in a lookup to get results that fit your needs. Coding Look-Ups in Coda as a Pro Using the filter option via a formulahuizer.medium.com The example that comes to mind often is selecting items from a list and each next individual can — as a result of this filter — no…

Privacy Protection, Permissions, Print — PDF & Performance — Coda: a doc as powerful as an app, continually evolving. One wonders why all the app like features Coda blends with document logic do not yet convince most Small and Medium Businesses owners all over the planet. The tool is versatile, smart, good looking and most of all a great…

Bringing data in and distributing it over rows — In my last blog about JSON I described a method that permits for isolating data in a JSON string. The developed logic shown by Eric is based on what look like a kind of Regex for JSON. It is elegant and fast and prepares us for the next step: the…

What is JSON and when do you need it in Coda? — When I started learning how to Coda I assumed that once I could work efficient with Filters and FormulaMap, Sequence and Buttons, I would be able to Coda decently. That is a valid assumption as long as you are not dealing with data that is generated outside your doc and…

Filtering out per active month the dates people worked — The use cases We want to create a table that is filled out with dates people work for the company. Information about employees lives in the table DB Employees and more specially this table contains a ‘start date’ and end date column. Both are important in building up the date range. Case 01 What happens…

Based on payments in previous months — Part II — In my previous blog on monthly Installments I ended with two open issues. First, is there a threshold beyond which we do not withhold? Apparently there is the agreement that at least 80% of a normal monthly salary should be paid out after deduction. Assuming that somebody makes 50 per…

Using a group index and a canvas button — I am aware we have the function Duplicates() at our disposal. Nevertheless, this blog is about a different approach. I apply the logic of the Group Index How to Coda an Index? Making use of the hidden gem Find()huizer.medium.com What I needed was a formula that would show me the rows to remove in a table I pasted as values (plain text)…