
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Bookmark ID - how to create bookmarks without overwriting old ones
Hi all - I'm looking to make a button to create bookmarks but I don't know what to put for the ID to make sure that I'm only adding and not overwriting a previous bookmark. I'd like to make it so that if someone were to hit bookmark in rapid succession, they'd just add Bookmark 1, Bookmark 2, and Bookmark 3. Thanks!
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You could use the current date and time: ='BM' & floor(num(now())*8640000)
talk is cheap, supply exceeds demand

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You could use the current date and time: ='BM' & floor(num(now())*8640000)
talk is cheap, supply exceeds demand

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Awesome - this worked perfectly. Thank you!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
in the above expression why we need to multiply with 8640000?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I multiplied by 84600 instead, which is 60 x 60 x 24 - the number of seconds in a day. Gysbert's version was just 10x more accurate. It makes it so that clicking the button will append the exact time when your bookmark was made, to the second, as the bookmark ID number. That makes it much more difficult to overwrite a bookmark by clicking the button quickly (though if you were to double-click within a second, I imagine it would overwrite the first click).
