You’re offline. This is a read only version of the page.
674
Say in table department I have a lookup field employee referencing table employees.
I also make a function string field in department with syntax (employee.name).
If in table employee the name is changed will it reflect in the function field of department or only if some change is made to the record in department that reference the emloyee?
Formula columns don’t persist in the database so the value is calculated on retrieval of the data. Say you are loading or refreshing the grid, the calculation to retrieve the lookup value is done at that time.
I see my exmaple is not very logical.
It should be a formula field department in the employee table and what I need is department.name
On a slightly differen note.. If I use department.name in my code, does this imply a lookup (time consuming wise) is being done. Or not and is the accuracy of the result also dependent on refreshing the record?
Since in the case of the formula field an update is only done when some change to the employee record is made (say that the department name has changed but still the lookup in employee still refers to the same department), what is the most logical way (code) to refresh the record? I don't expect refreshing the table to accomplish this since it would take to long with large tables.
Yes I incorrectly recalled a formula field a being called function field.
@HansHeintz did you use Formula or Calculated field and you called it Function field?
Hi @HansHeintz if you use employee.name, value of the function field will be calculated once when the record is created or updated, and it won’t automatically update if the referenced employee’s name changes later.
#1
stampcoin
17
#2
mmbr1606
15
Super User 2025 Season 1
#3
ankit_singhal
11
Super User 2025 Season 1
Share
Report
All responses (
Answers (
