Conditional formatting twice conditions

[aminsaleh]

Hello community, I am new to AppSheet but I have a rigid computer background. I've built a small app to manage sales and I'm here to post a question regarding the conditional formatting rule in AppSheet and whether is it possible to write two conditions from two different tables.

Here is a pseudocode to get an idea:

*****

If (Seller picks a product X In salesman table)

&&

If ( Product X quantity is less than 10 in stocks table)

Then: The product X text becomes red.

*****

Below is the attached screenshot of my app:

What I need to accomplish is simply the followings:

1- On the top side, A seller named Hassan goes to his tab or table "Hassan" and clicks the plus sign to add a new order.

2- On the new order page there is a list called "order1" and he has to select one product.


Now here is the multiple conditional formatting I am questioning about:

((

If "order1" in "Hassan" table = Basic chair && If "item Qty" in "Stocks table" <10

Then: The basic chair on Hassan's table should be formatted for example in red font.

Thanks indeed