List() function applies formatting inappropriately

Discussion created by anothersmurf on Jul 13, 2017
Latest reply on Jul 17, 2017 by anothersmurf

Product and version (e.g. FileMaker Pro 14.0.3) Filemaker Pro Advanced 16.0.2

OS and version Mac 10.11.6

Browser and version (for WebDirect only)

Hardware Mac Pro

Description When calculating list(repeatingfield), if the text in a repetition is formatted (eg fontcolor), the paragraph mark following it in the data returned by list() is formatted like the repetition's data.

How to replicate

1. Create a repeating field, type text, with two reps.

2. Put some data into each rep of the field. Apply text colour to the first rep only.

3. Create a calculation field, nonrepeating, using the calc: Substitute(List(repeatingfield); "¶"; "; ") [the goal here is to produce a semicolon delimited list of the values in the repeating field]

4. Observe that the semicolon seperating the two values is coloured like the first value, rather than black (default colour) as expected

Workaround (if any)

Don't use the list function. Instead calculate using: repeatingfield[1] & if(not isempty(repeatingfield[2]), "; " & repeatingfield[2]).

Note that the calc Substitute(List(repeatingfield); "¶"; textformatremove("; ")) is NOT a successful workaround; the textformatremove() is ineffective here.


NB I checked the documentation for List and it says nothing about this, so even if you think this behaviour is OK as is, it ought to be documented.