Skip to content
Gallery
Coda template distribute nested values
Template Distribute Nested Values
Nested loops
Prefill a table
Share
Explore

icon picker
Nested loops

Add rows with unique categories and ids + remove orphaned items

⁠
info

The green button:

Adds rows with categories to the target table
Removes rows in the target table when the categorie no longer lives in the source table
this can happen when due to an automation an order gets adapted (out of stock for example)
Removes rows in the source table when there are no categories

⁠
⁠
Complete Target Table
⁠
⁠
DB Source
Name
ID
categories
1
2
3
4
6
There are no rows in this table
⁠

⁠
Clear Target Table
⁠
⁠
DB Target
Name
ID
Category
18
19
20
21
22
25
26
27
There are no rows in this table
⁠

Categories
Name
Duck
Chicken
Horse
Cow
Sheep
There are no rows in this table
⁠
DB IDs
Name
1
2
3
4
5
6
There are no rows in this table
⁠

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.