# How do you schedule an Adalo notification before a date when date math fails?

Calculate the reminder time in a Date/Time property, then schedule the notification from that stored timestamp using No Formatting.

- Canonical URL: https://adalocado.com/answers/schedule-notification-before-date-without-inline-math
- Verification: Documented from current sources
- Topic: Actions and Logic
- Skill level: Intermediate
- Last reviewed: 2026-08-16
- Index status: index-now

## Short answer

Create a Date/Time property to store each reminder timestamp, calculate the offset before the Schedule Notification action, then map that property into Scheduling Date with No Formatting.

When inline date math prevents Adalo from creating a scheduled notification, calculate the reminder time before the scheduling action. Store the result in a Date/Time property, then map that stored value into Scheduling Date with No Formatting.

For multiple reminders, create a separate timestamp and Schedule Notification action for each offset. Save each returned Job ID if the reminder may need to be cancelled or changed. This answer is based on an explicit but unmarked forum resolution and is corroborated by current official Adalo documentation.

## Intended outcome

One or more reminders are scheduled from stored timestamps instead of failing because date arithmetic was placed directly in the scheduling field.

## Requirements

- Notification permission enabled for the receiving user
- A collection record with a Date/Time property for each reminder timestamp
- A button or other action that has access to the match, appointment, or event date

## Step by step

1. **Store the reminder timestamp**

   Create a notification record or another suitable record with a Date/Time property such as Start Date. Set it from the event date minus the required offset, for example -1 day or -3 days.

2. **Schedule from the stored date**

   Immediately after creating or updating that record, add the Schedule Notification action and map its Scheduling Date to the stored Date/Time property.

3. **Choose No Formatting**

   Open the mapped date’s format menu and select No Formatting. Adalo’s documentation says this supplies the Unix timestamp required by the scheduling action.

4. **Create each required reminder**

   For two reminders, calculate and schedule each timestamp separately. Store each returned Job ID if the app needs to cancel or manage the reminders later.

## Why it works

- Date arithmetic is completed while creating or updating a database record, where the resulting value remains a Date/Time value.
- The Schedule Notification action receives the already-calculated timestamp through Magic Text with No Formatting instead of evaluating inline date math.

## Data model

| Collection | Properties | Relationships |
| --- | --- | --- |
| Scheduled Notifications | Start Date (Date/Time), Notification Job ID, title, body, and optional offset label | Belongs to the recipient User and optionally to the related match, appointment, or event |

## Common failures

### The notification is not created or sent

Confirm the mapped date uses No Formatting, the notification body is not empty, the recipient has granted permission, and the calculated Start Date is in the future.

### The Job ID is missing

Run the Update Notification Record action immediately after Schedule Notification and map Scheduled Notification > Job ID into the record.

## Testing checklist

- [ ] Create an event several days in the future and verify that the stored -1 day and -3 day timestamps and scheduled jobs are distinct and correct.
- [ ] Use a past or incorrectly formatted timestamp and confirm the workflow fails safely without creating a misleading reminder record.
- [ ] The stored reminder timestamps match the intended offsets
- [ ] Each Schedule Notification action uses No Formatting
- [ ] The recipient and non-empty body are present
- [ ] Every scheduled reminder has its own Job ID when management is required

## Limitations

- The topic author explicitly described this fix, but the forum topic was not marked solved or given an accepted answer.
- Current Adalo documentation corroborates the stored Start Date and No Formatting pattern; Adalocado has not reproduced the complete workflow in a builder project.
- Delivery still depends on notification permissions, a non-empty body, a future date, and the user-activity requirements documented by Adalo.

## Community evidence

### [Scheduled notifications](https://forum.adalo.com/t/scheduled-notifications/69515/3)

The author reports that inline math failed in the Scheduled Notification action, while calculating the reminder Date/Time in the database and mapping it with No Formatting worked. Boundary: The post is an explicit self-resolution but was not marked as an accepted forum answer.

### [Scheduled Notifications With Math](https://forum.adalo.com/t/scheduled-notifications-with-math/68685/2)

The staff reply describes storing the offset Date/Time first, mapping that property into the scheduling action, and choosing No Formatting. Boundary: This is staff guidance in a public forum thread, not a product guarantee or hands-on Adalocado reproduction.

## Sources

- [Adalo forum resolution](https://forum.adalo.com/t/scheduled-notifications/69515/3)
- [Adalo forum staff walkthrough](https://forum.adalo.com/t/scheduled-notifications-with-math/68685/2)
- [Adalo Help: Create Scheduled Notification on Trigger](https://help.adalo.com/actions/notifications/scheduled-notifications/create-scheduled-notification-on-trigger)
- [Adalo Help: Troubleshooting Scheduled Notifications](https://help.adalo.com/actions/notifications/scheduled-notifications/troubleshooting-scheduled-notifications)

Markdown version: https://adalocado.com/answers/schedule-notification-before-date-without-inline-math.md