AnsweredAssumed Answered

"List of" summary field strips out text formatting

Question asked by philmodjunk on Aug 26, 2014
Latest reply on Aug 28, 2014 by TSGal

Summary

"List of" summary field strips out text formatting

Product

FileMaker Pro

Version

13.0.4

Operating system version

Windows 7

Description of the issue

IF you have a calculation field with a text result type that formats some of the text in a field, FileMaker 13's new "list of" summary field produces a return delimited list of the text in this field, but all text formatting will be removed.

Steps to reproduce the problem

Set up this calculation field expression:

"Plain Text " & TextStyleAdd ( "Bold Text" ; Bold )

Define sListField as a Summary field that produces the "list of" this summary field.

Create several records in your found set and note the value in sListField.

Expected result

"Plain Text" as plain text and "Bold Text" as bold text in each row of text in this field.

Actual result

All the text is plain text, no text is Bold.

Configuration information

Just checking to see if this is a bug or "by design".

Workaround

It is possible to set up a self join where the "list of" field is used to produce a list of Primary keys and an unstored calculation field copies the value of this summary field. Use this unstored calc field as a match field to the primary key of a second occurrence if the same table and now you can use the List function to get this list of text, but with the formatting intact.

Outcomes