Dependent Selection options from Relation based on other Relation select

1

Hey community,

That tile might sound a bit complicated but I think it’s quite simple.

Here are my tables

  • Projects
  • Entries
  • Tags

There are several Entries on each projects. Each entry can select multiple Tags to be used for the entry but the Tags are different for each project.

So Each Tag has a project selected when it is created, then when creating an entry we select the project it is connected to. Now when we select the tags, the question is how would we filter that select list to only show those Tags that are attached to the project instead of showing them all as in a standard relation?

I hope this is worded clearly enough - let me know if it is not.

2

Hello @Helmi

I believe I understand your request.
As you mentioned, you have three tables. The Tags table should have a relationship column connected to the Projects table. The Entries table should have one column related to Projects and another related to Tags. This “tag” column includes a filter to ensure that the project in the Tags table matches the project in the Entries table. This will accomplish the filtering you need.

Here’s an example (feel free to copy the doc). I also added two columns in the Projects table to retrieve all entries and tags based on the other tables. Since multiple entries can have the same tag, I used the unique() formula to display only the unique tags.

Playable doc: Relation filter · Demos

Let me know if this achieves what you’re looking for.

Best regards
Arnhold

1 Like
3

took me a while to get the grip but that’s working perfectly, thanks!

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.