Please note javascript is required for full website functionality.

Blog

A to Z of Excel Functions: The FIELDFUNCTION function

4 August 2025

The FIELDFUNCTION function

Ah, the mysterious FIELDFUNCTION…  

In 2021, Microsoft introduced the first set of Application Programming Interfaces (APIs) that allowed developers to use data type structures within their add-ins.  But Microsoft didn’t stop there. 

Excel has since allowed you to leverage the same capabilities found in Stocks and Geography data types by creating your own properties (entities) and associated “dot functions”.  This allows you to add custom functions to values with such properties (such as entities). 

As an example of a built-in dot function, consider the dot function “Population” for the Geography data type, viz.

When creating your own functions, you are often allowed to construct multiple functions with the same name (!), but with different parameter types – INDEX and LOOKUP are two such native function examples in Excel, for example.  When you allow multiple functions to have the same name but different parameter types or numbers of parameters this is called function overloading.

When a function is called, the compiler or interpreter needs to determine which overloaded version to execute.  This is done by resolving the function call to the most appropriate definition based upon the arguments provided in the call.

Dynamic resolution occurs when it involves determining the function to call at runtime, often based upon the type of object being used or the address of the function in memory.  It can prove tricky.  Therefore, in programming, resolving a function means determining which specific function definition to use when a function call is made, especially when there are multiple possible definitions (function overloading) or when the function's location isn't immediately clear. 

FIELDFUNCTION is a function that is specifically employed for resolving dot functions with a function.  It employs the following syntax to operate:

FIELDFUNCTION(value, field_name[, function_argument_1, …])

The FIELDFUNCTION function has the following arguments:

  • value: this is the value required
  • fieldname: this is required and is a text string that represents the fieldname of the dot function to be resolved
  • function_argument: this is optional and there may be no arguments of various data types, one or multiple.  These are used for the function computation.

If it seems a little confusing, it is because presently it is.  This part of Microsoft’s recently announced work (May 2025) on improving Data Type APIs and little documentation exists as at the time of writing.

 

We’ll continue our A to Z of Excel Functions soon.  Keep checking back – there’s a new blog post every other business day.


Newsletter