What is function field in a field dictionary.

[Rupal Mehta]

Recently I am seeing a Function field option while creating a field. Just wanted to ask what does it exactly do.

[Shubham Tipnis · Accepted solution]

Basically function fields are to perform common database transformations and calculations. Regular fields store a value in the database. Instead of storing data, a function field displays the results of a database query. Function fields do not have an associated database column. Instead, function fields generate a value based on simple computations of other fields and constants.

I recently had the same question. After some checks I found out below doc which has all the details about function field. Please check it out.

Function field

Please mark correct/helpful if applicable.

Regards,

Shubham

[SR2]

Hello Shubham Tipnis,
Thanks for your valuable information. I have a small requirement regarding function field.

There are some operations like concat(), add(), dayofweek().

In the same way can we get a year from a date/time field and store in function field.

ex: the date is 2022-02-23, the value in the function field should be 2022.

Thanks.