Using Auto Enter Custom Value for Table Columns

Classic Servoy
1

In each table, I have two columns, creator and modifier, which get stamped with the logged in users’ initials. I want to use auto enter for a column to insert this value, which is stored in a global variable. It appears that I can use “custom value” for this purpose, but I need to be able to distiniguish when the row is being inserted versus being updated. So, two questions:

  1. Is it possible to call a method from a column’s auto enter custom value property?
  2. Is it possible during this method to determine whether the row is being inserted or updated?
    TIA
2

Why not use table events instead of auto enters? You can attach a method to any table’s onInsert, onUpdate or onDelete.

3

patrick:
Why not use table events instead of auto enters? You can attach a method to any table’s onInsert, onUpdate or onDelete.

This is certainly a possibility. But, I really like the auto enter “system” values for creation and modification datetime. It seems that auto enter may be the best (easiest?) way to handle this for the corresponding create and modify date fields in each table. Is either methodology more efficient? Basically, during an insert, I have three columns that get set (creator, create date and an SaaS identifier), During an update, I have two addition columns that get set (modifier and modify date). Thoughts?