Storing timestamps in Bubble database and retrieving them

Need help
1

As far as I can see, there is no “time” or “timestamp” field type in the Bubble database. I’m doing some analytics on the clicks within my application, and I would like to record the precise timestamps of clicks in my Bubble database and retrieve the same, in order to perform some logic using workflows.

What’s the best way for me to do this?

2

The type you’re looking for is the date field (where you can store both, date as well as the timestamp)

3

Hey Sandeep,

There are two ways to store a timestamp in Bubble:

  1. Using a Date/Time field – This is the most common approach if you want Bubble to automatically handle date and time operations.
  2. Using a Number field – You can store the timestamp in seconds (or milliseconds) and perform your own custom logic or calculations as needed.

It really depends on your use case and the kind of logic you want to implement.

Regards:
Muhammad Adnan | Portfolio