I’ve just spent some time reading through several topics about how Bubble handles dates, and I’m still not sure how it will apply in my situation. Hoping someone can bring some clarity.
What I am trying to do is track some user interactions into a Stat Type. A simple example would be counting the number of clicks on a button. I will want an admin user to be able to view and export these as CSV. Here’s what I am thinking the workflow will look like.
- Create a row in the database for this specific button for this day if it does not exist.
- Increment click count.
The first step is necessary in my case because new info is added to the app every day and there is no reason to create stats for old items that are no longer getting clicks.
Now, here is where I am confused. The Bubble documentation says that dates are saved for the users timezone which makes sense if I want to display that date back to that user, but I need my stats to be locked to the Company HQ timezone, because they stats will lose meaning without a standard.
Q1. Assume I create a new stat thing based on a user interaction and I fill a day field with date (hours, minutes, seconds set to 0) only when a thing with that day doesn’t exist; Will I get consistent results even if the first interaction is in New York one day and California the next.
Q2. If I have 2 admin users based in 2 timezones, will they see the same stats?
Q3. If not how do I standardize the day date field to an arbitrary time zone?