Fred(CH)

GetFieldName on related field does not allow storage calc

Discussion created by Fred(CH) on Jan 11, 2017
Latest reply on Jan 12, 2017 by Fred(CH)

Product and version

FileMaker Pro 15.0.2

OS and version

OS X 10.11.6

Hardware

iMac Retina 5K 27''

Description

Unexpectedly, the GetFieldName function, invoked by a calculation field, does not allow to store the calculation result, if based on a related field.

How to replicate

Create a calc field on "Table1" with this formula : GetFieldName ( Table2::DATA )

Using storage option button, try to uncheck "Do not store calculation results -- relaculate when needed"

Workaround

You generally can convert this field on a auto entered field with the same formula.

Remark

Since GetFieldName allow you to refer an unrelated field (because it does not return data but structure information), this restriction is unexpected.

Outcomes