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

[Connor_McCormick]

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:

Tutorial: Iterator tables (CurrentValue workaround)

After answering the CurrentValue issue questions so. many. times, I finally recorded the tutorial on a Coda data processing pattern I use as a workaround for this very problem. It involves creating single-row helper tables that store outer CurrentValue values into cells, so that they’re accessible in nested Filters and FormulaMap loops. I call this pattern Iterator tables, and beside being a workaround for CurrentValue, these are very powerful for doing more complicated calculations The video i…

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 - #48 by shishir

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.