Functions Reference

FILEMAKER FUNCTIONS REFERENCE 169
The Rate Lookup calculation field will return 25, 25, 100, and 150 for records 1 to 4. Rate
Lookup
can then be used to get the correct rate code (A, A, C, and D respectively).
Related topics
Contents
Functions reference (alphabetical list)
Self
Purpose
Returns the content of the object in which the calculation is defined.
Format
Self
Parameters
None
Data type returned
text, number, date, time, timestamp
Originated in
FileMaker Pro 9.0
Description
The Self function provides a way for a calculation to reference the object with which it is associated
without having to explicitly reference the object.
Use Self to create a single calculation formula that can be applied to different objects. The Self
function is helpful for conditional formatting calculations and tooltip calculations because it returns
the content of the layout object when that object has a value. You can also use the
Self function in
field definition calculations (including auto-enter and validation calculations) to return the value of
the corresponding field.
Examples
self > 10 returns 1 (True) when applied to a layout field object whose value is greater than 10.
Item Weight Rate Lookup
Lamp 8 25
Chair 22 25
Desk 60 100
Bed 120 150