Hello everyone,
I’m facing a challenge and need your assistance. I want to ensure that whenever a user modifies a value in a column, the columns “Updated Field” and “User Updater” are automatically populated with the name of the column and the name of the user who made the change.
I have tried using a trigger formula, but it doesn’t seem to work correctly (I believe it fails to capture the modified field’s value). Here is the formula I used:
for column_name in list(table.table.all_columns):
# Check if there is a match between the value and the value on the record
if getattr(rec, column_name) == value:
# Return the name of the column
return column_name
# If value is not found
return "Value not found"
