Column values based on another table's multi-select column values


I have a table column with multi-select and input new items on. I am trying to extract the different cell values of that column into another table in individual rows. For eg in Table 1 multi select column I have options A and B selected. In Table 2, I would like to have Option A in one row and Option B in the next row. Thanks.

Hi @Admin_istrator,

please have a look at this basic sample and tell me if it works for you:

Maybe this is not the case, but as usual, with data re-structuring, it would be useful to understand the bigger picture as maybe this solution could be better addressed with a proper data model.

I hope this helps

Dear @Federico_Stefanato,

Thanks for the nice solution.
Will it be possible to add also a second column with the same button, either from the same table or another table?

Hi @J_Pi,
welcome to you too! :handshake:

Sure, but it would be nice to have an idea: could you share or outline an example?

Thank you!

Hi @Federico_Stefanato,

Thanks for the solution! Is it possible to have the values work more like a lookup instead of an action? Using actions requires the automation to delete all rows in the table and then run the formula to prevent duplicates.

Dear @Federico_Stefanato,

I had some sharing issues that the Coda team managed to solve for me :slightly_smiling_face:

It would be nice if you could guide me on this scenario:

Thanks for your time and patience :construction_worker_woman::building_construction:

There is not currently a way to do this without better access to Outer Current value. The only solution to this problem is Iterator Tables:

I have built that for you in your doc. You can see it under the Connor Solution page:

This is an issue that coda is aware of, see this post from shishir: Outer CurrentValue access

That said, in this case I don’t think you should need this functionality if your doc is representative of your actual use case. You’ll be better off making a table called, “Orders” where you order one product at a time, and then you can batch those by clicking the “order” button which will assign all of them the same order id.

1 Like

Dear @Connor_McCormick,

Thanks for the guidelines and @Paul_Danyliuk, thanks setting up the explanation.

Good to understand that Coda is working on it :weight_lifting_man::weight_lifting_man::weight_lifting_man:

1 Like