So I needed to create a large text field that collated a large text field from all of its child objects.
Now I have managed this by using a flow that loops through all of the child objects every time one is edited and basically collates the field in a text collection variable. This then populates in a text template using the collection variable.
Now my issue is that the variable automatically adds a comma between items and a '[' at either end. Is there a way for these to be removed?
Thanks!
Shay
3 个回答
The alternative to remove the commos from the text template.
- Create a formula field type as text.
- User formula
- SUBSTITUTE(<text template>, ',' , '')
Or if you have any specific pattern that you wanted to remove can use the Old text and New text.
SUBSTITUTE(<text template>, Old_value , New Value)
Thank you