4 Replies Latest reply on Aug 28, 2014 11:57 AM by TSGal

    "List of" summary field strips out text formatting

    philmodjunk

      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.