This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

FieldArray() and ReplaceLast() for Formula Field

Showing results for 
Search instead for 
Did you mean: 
11 - Venus
11 - Venus
Status: New Ideas
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;

FieldArray({Colour A},{Colour B},{Colour C}),
", ",
" and ")

The result being;

"red, green and blue"

Or perhaps;

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.