Okay - I suspect this was asked before and I’m duplicating it, but I wasn’t able to parse the answers on the topics that were marked “similar”.
So I have a table, (this is a list of sims expansions and packs). I have a toggle field on that table where folks can select which items they have. All my other tables have a “required” pack row listing which packs you need to select/do that item.
Ideally I’d like to automatically filter those other tables so that if someone doesn’t select a pack that is required for an option, it doesn’t show up. Kind of a negative selection? For example if you don’t select that you have Eco Lifestyle then you shouldn’t see the bonus challenge “clean and simple” since it requires Eco Lifesyle.
I built a similar form/tracker in google sheets but it was pretty much base on “if the value in this field is “no” strikethrough this item” using conditional formatting. I’d love to level this up to Coda.
I haven’t fully built it all out, just started working on it today, so I don’t have a lot of examples yet. But basically something like “if itemname in the [requires field ] is not in the [table selected items] do not show this row.
I’ve forgotten how to share table examples here - so if you think it would be useful I can share if reminded how. Otherwise basically: Table one has “Eco Lifestyle, Get to Work, City Living” - You’ve toggled on Get to Work, but not Eco Life style. Table Two has “ Clean and Simple and Filthy Mess” so only Filthy Mess should show as it requires Get to Work which you have.
(Only even more complicated as many of them required two or more pack so ideally you’d have all the packs on the required list for some tables and at least one of the packs on another table all, but I figured I’d start simple!)