Hello all, Quick question about Display name...

(Miranda Lubarsky) #1

Hello all,

Quick question about Display name field formulas.

I have two columns that I have concatenated to make a [Plant ID] virtual column which is the key.

It is the plant name and the variety name combined.

When this column is shown in the app, the name of the plant runs together with the name of the variety, no space or comma in between which makes it hard to read.

I am trying to use the display name field to make a formula to insert something between them so it’s more easy to read. I tried this but it doesn’t work:

=[Plant], "

", [Variety]

Any thoughts on how I can get that to happen?

I would also like it to appear this way when I reference the column in another table.

Thanks! Miranda

(Grant Stead) #2

Try concatenate([Plant], "

", [Variety])

(Miranda Lubarsky) #3

@Grant_Stead ok I did that which worked for the column header, but the value in the column is still the plant & variety running together and so when I reference it in another table it still doesn’t have the space.

Would I use some other expression in the app formula? I don’t want to mess up what I already have there

(Grant Stead) #4

@Miranda_Lubarsky you mean the data in the virtual column? Use the concatenate?

(Miranda Lubarsky) #5

@Grant_Stead i used the same expression in the app formula which worked so all good, thx!