Dynamic column display names

AppSheet AppSheet Q&A
1

Hi all,

I tried to make a dynamic column name. To make it more clear what information is needed. I have en contact name and i want the phone number. when this is filled in there is an option to fill a second contact ( with the use of show_if). What is want:

[Second contact] value is: “Remco Edelenbos”
[Phonenumber2] Display name: Number of Remco Edelenbos

I can get the “Remco Edelenbos” in the display name but not with the text “Number of” before it. I tried:

  1. AND, this doesnt work because the value needs to be logic… like yes or no.
  2. “Number of” , [Second contact] → Result is: just the text “number of”

Is this posible?

2

I think you want a concatentation?

Try CONCATENATE("Number of ", [Second contact])

The shorter version of that is

"Number of " & [Second contact]

1 Like