Displays the time and date of the last table update#67

Displays the time and date of the last table update and the name of the person who performed the update at the below or above table on font-end and back-end:

-Updated by John, twenty minutes ago

Would be very useful and important, especially in scenarios with a large number of people updating data frequently. Personally I’d need it to be more specific though, so that the timestamp and “last modified by” would be visible on every master-detail page.

So essentially it’s about having an audit log, the ability to track who made a row modification and when… then also what you asked for could be easily accomplished just by fetching the newest entry from the log, formatted as needed.

If I remember correctly, sadly for now it’s only possible to log the creators of rows, using variables/placeholders.

Hello, thank you for your suggestion!

We are currently working on a feature where you will be able to see four new columns in tables with the following information: created_at, created_by, edited_at, and edited_by.

If you have any more questions or need further assistance, feel free to ask.

Awesome..!
Now a stupid question: When having an SQL-based table, should these four columns then be present also in the SQL table or is this kind of metadata stored somewhere else..? In other words, should one prepare for this when planning a new SQL table project from scratch. Thanks.

It’s a reasonable question, but for now, this option is only for manual tables, and columns will be created automatically, but they will be hidden (you can show them if you want), and you can also delete them if you want.

Can you rename these columns with affecting any dependencies, if there are any?

After realizing recently that I can actually go the manual table route too, since I have no existing SQL table for my project, I now find these new columns perfect for my needs..! Thanks to the wpdt devs for adding these.

(Yes the columns can also be renamed just like the normal columns, only the display name changes and the underlying column name in the database stays the same as it originally was.)

Awesome!