Trying to filter for dynamic relations

1

So here’s simplified version of my problem:

Here’s my little tracker where i wanna keep track of the entry of my projects into directories. I do have a list with a few hundred directories. Also a Table with my own projects. The entries Table has relationships to projects and directories.

3 Tables:

  • Projects
  • Directories
  • Entries

Now i created a page “Create new entries” where a Dropdown at the top of the page lets me select a project and then is supposed to pull all Directories that don’t have an entry for this project yet. I tried setting up filters in several ways on this embedded directory table but can’t seem to get it to work. The table has an Entry column that shows the related Entry records from the Entry table. I want it to not show up in the list if one or more of those entry records are from the project selected from the dropdown on the top of the page (project-selection).

Any hint on how this is supposed to work?

2

Hi @Helmi ,

Here’s one way to do it. Create a relaction control for the Project and a table view for the Directories.

Filter that view with the following formula
Entries.Filter(Directory=thisRow and Project=[SelectedProject]).IsBlank()

which means, show me all the directories where there are no entries related to the directory and the selected project.

Hope this helps,

Pablo

2 Likes