My scenario is as follows:
I have Table A with two rows whose values are:
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])