Confluence/ "Database" template - "Details" field type
How do I add a field that will display the date a new row was added to a table and the date the data in the row was modified?
Each cell of these dates displays only changes/additions in its row.
I need to enter something in the "link field" field, but everything I enter is rejected.
Please help.
Tomislav is correct that the native "Database" template doesn't have an automatic "Created at" or "Updated at" field type for rows (as you've discovered!). That feature request is definitely the right one to vote for.
In the meantime, the classic and most common way to achieve this in Confluence is by using the Page Properties macro combination instead of the new "Database" template.
This method is slightly different: instead of one page with many rows, you create one page for each database entry. This actually works much better for tracking metadata.
Create a Template: Create a new Confluence template (e.g., "New Project Entry").
Add a Page Properties Macro: Inside that template, add the /Page Properties macro.
Add Your Fields: Inside the macro, create a two-column table. In the left column, list your field names (e.g., "Owner," "Status," "Due Date"). In the right column, users will fill in the details.
Create a "Database" Parent Page: Create a new, blank page (e.g., "Project Database").
Add a Page Properties Report Macro: On this parent page, add the /Page Properties Report macro.
Configure the Report:
Set it to pull from all child pages (or all pages with the label from your template).
In the "Columns to Show" option, add the names of the fields from your table (e.g., "Owner," "Status").
Here is the solution: You can also add Confluence's native page data as columns. Add "Created" (for the creation date) and "Last Modified" (for the last update date).
Now, when a user wants to "add a row" to your database, they simply create a new child page under your "Project Database" page using your template. Your "Page Properties Report" macro will automatically pull that page's info into the table and—most importantly—will display its creation date and last modified date as columns, which is, I think, what you're looking for.
Hi @Alex L_ __ Payments Project manager ,
From what I've gathered, you're looking for a field that will have a timestamp when that entry is added to the database?
There's a feature request related to this: CONFCLOUD-80494: Provide more granulated control for Confluence Databases, so I'd suggest leaving a vote.
Cheers,
Tobi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
 
 
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.