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.
... View more