get trans_type in products table (appsheet sample order capture)

[ea_9000]

Hi All,

for appsheet sample order capture ,is there way to get filter the products table in a slice so that expired products or zero qty products only get shown if the transType = "return" , but if transType = "sell" i get products filtered.

cheers

Emad

[WillowMobileSys]

---

@ea_9000 wrote:

is there way to get filter the products table in a slice so that expired products or zero qty products only get shown if the transType = "return" , but if transType = "sell" i get products filtered.

---

Of course.  I'm not completely sure if you have described what you really want but If I take what you have said literally,  the Slice "Row Filter Condition" would be something like this:

OR(
       [transType] = "Sell"
       AND(
           [transType] = "return",
           OR(
              [Status] = "Expired",
              [Quantity] = 0
           )
        )
)

I am assuming all of these values are within your Products table (names would need to be changed to fit your use case).  If your data model is different than I have assumed, then there will need to be adjustments to how you retrieve the desired atributes.