In the last cells of the attached notebook, I can combine the two searches (lyricist and composer) into a combined third search. For example, I choose Anand Bakshi as lyricist and A R Rahman as composer, and their individual outputs show under the lyricist and composer dropdowns, and the combo table shows up as the third table.
But for more readability, it will be great to have chosen a lyricist from dropdown, and then having in the ‘composer’ dropdown only those composers who have worked with the previously chosen lyricist.
For example, I can NOW choose Shailendra as lyricist, and then AR Rahman as composer, and then have the combo table as empty.
I want to choose Shailendra and then have no option in the composer table for A R Rahman (or any other composer who did not compose Shailendra’s lyrics).
Can I do that? I tried to do something with Inputs.bind, but cannot make it work.
Question#2: Is there a way of grabbing part of a string in a column for search? Like, can I choose the rows in a particular column (say, Singers,) where ‘Asha’ or ‘kar’ appear? Can I use Search to target a particular column instead of the whole table?
Also, how do I show the songs sung by Lata using color=unknown?
Thanks a lot in advance,
Here is the link to the notebook: