Gallery
Demos
Share
Explore
Community Answers

Relation filter

In response to Helmim in https://community.coda.io/t/dependent-selection-options-from-relation-based-on-other-relation-select/52005

Projects_1
1
2
3
Name
Entries
Tags
Project 1
Entry 1
Entry 2
Entry 3
Entry 4
Tag 1
Tag 3
Tag 7
Project 2
Entry 5
Entry 6
Tag 2
Tag 5
Tag 9
Project 3
[  ]
There are no rows in this table
Entries formula:
Entries_1.Filter(Project=thisRow)
Tags formula:
ListCombine(thisRow.Entries.Tags).Unique()


Entries_1
1
2
3
4
5
6
Name
Project
Tags
Entry 1
Project 1
Tag 1
Tag 3
Entry 2
Project 1
Tag 7
Tag 3
Entry 3
Project 1
Tag 1
Entry 4
Project 1
Tag 1
Entry 5
Project 2
Tag 2
Tag 5
Entry 6
Project 2
Tag 9
There are no rows in this table
Tags column options:

image.png


Tags_1
Name
Project
1
Tag 1
Project 1
2
Tag 2
Project 2
3
Tag 3
Project 1
4
Tag 4
Project 3
5
Tag 5
Project 2
6
Tag 6
Project 3
7
Tag 7
Project 1
8
Tag 8
Project 3
9
Tag 9
Project 2
There are no rows in this table

Share
 
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.