Automatically insert creation date of a row

Hello Baserow community,

I’m trying to automatically insert the creation date for new rows that are added to my table via the API. I want each row to have its own unique creation date, reflecting when it was actually added.

Here’s what I’ve tried so far:

  1. I created a formula column with “date” as the name.
  2. I set the formula to “now()” thinking it would capture the creation date.

However, this approach isn’t working as expected. Instead of showing the unique creation date for each row, it’s displaying today’s date for all rows.

What I need is a way to automatically insert the actual date when a new row is created through the API, so that each row has its own distinct creation timestamp.

Is there a built-in feature or a different approach I should be using to achieve this? Any help or guidance would be greatly appreciated!

Thank you in advance for your assistance.

Hi @pdhym,

If you add a new field to your table with the field type set as “Created on”, this will trigger the exact date/time that a record (row) was created. This also will work for existing records that were previously created before this field type was added, as this data is held inside the metadata of each record.

1 Like

Thanks very much. The suggested solution helped achieve what I was trying to do.