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:
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.