Can I use a virtual column (a concatenation o...

[Ivie_Gonzales]

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?

[Suvrutt_Gurjar]

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.

[Aleksi_Alkio]

Yes, you can choose virtual column as a key column as well.

[Grant_Stead]

@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