Ever wondered if there was a magical field to manipulate and operate on data from a table the way we want it to? It's finally here.
Function fields allow admins/privileged users to store data on them based on operations performed using other fields in the table.
This option seems to be present only in the report UI:
The logic for configuring the function field is simple - You give the function field a name, set its return type (it's fair to call it "field type"), select what function operation you want to perform, and finally select the fields which will act as the parameters for the function:
For instance, function fields 'Custom Short Description' & 'Time to Resolution' were created to store values that are not available in the incident table, but using data from the table.
The magic of function fields don't stop here, you can later access these fields if you have access to data on the table - from lists, forms, and even write ACLs on them!
These fields are created with the prefix 'u_rpt_' on the database.
Also, these fields can be de-activated from the report config and later activated again (basically works on the active check).
A limit of up to 20 function fields per table is allocated by ServiceNow.
Comments