Sub table that only shows rows with common value from main table?

Hi @Christina_Crowder,

What you are referring to is a Parent Child relationship. The Parent is your current table and the Child will be the new table. The type of relationship will also be one-to-one so that only one row can exist in the child table for each “Tants! Corpus” row in the Parent.

You can check out Coda’s documentation on relations here: https://help.coda.io/en/articles/1385997-connect-tables-with-relation-columns

You will need to know how relations work to set the right columns and their settings before you move onto how to make make the related rows.

Be sure to note the Relation column options section and turn of Allow Multiple.

Once the columns exist there are three ways you can go about creating rows and relationships in them.

First is manually. Once the relation columns are in place you can create a row in the Child table for each “Tants! Corpus” as needed and just set the relation to link to each other.

Second is Automation. Set it to look for edits of the column where you set “Tants! Corpus”. If it meets the criteria you can have a formula check to see if a row exists in the child table and if not then create it. (see the third option for how the formula works). This one is more complex and if you have not used automation or complex formulas before it could be a steep learning curve. Also depending on how many rows you add or edit and the account tier you are on you could quickly reach your automation limit.

Third is on a button press. I helped someone out previously where they wanted to make a new row in another table and create a relation with it. Hopefully this can help point you in the right direction.

https://community.coda.io/t/create-a-row-and-reference-it-at-the-same-button-press/31972

Note that you could technically create the button and use automation to simply push that button for you as and when needed so you can run the action yourself without the delay that Automation brings in but automation will catch it if you forget.

If you would like more specific help creating the button or setting up an automation please create a sample document with a cut down version of your doc (keep table and column names the same for ease of translation to your live system) and share it here. I will be happy to take a look and see what can be done.

All the best

Dale