I have a follow up question.
As a workaround to this, I decided to create an additional column that contains a concatenation of the three surnames, and then display this as the card title, like so:
These values are user-editable, so if a user changes one of the names, I need to have this column recalculated to reflect the change. To achieve this, I wrote a trigger function that would fire when the backend sheet was edited. This works, however the sync delay causes confusion because the change is not immediately reflected. So I really need to have this column calculated within Glide.
So, my follow up question:
Imagine I have an array column with 3 names, ie.
['Joe Smith', 'Fred Bloggs', 'Sam Spade']
Is there a way within Glide to define a computed column that would appear as
'Smith, Bloggs, Spade'?