User’s account creation date?

Hello,

I have two questions, please:

  • How can I automatically add the user’s account creation date to the user table when a user creates his account?

  • A single user can enter multiple events and assign a 2025 budget, a 2026 budget, and a 2027 budget for each of them. How can I calculate the total budget per user for all events per year: 2025, 2026, 2027?

Many Thanks :slight_smile:

You can use a mix of query and rollup columns.

You can design an onboarding tab where you collect further info about the user (First Name, Last Name, Profile Picture). At the end of that process, have a “Finish Onboarding” button that would collect the “creation date” of the account.

By design, it’s not the true “creation date” as in the first time the user logs in, but that’s as good as it can get with native Glide Tables.

I assume you have it in this format:

Project ID User ID 2025 Budget 2026 Budget 2027 Budget
P001 U001 $10,000 $12,000 $15,000
P002 U002 $8,500 $9,200 $10,000
P003 U001 $11,300 $12,100 $13,500

Then if you just want to calculate the total budget per user:

  • Have a relation from the Users table to the Projects table, match multiple records using the User ID column.
  • Do 3 rollups on top of the relation for 2025, 2026 and 2027 budget.
2 Likes

Thank you very much Thinh for your answers.
I’ll try that.
Something I can’t seem to get around.
If I understand correctly, to access the app, creating a Glide account only requires the user to provide an email address.
In a second step, we have to submit a “My Account” form to ask for their first name, last name, photo, etc.

My two questions:

  • When I edit this new “form” tab and fill it out, instead of updating and completing my User account, it adds a new user to my table, which creates duplicates.

  • Is there a way to “enforce” this “My Account” page in Glide account creation, i.e., display this page with certain required fields right after the welcome screen where they are asked to enter their email address to create their Glide account?

Thank you.

1 Like

Thanks so much Maxime!

1 Like

Yes, that’s correct. It doesn’t have to be a form, I usually use a custom screen built on top of the Users table, filtered to the signed-in user’s row and just have them input the info there.

A form would add a new row, whilst the User row already exist at that point.

Yes, you can have a column to flag if the user has already onboarded or not. It can be a timestamp that you fill the current timestamp in when they finish the onboarding flow.

For the tab visibilities, you would want to show the Onboarding tab when that timestamp column is empty, and vice versa.

1 Like

OK I succeed to do that, except for the current timestamp, I don’t know how to generate this data into the column? Is there a specific formula to generate this current date/time? Thanks

You can have a button that displays when the user has completed all the required fields on the screen. Change the button action to Set Column and configure it to write the current date and time to the user row.

1 Like

Perfect Jeff, I tried and it works! Thanks

2 Likes

Anytime!