Skip to content
Coda-public
Start her
Examples & tests
Share
Explore

icon picker
Recursive lookup example

An example using lookup to make an recursive parent/ child tree. See explanation below the table:

DB_Projects
Project Name Indented
Project Name
Parent Folder
Project Name DB
Level
Project Name Full
Project Text
RowID
Finance
Finance
/ Finance
1
/ Finance

1
HR
HR
/ HR
1
/ HR

4
Change structure
Change structure
⁠
@ / HR
⁠
/ Change structure
2
/ HR / Change structure

5
Hire new CFO
Hire new CFO
⁠
@ / HR
⁠
/ Hire new CFO
2
/ HR / Hire new CFO

6
Office
Office
/ Office
1
/ Office

7
Rebuild room B
Rebuild room B
⁠
@ / Office
⁠
/ Rebuild room B
2
/ Office / Rebuild room B

10
New desks
New desks
⁠
@ / Office / Rebuild room B
⁠
/ New desks
3
/ Office / Rebuild room B / New desks
d
11
Reorganize cable
Reorganize cable
⁠
@ / Office / Rebuild room B
⁠
/ Reorganize cable
3
/ Office / Rebuild room B / Reorganize cable
test text
12
Repair tables
Repair tables
⁠
@ / Office
⁠
/ Repair tables
2
/ Office / Repair tables

8
Security
Security
⁠
@ / Office
⁠
/ Security
2
/ Office / Security

13
Replace locks
Replace locks
⁠
@ / Office / Security
⁠
/ Replace locks
3
/ Office / Security / Replace locks

14
Production
Production
/ Production
1
/ Production

3
There are no rows in this table
⁠
How it shows up in a selector:
⁠
⁠

You only fill in the green Columns “Project Name” and “Parent Folder”, and you only need the Project Name DB (Yellow),to use the logic.
The rest columns is just to make it easier to work with and visualise the data.
The recursive part happens as “Parent Folder” lookup “Project Name DB”, which again aggregates it’s full value from it’s parent “Parent Folder”
It’s just one lookup and simple formulas. It’s very fast and easy to set up. “Project Name Indented” is just an example, and for this type of processing, “Level” and “RowID” might come in handy.

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.