Hi
Im trying to create a simple app. I have 3 tables: Customers RAN, Customers BAM and Products
In the form of Customers RAN i can select via dropdown a product. and with a dropwdown i can select if i have given away a product or not.
| ID | Name Customer | Product | Product given away? |
| 1 | Cust 1 | Product A | Yes |
| 2 | Cust 2 | Product B | No |
| 3 | Cust 3 | Product A | Yes |
| 4 | Cust 4 | Procuct C | Yes |
In the form of Customers BAM i can select via dropdown a product. and with a dropwdown i can select if i have given away a product or not.
| ID | Name Customer | Product | Product given away? |
| 1 | Cust 1 | Product C | Yes |
| 2 | Cust 2 | Product B | No |
| 3 | Cust 3 | Product A | Yes |
| 4 | Cust 4 | Procuct C | Yes |
In my other table called products i want to show data based, on the table Customers RAN and Customers BAM, how many products i have given away (so count value "Yes" of the product and If value no is selected than it will not to anything and will be 0):
| ID | Product | Total product given away |
| 1 | Product A | 3 |
| 2 | Product B | 0 |
| 3 | Product C | 3 |
What formula can i use in appsheet to show the result in the field Total product given away based on the Product field ?
Best regards,
Zuha
LinkedIn
Twitter
