I understand that when select two (2) columns -or more- as key in a table app sheet creates a virtual column that combines the columns selected as keys.
However, what I need help understanding is how AppSheet treats/handles this new "combined" key when I REF this table from another table (that only have one of the key columns in it)?
1) Do I need to have a matching "combined" key?
2) Do I only need to have one of the values in the combined key to match?
User | Count |
---|---|
14 | |
11 | |
9 | |
7 | |
4 |