Product and version
FileMaker versions 11 - 15
OS and version
Confirmed in El Capitan 10.11.6
Time incorrectly adds decimal formatting when in same merge block as number formatted as decimal.
How to replicate
1. Define a Number field and Time field, and populate them with some values, say 123.4 for the Number and 8:15:45 for the Time.
2. Merge the two fields in the same text block (for example: "An amount of <<Numberfield>> is due at <<Timefield>> today.").
3. Format the text block to display numbers as Currency or Decimal, Fixed number of decimals: , and to display times as [hhmmss].
The result looks like this: "An amount of $123.40 is due at 8:15:45.00 today." with two decimal zeros appended to the merged time. Then change the decimal number to 5 decimals. The time changes to 8:15:45.00000.
Workaround (if any)