Bookmark ID - how to create bookmarks without overwriting old ones

[#1]

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!

[Gysbert_Wassenaar · Accepted solution]

You could use the current date and time: ='BM' & floor(num(now())*8640000)

[#3]

Awesome - this worked perfectly.  Thank you!

[#4]

Hi

in the above expression why we need to multiply with 8640000?

[#5]

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).