I just started trying to learn Coda in earnest and have watched many tutorial videos and part of Paul’s getting started videos. But I need a project to make it click and am having trouble with things that seem basic.
The Project
I’ve started making a music journal of sorts. The purpose is for me to keep track of songs I hear and want to learn to play on various instruments. I also want a quick lookup feature so I can quickly search by various attributes. Here is the structure I want:
Songs table
- Title (Text)
- Band (Table lookup)
- Lyrics (Canvas)
- Instrument (Table lookup)
- Spotify - track (Pack)
Bands table
- Name (Text)
- Artist (Table lookup)
- Songs (Table lookup)
I need at least the basic version below, but would love help to take it to the next level or two.
BASIC
Why does my Bands table not filter but show all songs in the songs table when I use the following column formula? And why is there an @ symbol at the beginning?
Songs.Filter(thisRow).BulletedList()
I also tried:
Songs.Filter(Band.Contains(thisRow))
Also, I’m not sure if I should keep the Songs table on its own page and create another simpler lookup page with all the filters, but it appears I would have to duplicate the table there anyway? Any advice on how to structure the doc?
LEVEL 1
Is it possible to pass my song title and Band name through the Spotify pack and create a link to play the song? I tried adding Spotify - Track, but don’t see documentation about what to do beyond that except high level stuff.
LEVEL 2
The tough part is between Bands and Artists. Sometimes a single person is the author of the song, and sometimes a Band is the easiest way to see it. I play regular songs, but also play old time music. In that community, you really reference by “tune” rather than “song” but more importantly you reference the author of the tune instead of the band. So someone might say “I play the Clarence Ashley version of Coo-coo.”
I’m not sure how to best organize this. But I started by separating out Artist from Band and nesting Artist inside the Band table. But then I don’t know what to do in Songs except include both. But then I have blanks in data.
I’ve shared the doc and I believe you can edit the formulas. (Or does edit only allow you to add records in tables?)
Any help is appreciated!