Display name of Columns

[MpHoang]

Hi everyone,

Is it any way to change a Display name of columns by lookup to a table.

For exp, I am Vietnamese and I don't want to use my language for headers.

I have to use a header like ten_nhan_vien instead of Tên nhân viên.

So Tên nhân viên would be the display name for the column ten_nhan_vien.

But with many tables in Database, I have to change displayname manually.

So If i have a table with Header name and their display name, it is any way to lookup to header with fomula?

[jballester]

Hi, 

in the column properties, "Display name", you can customize the name you want to display.

Configure column properties
https://support.google.com/appsheet/answer/10106509

 

[MpHoang]

Hi there, sorry for not clear my ideal. I mean it is we have to do by hand one by one every columns and when we want to change the Display name, we have to return to the columns and change it again.

Is it any formula like that we can get the column name (like context("Appname") and refer it to a table that we have one one column with base columns name and one column with display name.

[jballester]

Yes, as Steve mentioned in a previous post, in the "display name"  you can enter expressions, not just text.

https://support.google.com/appsheet/answer/10106509

[MpHoang]

LOOKUP(columns name,"Data with column name and display name","column name","display name") this is an exp of formula i will use in every columns display name.

But now, I have to change the columns name (the first part of the syntax) to the name of the column.

Is it any formula likes Context("column name") that get the name of the column that I want.

So in every column, I just need to paste the formula in the Display name and don't care about it anymore. If i want to change the display name i will go to the table "Data with column name and display name" and change it.

[AleksiAlkio]

I'm afraid you can't read the column name itself dynamically with an expression. You can read the table name with CONTEXT("Table"), but not the column itself.

[MpHoang]

thanks bro

[AleksiAlkio]

You're welcome!

[Steve]

---

@MpHoang wrote:

Is it any way to change a Display name of columns by lookup to a table.

---

Yes, you can use an expression with Display name to produce the desired name. You can use LOOKUP(), SELECT(), SWITCH(), IF(), and any other functions.

[Steve]

---

@MpHoang wrote:

Is it any formula likes Context("column name") that get the name of the column that I want.

---

There is not, unfortunately.

[MpHoang]

thanks bro. I hope it will be available soon.