Advanced Inventory Management

My scenario is as follows:

I have Table A with two rows whose values are:

  • Banana
  • Orange

It uses a second column to tell me the number of each fruit I need

I have Table B which has two columns

  • Quantity (a number)
  • Fruit (a lookup field listing Table A fruit option)

I wish to add TableB.Quantity to TableA.FruitNumber of the appropriate fruit chosen from the lookup field TableB.Fruit. I would think that a button with the function of Modify Rows>Filter>+TableB.Quantity would work, but it does not. Can anyone share some formula that I can use to tackle this.

Here’s the formula that i’ve tried - it gives me no errors, but will only alert me “No action taken” when I press the button.

ModifyRows(Filter(TableB, thisRow.[Fruit]=[Fruit Type]), TableB,[Number of Fruit], +thisRow.[Quantity])

Is this what you are looking for? I included a column calculated via formula and a column with a button that updates another column with summed quantity. Let me know if you are looking for something else!

1 Like

I think that just about sums it up. My formula was a little more complicated, but I penciled it out from here. Thank you so much!