Formats Rules Conditional

[Sirfyaad]

I want to match both tables together. I want the 'Formats rules Expression' to work if the 'channel' and 'quantity' columns in the 'scan sheet' match with the 'channel' and 'quantity' columns in the 'photos' table. Otherwise, it shouldn't work. Also, I want to ensure that if the 'channel' is not equal to the 'quantity,' the 'Expression' should not work. 

AND(
IN([CHANNEL], SELECT(photos [CHANNEL], TRUE)),
IN([QUANTITY], SELECT(photos [PAIR QTY], TRUE)),
LOOKUP(
[CHANNEL],
"Photos",
"CHANNEL",
"PAIR QTY"
) = ANY(
SELECT(photos [PAIR QTY], [CHANNEL] = [CHANNEL])
)
)

 

[jrullan]

Are the channel and photos tables related? If so, how?

[Sirfyaad]

Hi @jrullan 

Table "photos" Channel, Quantity 

Table "scan sheet" channel, quantity 

I want to match the data of "Photos" table with the help of channel. Equal to [DATE] = Today()

[Sirfyaad]

Everyone please help .