Virtual Columns

[Thomas_Varghese]

Can we use virtual columns as a data entry field, so that the value is held in the app to concatenate in another field but the VC  does not show physically in the connected spreadsheet..

Thanks

[Swoopy]

Yes we can refer to the VC in expression like

LINKTOFORM("My_Form",
   "My_Real_Column",
   [VC1] & [VC2] & "-999",
)

[TeeSee1]

---

@Thomas_Varghese wrote:

Can we use virtual columns as a data entry field

---

NO.

What is your objective?

If you concatenate the value in the VC to construct a value in a persistent column then the value will be visible in the Spreadsheet as part of the string anyway.