Scheduled Notification Database Setup

To schedule notifications, create a collection to track all scheduled notifications. This stores reminder details, timing, and the Job IDs needed to manage them.

Example Database Structure

Create a new collection with these core properties:

Property Name	Property Type	Purpose
Name	Text	Title/description of the notification (e.g., "Appointment Reminder", "Task Due")
Start Date	Date and Time	When the notification will be sent
Related Record	Relationship	Links to the main record this notification is for
User	Relationship	The user who will receive the notification
Notification Job ID	Text	Unique ID from Adalo (required for managing notifications)

Optional properties: Body, Title, Message, Frequency, Draft toggle, Type

Key relationships:

• Many Notifications to One Main Record (e.g., Many Reminders to One Appointment)

• Many Notifications to One User