1:N view

[Michal-Mikolas]

Hello,
let's say I have a simple database with Interprets and their Songs. One Interpret can have multiple Songs obviously.

Now I want into my "Interprets view" add to every row this button: [Show this interpret's Songs]. After clicking the button I will see rows from Songs table, which belong to the selected Interpret.

How can I do that? It's just simple 1:N relation.

Thank you.

[harinij]

@Michal-Mikolas Hi 👋 To make sure I understand the question, when you click an "action" column button in the "Interprets" table view, you want to fetch all the rows from the Songs collection for that Intepret and add them to a subcollection of that Interpret row?

[Michal-Mikolas]

I just want to:

1. Find interpret which I'm interested in (with filtering interprets by some criteria: genre, year of birth etc.).
2. Via one-button click see all the songs of the chosen interpret.

[Michal-Mikolas]

So is it possible?

[harinij]

@Michal-Mikolas this is possible in multiple ways depending on how you want to use it after the songs are fetched.

Action column: You can have an action button that does this, whenever a row's action button is click it fetches all the songs of that row's interpret and stored in an another json field.

Connector column: If you are looking for the list of songs to be shown as a drop-down menu option that the user can pick from, then it connector field would be useful