# Insert Timestamp **URL:** \ **Category:** Ask the Community\ **Created:** [January 8, 2020, 10:55pm UTC](https://connect.superhuman.com/t/insert-timestamp/13144 "2020-01-08T22:55:46Z")\ **Posts on this page:** 19\ **Page:** 1
**Author:** ![Joe\_Wolin](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/joe_wolin/32/1014_2.png) [@Joe\_Wolin](https://connect.superhuman.com/u/Joe_Wolin)\ **Post date:** [January 8, 2020, 10:55pm UTC](https://connect.superhuman.com/t/insert-timestamp/13144/1 "2020-01-08T22:55:46Z")
Is there a way I can insert a “timestamp” into my document. I’d like to add a journal entry and start it off by adding a timestamp. Right now I am doing this manually, and it would be a lot faster to have this automated. ---
**Author:** ![Mario](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/mario/32/12232_2.png) [@Mario](https://connect.superhuman.com/u/Mario)\ **Post date:** [January 8, 2020, 11:39pm UTC](https://connect.superhuman.com/t/insert-timestamp/13144/2 "2020-01-08T23:39:11Z")
Hi @Joe_Wolin 🙂 You can use the `Now()` formula to get the current time, and use a button to add that in the journal (that can be a table) So in that way you have a table with 3 column timestamp (can be hidden) entry (text or whatever) button (that concatenate the 2 information if wanted or just transpose those in another table) extra: one could also add another column called “stored” that is a checklist, and, when you press the button, the “stored” value change from false to true, and the row is filtered away (so it is in the same table but you do not see it, using the table filter feature like “filter(stored=false)” ) and it can be shown in another view of the table 🙂 extra 2: you can save one column placing the button below the table instead that having it in every row, the same approach could be used also for the timestamp using the formula outside of the table 🙂 Let me know if you want me to prepare an easy example or if you want to try more complicated setup 🙂 ---
**Author:** ![Paul\_Danyliuk](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/paul_danyliuk/32/27228_2.png) [@Paul\_Danyliuk](https://connect.superhuman.com/u/Paul_Danyliuk)\ **Post date:** [January 9, 2020, 2:03pm UTC](https://connect.superhuman.com/t/insert-timestamp/13144/3 "2020-01-09T14:03:46Z")
Hi @Joe_Wolin and welcome to the community. By journal entry, you mean what, a row in the table? A new section? A new document? For a new document, you can insert a canvas formula `thisDocument.Created()` To insert a current timestamp anywhere I just discovered a hack: type a canvas formula `thisRow.Created()` or `thisTable.Created()` — it will create an invisible anonymous table and output its creation timestamp, lol. [![](https://global.discourse-cdn.com/coda1/original/2X/2/2c0bfec4b5cf001394bca2fe18b160d44640cb75.gif) ](https://global.discourse-cdn.com/coda1/original/2X/2/2c0bfec4b5cf001394bca2fe18b160d44640cb75.gif) For new rows in the table — you got it, you can use `thisRow.Created()` formula in a column. Or if you want the timestamp to be editable, you can set up a default value to add to new rows: ![image](https://global.discourse-cdn.com/coda1/original/2X/d/d0af0a7d335637a46309f84c4bf7c4ea1f748e0f.png) ---
**Author:** ![Joe\_Wolin](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/joe_wolin/32/1014_2.png) [@Joe\_Wolin](https://connect.superhuman.com/u/Joe_Wolin)\ **Post date:** [January 10, 2020, 12:22am UTC](https://connect.superhuman.com/t/insert-timestamp/13144/4 "2020-01-10T00:22:12Z")
I’d like to insert it into my document outside of a table. See screenshot. ![Screen Shot 2020-01-09 at 2.20.35 PM](https://global.discourse-cdn.com/coda1/original/2X/e/e2370715d614f19124c320e2963edd66d6f4a1a3.png) ---
**Author:** ![Joe\_Wolin](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/joe_wolin/32/1014_2.png) [@Joe\_Wolin](https://connect.superhuman.com/u/Joe_Wolin)\ **Post date:** [January 10, 2020, 12:43am UTC](https://connect.superhuman.com/t/insert-timestamp/13144/5 "2020-01-10T00:43:19Z")
Hi Paul, That hack is totally what I want. A way to insert a timestamp into my journal entry outside a table. Onenote has a feature I used called “Insert Date” or “Insert Date and Time” ---
**Author:** ![Joe\_Wolin](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/joe_wolin/32/1014_2.png) [@Joe\_Wolin](https://connect.superhuman.com/u/Joe_Wolin)\ **Post date:** [January 10, 2020, 12:46am UTC](https://connect.superhuman.com/t/insert-timestamp/13144/6 "2020-01-10T00:46:34Z")
The screenshot shows date and time inserted using =Now() function, but this does not remain static so is not useful for timestamp purposes. ---
**Author:** ![Mario](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/mario/32/12232_2.png) [@Mario](https://connect.superhuman.com/u/Mario)\ **Post date:** [January 10, 2020, 10:48am UTC](https://connect.superhuman.com/t/insert-timestamp/13144/7 "2020-01-10T10:48:38Z")
Hi @Joe_Wolin 🙂 In that way you are just writing in the doc, and not storing any data in a table! (you want to write in a table because you want to save that information right? 🙂 ) I’ve prepared that example that shows you a method, my method, but if you want you can use @Paul_Danyliuk one’s that save you a column using the already stored info about time 🙂 Basically you put the text into the first table and then you press the button, be careful to set the text of the table before clicking the button, if you don’t the field will be empty! Have fun with this example 🙂 https://coda.io/embed/e0zE5G6S65/_su6dp?viewMode=embedplay&hideSections=true ---
**Author:** ![Paul\_Danyliuk](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/paul_danyliuk/32/27228_2.png) [@Paul\_Danyliuk](https://connect.superhuman.com/u/Paul_Danyliuk)\ **Post date:** [January 10, 2020, 10:59am UTC](https://connect.superhuman.com/t/insert-timestamp/13144/8 "2020-01-10T10:59:26Z")
As I said, don’t use the `Now()` function in the canvas or as a column formula — it changes. Use `thisRow.Created()`. Yes, even in the canvas, outside of the table. ---
**Author:** ![Jean\_Pierre\_Traets](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/jean_pierre_traets/32/16275_2.png) [@Jean\_Pierre\_Traets](https://connect.superhuman.com/u/Jean_Pierre_Traets)\ **Post date:** [January 10, 2020, 1:46pm UTC](https://connect.superhuman.com/t/insert-timestamp/13144/9 "2020-01-10T13:46:29Z")
Hi @Mario, 💡 Dependig to your needs, just today(), and you will get only the date ---
**Author:** ![Mario](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/mario/32/12232_2.png) [@Mario](https://connect.superhuman.com/u/Mario)\ **Post date:** [January 10, 2020, 2:31pm UTC](https://connect.superhuman.com/t/insert-timestamp/13144/10 "2020-01-10T14:31:51Z")
@Paul_Danyliuk actually the `Now()` formula can be totally eliminated in the canvas, it should be present just in the button 😅 And it can be preferred over `today()` if multiple notes are added per day @Jean_Pierre_Traets, then maybe the one that are made in the same day can be grouped in the table below 😃 For sure the date can also be extrapolated but in case of export (like copy and paste in another doc) those data will be deleted and journal will turn into notes! ---
**Author:** ![Paul\_Danyliuk](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/paul_danyliuk/32/27228_2.png) [@Paul\_Danyliuk](https://connect.superhuman.com/u/Paul_Danyliuk)\ **Post date:** [January 10, 2020, 4:25pm UTC](https://connect.superhuman.com/t/insert-timestamp/13144/11 "2020-01-10T16:25:29Z")
Here’s what I meant by the hack: ![ezgif.com-optimize (67)](https://global.discourse-cdn.com/coda1/original/2X/2/2c0bfec4b5cf001394bca2fe18b160d44640cb75.gif) ---
**Author:** ![Mario](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/mario/32/12232_2.png) [@Mario](https://connect.superhuman.com/u/Mario)\ **Post date:** [January 10, 2020, 4:40pm UTC](https://connect.superhuman.com/t/insert-timestamp/13144/12 "2020-01-10T16:40:53Z")
@Paul_Danyliuk didn’t know that canvas was interpreted as “row”, cool!!! But i think that having those data in a table could be more useful, so for example adding stars, or heart, or other tag that can filtered after 😃 Or other users, or link to something or images ecc… Anyway cool trick! 😃 ---
**Author:** ![Paul\_Danyliuk](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/paul_danyliuk/32/27228_2.png) [@Paul\_Danyliuk](https://connect.superhuman.com/u/Paul_Danyliuk)\ **Post date:** [January 10, 2020, 5:16pm UTC](https://connect.superhuman.com/t/insert-timestamp/13144/13 "2020-01-10T17:16:57Z")
It’s not interpreted as row. That’s why I say it’s a hack. As I said in my first comment, for some reason `thisTable` and `thisRow` right on canvas seem to create some sort of a fake table. ![image](https://global.discourse-cdn.com/coda1/original/2X/7/7056f0eab7551fe788f75dfd703a9ac8316c4182.png) It doesn’t count towards the objects count for free docs, has one row and one column (result of the function, `.Created()`, `.CreatedBy()` etc) 🤷‍♂️ ![image](https://global.discourse-cdn.com/coda1/original/2X/d/df3bbcb7a68d1e7554e62f9b13be9ad7af14c599.png) I’m wondering if Codans themselves know anything about this. @Krunal_Sheth @Ben_Lee ---
**Author:** ![Joe\_Wolin](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/joe_wolin/32/1014_2.png) [@Joe\_Wolin](https://connect.superhuman.com/u/Joe_Wolin)\ **Post date:** [January 11, 2020, 3:47am UTC](https://connect.superhuman.com/t/insert-timestamp/13144/14 "2020-01-11T03:47:09Z")
Thanks for the example @Mario , but I don’t want to use a table because it takes away from my ability to add formatting such as bullets and images in the journal entry. Great example though. ---
**Author:** ![Mario](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/mario/32/12232_2.png) [@Mario](https://connect.superhuman.com/u/Mario)\ **Post date:** [January 11, 2020, 12:23pm UTC](https://connect.superhuman.com/t/insert-timestamp/13144/15 "2020-01-11T12:23:37Z")
@Joe_Wolin you could save also those! 🙂 In other column, so in this way you can have all other type of information organized 🙂 So if you want to later view those data you can in many many ways, some example: - Filter based on date - Filter based on friend who was there - Filter based on how good was the launch that day - Filter about place where you were - or filter just entry with photos made in x place (like greece last year) Possibilities are limitless! You can then display those information as you prefer more, with all the formatting tools (not so many let’s be honest) that coda have 🙂 You could also use this journal with multiple users in that way, and i think that also bullet list are supported in table 🙂 Anyway those are just wild suggestion, knowing what you have to do could make those meaningless 🙂 Happy to help 🙂 ---
**Author:** ![Paul\_Danyliuk](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/paul_danyliuk/32/27228_2.png) [@Paul\_Danyliuk](https://connect.superhuman.com/u/Paul_Danyliuk)\ **Post date:** [January 11, 2020, 12:52pm UTC](https://connect.superhuman.com/t/insert-timestamp/13144/16 "2020-01-11T12:52:48Z")
For the record, you can have bullets and images in table cells. Only thing you can’t have is write formulas within the cell text. But otherwise all formatting is supported there. I know this may sound strange from a Coda aficionado and “community champion”, but perhaps Notion would be a better choice for your journaling needs? Unless there’s something specific you need that only Coda can support (although I cannot think of anything not-table-related that Coda does better atm than Notion) ---
**Author:** ![Asaf\_Dafna](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/asaf_dafna/32/8591_2.png) [@Asaf\_Dafna](https://connect.superhuman.com/u/Asaf_Dafna)\ **Post date:** [January 11, 2020, 9:07pm UTC](https://connect.superhuman.com/t/insert-timestamp/13144/17 "2020-01-11T21:07:38Z")
Another great hack by @Paul_Danyliuk 😀 > [@Paul\_Danyliuk](#): > > I know this may sound strange from a Coda aficionado and “community champion”, but perhaps Notion would be a better choice for your journaling needs? Unless there’s something specific you need that only Coda can support (although I cannot think of anything not-table-related that Coda does better atm than Notion) Totally agree with that (including the “Coda aficionado” part). Although I would strongly recommend RoamResearch for that purpose instead of Notion ---
**Author:** ![ABp](https://avatars.discourse-cdn.com/v4/letter/a/c67d28/32.png) [@ABp](https://connect.superhuman.com/u/ABp)\ **Post date:** [January 16, 2020, 6:05am UTC](https://connect.superhuman.com/t/insert-timestamp/13144/18 "2020-01-16T06:05:23Z")
When the discussion turns to Notion and Roam Research, I am always eager to get involved :)!! I have spent months going between Notion and Coda, and I for one think Notion does little better than Coda. I gave up on Notion as an app for my team as the limitations were so great around things like notifications, limits in table view (you can’t see rich text unless you open a row), and importantly for my use case, traceability across “blocks” when relating to others. This last point is particular relevant to both the comparison with Coda, and new-kid-on-the-block Roam. Notion has even greater limits around relating blocks across the app in free canvas that Coda. With Coda, you can create a button and show relations between two rows at least, although this requires work. In Notion, you just move your blocks around by using “change to,” and before you know it you can lose track of bunches of content. For free form journaling and referencing, I think this is a big drawback. In fact I went back to Evernote after trying hard with Notion. Another problem with Notion for me was you can’t simply write a few paragraphs of text - every single line practically is a “block.” Roam has shown some great implementation however of the ability to create in a “network” fashion, and I think this is extremely relevant to Coda, given Coda’s focus on “making.” I would really like a few more features around reciprocal linking in Coda to kind of “close the loop” on what we already have in Coda with strong lookups, and @mentioning allowing quick reference to a row, but sadly _only one-directional at the moment_. Roam shows the potential and power of creating when you can see your content in various contexts as its created. In my use case for Coda as an all-purpose team management app, I have already seen great benefit to being able to relate stuff like CRM with Projects, Product with Feature Components, and a host of other items that typically can’t easily interact because teams have this stuff in different apps that can’t relate to each other at all. It’s a huge help in prioritization, planning, and even retrospectives too, since you can build notes around work and then create a sort of company log of decisions, repeat discussions around items that fester in a backlog, and so forth. I’m glad to see talk here about Coda pushing forward on some of this reciprocal linking here: > [@Feature request based on Roam Research](https://connect.superhuman.com/t/feature-request-based-on-roam-research/12980): > > I just began to use the beta of Roam Research ([https://roamresearch.com/](https://roamresearch.com/)) which is a bullet based note taking app that is very disruptive. I think I’ll use it for ever now that I tried it. Why am I pointing to this app in Coda? Because I think you could use some of its feature to make an even more shiny Coda grin Two features comes in mind: Bidirectional linking. I believe that this feature is\_slightly_frowning_face too much linked to a product, but I think that Coda could at least integrate a better linking … I have been learning more about Roam and really think it shows the potential of getting reciprocal linking live in Coda. I will shamelessly yet again plug my request for that! > [@Reciprocal links auto-generated with @mentions](https://connect.superhuman.com/t/reciprocal-links-auto-generated-with-mentions/11513/3): > > Dear @ABp, I am testing RoamResearch for one month now and it feels very promissing. As you mentioned, some techniques would be super to see back in Coda, I have written a PM to Nathan about it. RR is targeting a rather different audience and usecases from Coda Related post: Always hopeful my comments are useful, and not just chatter! Speak with you all again shortly! ---
**Author:** ![Gregg\_Stebben](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/gregg_stebben/32/597_2.png) [@Gregg\_Stebben](https://connect.superhuman.com/u/Gregg_Stebben)\ **Post date:** [February 3, 2021, 6:39pm UTC](https://connect.superhuman.com/t/insert-timestamp/13144/19 "2021-02-03T18:39:30Z")
So now I know I am not the only one who stays up all night trying all kinds of platforms! Thanks for the detailed comments on Notion and Roam and even Evernote. My finding (as a somewhat non techie) is that they all do some things well, but every time I get excited about one as the do-it-all platform for my diverse needs, I hit a brick wall. Coda seems to do the most stuff best for me, with the greatest amount of flexibility and customization. I also feel very loyal to the platform because I was an early adopter and I have found tech support and the community to be incredibly welcoming. I wish I was techie enough to feel like I was really giving back in a valuable way. I do want to say that Roam’s ability to link everything to everything (as I understand it) appears both transformative but also overwhelming. I am going to keep following all these platforms because the ecosystem itself is fascinating…and again, I appreciate everyone’s great comments. Gregg