Good morning,
I have a question. I have a column A in which values can be entered. If this happens, the change date should be entered in column B (defined as date) using an automation rule. This works! The user name should then appear in column C (text) above {user.name}. However, the username is not displayed but the text {user.name}. Can someone help me with that?
Hi @TimH, and welcome to the SeaTable forum!
Have you seen that there is a “Last modifier” column types? It seems that it could eventually fulfill your needs… However, this column will take the value “Automation Rule” once the rule updates the date… I can think of two workarounds:
Using the ‘Last modified time’ column type which could save you the need for automation
Creating another “Collaborator” type column, and adding in your automation that this column should take the value of your “Last modifier” column. Doing so, as far as I tested, the “Last modifier” column indicates “Automation Rule”, whereas the “Collaborator” column still indicates the actual user who generates the row update.
For me, {user.name} can only be used if you have a column named user, which is a link column to a table containing a name column…