custom field with function as expression

philmills · Post by **philmills** » Thu Aug 18, 2022 3:14 pm

I created a function getAge in global events which calculates a persons age from their id
the id is stored in the users table in the field 'personalcode'
I want to create a custom field that will display the user's age

I can do this in row_rendered like this
getAge($this->personalcode->CurrentValue)
but for tidiness i would rather have it directly in the custom field

What would the correct expression be for that, assuming its possible?

arbei · Post by **arbei** » Thu Aug 18, 2022 3:24 pm

Read Custom Fields:
The SQL expression must be a valid SQL expression for the database based on the fields of the table/view. Otherwise, the Custom Field cannot be created.

It is not PHP expression.

philmills · Post by **philmills** » Thu Aug 18, 2022 7:53 pm

OK, in that case I have to stick with Row_Rendered

mobhar · Post by **mobhar** » Thu Aug 18, 2022 10:35 pm

Yes. Using Row_Rendered server event is the closest approach for your case.

adeebss · Post by **adeebss** » Mon Aug 22, 2022 4:52 pm

TIMESTAMPDIFF(YEAR, birthdate, CURDATE())

add custom field then add expression
note: change it (birthdate)