Creating Lookups from imported spreadsheet data

I’m a new Coda user migrating from Notion, and I’ve got a question. I’m creating a donor database for a nonprofit. I’ve got two basic tables that I plan to use to create reports of various types: an “offerings” table that will be data from an Excel spreadsheet and list all monetary donations, and a “contributors” table which will have basic info about those making the donations.

The tables (which come from another, more ornery database), are linked by ID numbers for each contributor, and so my question is: how do I create a lookup (or lookups) that connect these tables? Please let me know if this doesn’t make sense and I’d be glad to provide more context.

HI Michael,

Welcome to Coda.

Coda support provided me with an example, which I have recorded in this document.

It is on the page “One to zero or one join”

I hope that this is what you are looking for. If not,there are a couple of other examples too.

2 Likes

This is amazingly helpful. Thanks so much!

1 Like