Display each item in each row

I am new to coda.io coming from notion , I have three Tables

  1. Products
    ![image|690x230, 75%](upload://fiKx4Dwmmi0umXT1xIkfUofaEOq.png)
  2. Materials
    ![image|690x304, 75%](upload://bJq8no5fVaIu0bgLQisnaMgDpqo.png)
  3. Vendors
    ![image|690x386, 75%](upload://g45Prxef49SddrQcQf7CgGu4VQY.png)

as you can see in Materials table the Product Name showing the results of two product sepreated by comma , where as i wanted to display each row with each product instead of merging them , so that i can make the Material Order Date properly , right now if i assign a date to Product A800 for material Blister it will get assigned to A700,A800 both which i dont want. Is it possible in Coda ?

I want to display something similar to below , can someone help me give any suggestion or guide .

EDITED: I dont know why it does not allow me to post more then one image , any solution for that?

1 Like

Hi @Chain_Reaction, welcome to the community.

I think the forum won’t let you post multiple images simply because you’re new.

If I get your problem right — in Coda you cannot display more rows than there are in a table. By that I mean, if you have 2 Materials, and each Material has 2 Products linked, there’s no way to automatically make a view that will have 4 rows for all material-product pairs.

What I’d suggest in your case is to make a separate “join” table e.g. Products and Materials where one row will link one product to one material, and you’ll have other columns relevant to the product-material pair. You’ll use this instead of linking Materials to Products directly. Then in your Materials and Products table you’ll rewrite your lookup formulas to pull relations from that join table and calculate some aggregated values if required.

That’s the Coda approach overall: bottom up. You design your data tables as granular as you need for your case, then aggregate when going up. I.e., the other way around than you’re asking for.

@Paul_Danyliuk
Thank you very much for taking time to reply to my post. I have try multiple times but i am not able to visualize your above method , is it possible if you can make a example and share with me . ?

Regards

Dear @Chain_Reaction

Please have a look at this basic example:

What’s more, if I understand correctly, as you build these tables, you can see the full context of each row, with subtables in the views of respective rows in each table. ie if I wanted to add to “Wood” things like “type of wood” and “vendor,” I can add see that detail in “table” row in the products table if I customize via the “customize Layout” feature and expand that lookup to display as a table, correct? And I can hide columns so that I only see in this embedded view what I’d like to see.

As I worked in Notion, there was nothing close to this level of detail and customization, which I really needed.

In fact I believe this is related to the problem @Paul_Danyliuk is helping me with over here:

I have not had a chance to try this embedding of subtables if we are talking about related hierarchical items from the same table, but hoping that will work more or less the same as with related items from different tables and lookups.

Its been a while , as i was travelling and not able to work on my coda project . Here i have created the manually Materials table to elaborate more , i am sorry for my english as english is not my native language.


is there any way to achieve the above in coda ?

regards

Dear @Chain_Reaction

Yes this is possible.

One solution could be to add a checkbox column in your table
Mark the ones not of your interest anymore and filter them out.
Strongly recommend to create a view of your main database and to filter only this one for your needs.

For a more professional approach, I recommend to check out this post:

Capture `History` of changes / Create Log of changes to important value of record Credits to: @Krunal_Sheth

:bulb: At the bottom of the post is also a link to a sample document

I think my explanation was not good enough I want to display each material related to that product in each row instead of combined in one row instead as shown above in the first few posts

Dear @Chain_Reaction,

If I understand well you want to group by “Product”?

Please see this reference

No it’s not group , I want each material assign to product display in each row in material table

Dear @Chain_Reaction,

Would you mind to share a dummy copy of your doc?

I have tried before several times by hitting the share button but every time i get this error message as attached.

image.png

1 Like

Dear @Chain_Reaction

I have the same problem. How did you fix it?

Its a bit late in reply , but i still not able to fix it .