Scenario
User wants to add a Custom Field on the Employee Record that will automatically calculate the Employee's age. This is to avoid inconvenience in manually updating the Employee Record each year.
Solution
- Navigate to Customization > Lists, Records, & Fields > Entity Fields > New
- Label: (e.g. Age)
- Type: Integer Number
- Store Value: Unchecked
- Under Applies To tab > Employee: Checked
- Under Display tab
- Subtab: Human Resources
- Display Type: Inline Text
- Under Validation & Defaulting tab
- Default: (({today}-{birthday}) / 365.25)
- Formula: Checked
- Click Save
Note: Enter the Date of Birth in the Birth Date field located in the Human Resources tab.