Welcome to Coda! Think you will love it over airtable. I watched your video and think I understand what you are trying to do.
If so - there are multiple ways you can accomplish it.
- You can simply go into your lookup column and find the “insert related column” option to insert any related column from the lookup table
- Write the formula yourself - its always just a
lookupcolumn.targetcolumn - use your dot operator to pull any column from the source table into your lookup column
If there are multiple selections you just need to add a .sum() to the end of your formula. See here:
Heres an example doc if it helps! If you were looking for a different problem solved please let me know! I was not able to watch the whole video.
DOC LINK: [Example Lookups)