Blogs

Holiday compensation visible on the holiday balance

How to set up and maintain the yearly holiday balance?

Integrating official holidays per country

Modify rows using a button

Relate work schedules to time off

Using forms to capture data

Exploring alternative approaches to assess currentValue

Working schedules in action — introduction

Extract info from your pdf files with smart prompts

Steps to read out your large files in Coda

Create a doc with one tasks only: notify

Turn your transcript interactive

When the row changes and there are multiple users

An normative view on Coda usage part I — intro

Respect the layout while replacing multiple variables

The need to transpose — for pro users only

Use RegexExtract to validate the zip value

Create linked references in your table

Using RegexExtract() to get a searchable text — part I

Use the RelativeDate() function and a start date

A simple solution easily implemented

while dealing with overlap and gaps

Selecting only from available slots

Turn Coda into your daily buddy

Only get alerts when you want them

Can we use Coda for resource planning?

Split data entry from data viewing: no more modals

From spreadsheet to tables

The upgraded version of Substitute()

Simplify your Coda formulas using a button

A solution to merge variables with a template preserving style

Why you need getting started with Regex in Coda

A remedie to inefficient spreadsheet logics

Be careful with tables and keep focus

3 simple steps to keep track of your time

Why difficult is easier than complexity, which is costly

Comparing dates and using filters

Nothing can be hidden in a doc as powerful as an app

Using a time stamp in a table to identify a time related position

An advanced find & replace logic partly based on Regex

Why date time data is essential in your set up

Get the most recent price applying a BOM logic

Keep them up to date using a BOM logic

Get always the most recent address

The advantages of well defined and interlinked data containers

Limiting the options for the users intelligently

Shorten and simplify your code

Using CFL to solve a long standing problem

When a user forget to fill out essential values

a comma instead of a full stop

Based on a public challenge

Clean your date before feeding it to a planner

How to show users the items in the language of their choice?

The first letters of your middle names in legal documents

based on a public puzzle

What is 100K worth today when you receive it in 10 years?

Using AI to get results Duration() does not provide for

Learning from a great example

instead of calculations and complex business cases

Manipulate your prompt intelligently on purpose

Wordings differ, similarities are striking, but all three are different

items, lists, sorting and filtering

single and composed variables

Excellence is not an act but, a habit

Practical tips to get the results you ne

what you need to know

correct calling and full names with AI

show specific error messages

One way sync or a two way sync, you may need it

when your weekend is not a Saturday and Sunday

2 Way sync is coming → sync your data as a pro

Use patterns you can repeat and adapt

something simple going wrong easily

How to get rid of deleted items still living in your lookup?

An alternative for Coda cross docs to sync tables

Only notifications on the day you work.

alerts in time and not in the weekend

lower the floor using a simple function

select carefully and avoid complexity

Why notifications may be the better option

Add or update rows in your target doc using a webhook

How to use the webhook trigger to relate tables in two docs.

When your data stream is irregular

How to integrate feedback

Why a button is your friend to track changes

Simple & more complex cases

distributing a single item or multiple items over rows

How to replace thisRow in a Filter?

In the Coda community one looked for a check box logic. My contribution results in something you see below. I used buttons and they behave…

hire date + 90 days

when your tasks have overlap and you need periods

Replace a checkbox with counted values via a lookup

this month, last month and next month

This week, last week or next week?

When you have plenty of months to evaluate

Planning based on days and weeks (not months & years)

Dealing with irregular intervals in our planning

automatically generated via an automation

The powerful list logic applied using Slice()

Update monthly overviews with a single click

Use dates to filter and keep track of changes

Using intervals

Pick your projects with prudence and keep focus

Select your code wisely

Based on irregular working schemas

Dealing with vacations covering multiple years

to delete checked rows older than 30 days

Counting the checked boxes

Use Sum() and Product() to get a visual coherent outcome

Enable Coda to deal with your amounts in Europe and Asia

Enjoy the Filter Power in the CFL

converting days into hours

An alternative approach that works for reservations

work with Remainder() to get your filtered sub set

Replacing part II of Workday() — part 02 & final part

Replacing part II of Workday() — part 01

Replacing part I of Workday()

Employee contracts in various formats

Using info living in table to present data on the canvas

The more you buy the less you pay per unit

How to plan the distribution of the children?

Multiple transfers per day

Holidays and changing periods

Using the file link you create with ParseJSON

Using value for New Rows

When see the children their parents?

Contact people and let them make choices

Filtering on CurrentValue and relate it to other columns

Privacy Protection, Permissions, Print — PDF & Performance

Bringing data in and distributing it over rows

Applying basic JSON knowledge in Coda

What is JSON and when do you need it in Coda?

Filtering out per active month the dates people worked

Based on payments in previous months — Part II

Using a group index and a canvas button

Keep track of changing VAT, Salaries etc.

When cash is king and you need rounded numbers

Based on payments in previous months — Part I

Coding Coda faster due to a table with formulas

Filter your table per week showing dates and weekday names

A Coda puzzle with a subtle complexity

A step by step guide to calculate regular time in your team

Tips to make multiple rules work together

Using a button to retrieve your data smoothly

Using a button to store a list of data in a cell

Taking a list out of a table and manipulate it elsewhere

Work smarter due to a clean approach

Compensating office hours, extra hours, weekends, holidays

Compensating office hours, extra hours, weekends, holidays

Registering paid and unpaid leave

Registering sick leave and counting employers contributions

Registering sick leave and counting employers contributions

Calculating breaks for bus drivers in the public transport

Should you use 2 columns if 1 can do the job?

How to turn the column names into row values

Using the Coda PaperForm Pack from the Coda Guy

You might want to replace it by something smarter

Booking the room and update your ‘stock’

Select the days with rooms that fit your criteria

Distributing values over rows using a button

Show only the rooms that fit your criteria

How much you need monthly to pay the bills over time

Using Coda to get the start and end date of week

Date based filters combined with capacity

Why I use Coda instead of Excel

generate booked and free rooms per day

How to coda with dates ranges

Using Coda.io to create an actionable holiday calendar

Part 01 — Showing stops, travel times and more

How do they relate and how to Coda them?

Pro stuff: getting the next value in line

Fill out dates & turnover in seconds

Using a table and Format() to create dynamic content

Applying a group index to find increased or decreased profits.

Keeping track of your inventory in 4 steps.

Converting amounts into a single currency

Adding information to your table using the full screen

Part I | intervals

Based on a question in the community

Country related VAT complexities

Combining product promotions and reduction on total

How to define your promotion per product

Giving a reduction over the total (VAT incl or excl).

Relate your reduction to the price VAT Incl. or Excl.

Applying reductions

Basic rules to keep your VAT in order

Using a check box to simplify conditions

Based on data living in a table?

Using a button to distribute files over rows

Using FormulaMap() and Sequence() to get the job done

Checking for and adding when necessary

Using the filter option via a formula

Calculating the duration per working day per person

My week starts on Monday

Some tips & tricks while dealing with logical operators

RandomItem & RandomInteger in (Run)Action()

When see ‘if this, then that’ …

and to email a page filled-out with variables

about Concatenate() and Format() and how they differ

Set up calls and send messages directly from a doc

Using the Gmail Pack and smart buttons

Making use of the hidden gem Find()

To manage your internal approval processes

Using tables with buttons you create a planning in seconds

Turn tables into (multiple) forms — use forms outside Coda

In my blog on previousRow I mentioned at the end that for interest calculations we do not need a previousRow logic, instead we apply…