Help

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

FieldArray() and ReplaceLast() for Formula Field

cancel
Showing results for 
Search instead for 
Did you mean: 
Karlstens
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;

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.