What is the proposed idea/solution?
FieldArray() - A function to use within the Formula Field that allows for the concatenation of all fields values, with each entry separated by a comma.
ReplaceLast() - A method that replaces the last matched character in a string, so for example, the last comma can be replaced with a more desirable string.
How does is solve the user problems?
It's incredible just how overly complex a formula needs to be to cater for what is simply concatenated field values that need to be separated by a comma.
Take these fields for example;
- "Colour A"
- "Colour B"
- "Colour C"
And the first record has red, green and blue. Using FieldArray(), we could do this within a formula;
FieldArray({Colour A},{Colour B},{Colour C})
Which would return:
"red, green, blue"
Then, for example, we could do this;
ReplaceLast(
FieldArray({Colour A},{Colour B},{Colour C}),
", ",
" and ")
The result being;
"red, green and blue"
Or perhaps;
ReplaceLast(
FieldArray({Colour A},{Colour B},{Colour C}),
", ",
" or ")
"red, green or blue"
Who is the target audience?
Anyone who's tried to concatenate many fields together thinking it would be a two second job, only to find themselves entering some kind of nested formula hell.
