Duplicate virtual column value based on matching row values in different tables

[Doors]

Hi All,

I have 25 tables where School classes can choose from multiple lunch items from an enum list.

This example table is called “Angelfish” and the class column is pre-populated from a google sheet to reflect the same value.

I have three virtual columns for each dinner selection that counts the number of orders for meat, veg or special.

I’d like to reflect these three separate counts on a different data table called “Summary”:

So the expression needs to reflect the following

Meat Column Expression:

For the current row in the table “Summary” where the class column value matches the value of the class column in the table “Angelfish” show the value of the virtual column “Meat Count” from the Angelfish table.

I hope that makes sense? Thanks in advance.

J.