Forum Discussion
eacy
9 years agoHelper II
Using a text string from one column as a column reference in a calculated column
Hi, I have one table with a column named TBLSYSTEMCODE[TCODE] containing a text string "DCREATED" and an column named TBLSYSTEMCODE[ID] containing the id "1" Then I have a second table named ...
eacy
9 years agoHelper II
Hi Michael,
Thanks for your feedback.
If you think about it, it is quite complicated to document and I belive you got it right.
The main problem I face is to pick up a string from a field and reuse it as a column reference like:
I have:
TABLE[reference string] = "Column A"
I want to use it like:
IF(TABLE[Column A] = TRUE;bla bla bla)
I would like avoid to add any infomation to the TBLPO table as you suggest because in the future I would like to easily exchange that tabel with a table from another backend system.
v-micsh-msft
9 years agoMicrosoft Employee
Hi eacy,
I did a deeper research on this topic, still can't find any further helpful infromation on this topic.
Please take consider to submit an idea on this.
Regards