I need to get a simple date added and then modified for each day, in the database to indicate the day a user is on. So right now I am trying to get the signup form to add the signup date and create the first instance of a day number field. So on the day of the signup, it should be day 1, the next da…

Round((current time-tomorrow),0)+1 seems to work on day one, but will this work to increment each day?

Hi @Rninja , Did you try this one? It worked for my existing user and newly just-added user. [Screenshot 2023-10-24 at 16.22.09] Best, Victor.

Hi @Victor and Thanks. What is “User created Date” set to? I haven’t tried that particular format but will. Do you know if what I posted last will increment? I feel like it won’t but not sure about the logic to get it to.

Hi @Rninja , User created date is the field “created date” in Users collection. It is a built-in field which stores the datetime value when a record was created. “Created date” and “Updated date” fields exist in all collections. Round(current time-tomorrow) will result in either -1 or 0. Time is st…

Thanks for that explanation @Victor . I left the initial calculation intact but I guess I could just set it to “1” when someone registers, then add an action to update the record when viewing the home screen. Is that the best way though, or is there a more efficient/graceful way to update the day nu…

Hi @Rninja , Sorry, but I’m not sure I understand what would you like to achieve. My example is how to display number of days since a particular user has signed up. If you would like record the day when user opened the app for the last time, you will need to add a separate property for that and upd…

So what I initially meant was to get the day counter started as a user signed up, then as each day elapsed, increment the day counter to match records for a daily task list in the database. So since each user can sign up on another date, the counter needs to be specific to them. I was just unsure if…

@Victor ,I tried the formula you provided and changed the database property to a text field, but upon sign up, it didn’t record a value. So the DB is empty for the Day Number property… Am I missing something? I did these steps: Changed the DB property to a text field called “Day Number” Added a c…

How do I actually auto-increment the day number? The form won’t add it in my opinion, because the user isn’t created yet, so the signup date or created date doesn’t exist - thus no entry. Thus empty DB records…

Just wanted to ping you or anyone else @Victor who may know the answer to this.

Need to get the day number based on signup

Get Help

Victor October 24, 2023, 1:23pm 3

Hi @Rninja,

Did you try this one? It worked for my existing user and newly just-added user.

Best,
Victor.

How can i create count up (days only)

Topic		Replies	Views
Show user how many days are from the days he signed up? Get Help	3	367	March 15, 2021
How can i create count up (days only) Get Help	2	51	January 9, 2026
Create New User and Update Record Database	5	433	September 29, 2023
Calculate date and update database property Get Help	3	57	September 9, 2025
Please help with action issue! Get Help	4	211	June 18, 2023

Need to get the day number based on signup

Related topics