Can I use a virtual column (a concatenation of 2 fields previously inputted) as a reference to a different table so that I can populate other data?
Hi @Ivie_Gonzales, Based on my understanding and testing , ,technically yes, you can do that.
i believe it is equivalent of a computed key. I am sure you have already considered that concatenation should create a key that
uniquely identifies the row of source table from where you will pull the data.
Yes, you can choose virtual column as a key column as well.
@Ivie_Gonzales you can, but itโs not necessary. Whatever other information youโre trying to โpull inโ you can achieve with a derefference. help.appsheet.com - Dereferences Dereferences help.appsheet.com
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |