Calculate date and update database property

Get Help
1

I have two tables [USERS] and [PARTNERS] with a many to one relationship respectively. I have a number property [PARTNERS - TERM]. I have a date property [USERS -END DATE]. When a user signs up, I would like to populate [USERS - END DATE] with [USERS - CREATED (a system generated date) + [PARTNERS - TERM] where term is a whole number value representing years. So, if the user signed up 09/01/2025, and the term was 5, the END DATE would be 09/01/2030 or 08/31/2030….whichever is most accurate, not really sure, and I am fine with either :slight_smile: .

3

You’d likely need to use a Zapier/Make integration to get this done.

  1. Trigger: New User (Adalo → Zapier/Make).
  2. Step: Formatter / Date > “Add years” = Partner.Term.
  3. Action: Adalo > Update User (set End Date to the formatted result).

This avoids writing code; it runs a second after sign-up and updates the user. Adalo formulas don’t add years to dates natively, so you either call a tiny endpoint (Option A) or use an automation (Option B). Pick same-day or end-of-month, both are acceptable; just be consistent.

4

Hi @kristoffer.pagel,

Welcome to the forum!

Just in case: dates (datetimes) in Adalo are represented as a number of days since 01/01/1970. They are stored as GMT+0, for datetime the fractional part is a “part” of the time in this day (e.g. 20333,25 will be Tuesday, September 2, 2025, 6:00 AM GMT+0). Dates are displayed to a user in their device’s timezone.

You can perform addition and subtraction operation with dates. If have a date property with September 2, 2025, and you add 2 to it, you will get Sep 4, 2025.

So in your case, if you’re ok to skip leap years (where you have 366 days), then you can simply add 1825 (=5*365) to the date of registration. Keep in mind though, that it is not a good idea to add this action right after signup (on the same screen), better do it on the next screen. This is an old Adalo bug where user isn’t fully created before moving to the next screen after signup.

Best regards, Victor.

5

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.