I have a data type called “Streaming link”, which has fields “Streaming channel” (a data type) and URL (text). A streaming link is also a field on a Song data type.
When creating a “Streaming link” you can choose the “Streaming channel” from a dropdown, and then input the URL.
Streaming channels can be added and removed, so the drop down fields are dynamic (the result of a search for streaming channels.)
This works fine, but what I want to do now, is not allow the user to select Streaming channels that they have already input for a specific song.
So for example:
Song “yay”, has a “youtube” streaming link, but not a “soundcloud” streaming link
When creating a new streaming link for song “yay”, only “soundcloud” appears in the dropdown.
What’s the best way to achieve this? Here is a picture of the search I am using for the dropdown.