Skip to main content

Hi

 

We are trying to build a small inventory project I need to exclude the product, and along with it need to exclude the ingredients that are being used to make that product.  In the attached workbook, if I exclude the product Bowl, need to remove all its ingredients from the other products. e.g. chicken should disappear from Burrito and Bell Pepper should be excluded from Sandwich aggregation.

7 answers
  1. Jun 7, 2019, 3:36 PM

    So it should still work, it's just you don't have the nice feature of being able to add things to the set via an action.

     

    Below I've done a GIF....

     

    Notice that I have 2 sets. The one I'm amending (on product), and the other on Ingredient (with the condition). I've left the In/Out of both sets on the view, and when I select Bowl, Bowl is IN the Product Set (and everything else out), and then all the ingredients in Bowl are then IN the ingredients set

    So it should still work, it's just you don't have the nice feature of being able to add things to the set via an action. Below I've done a GIF.... Notice that I have 2 sets.

0/9000