Yap & Gonzales Family
Cloud Sync
TOTAL CONTACTS
0
🥳 BIRTHDAYS TODAY
0
THIS WEEK (7 DAYS)
0
MONTH (30 DAYS)
0
NEXT BIRTHDAY COUNTDOWN
Celebrant:
-
Category:
-
Date:
-
Turning:
-
Countdown:
-
UPCOMING BIRTHDAYS (filter by
category)
Category filter:
| # | Name | Category | Next Birthday | Days Left | Turning |
|---|
BY CATEGORY
| Category | Count |
|---|
BY MONTH
All Birthdays
| Name | Category | Tags | Birthday | Next Birthday | Days Until | Turning | Status | Birth Month | Actions |
|---|
Add New Birthday Contact
Category & Tag Management
Editing categories or custom tags will automatically update all assigned contacts in the database and keep all filters in sync.
Manage Categories
| Category Name | Contacts | Actions |
|---|
Manage Custom Tags
| Tag Name | Usage | Actions |
|---|
Family Events & Email Announcements
Send automated bulk emails, announcements, greetings, and reunion updates directly via Google Apps Script & Gmail API.
Birthday
Greetings!
Birthday
Family Announcement
Announcement
Family
Reunion Invitation
Reunion
Family Reminder
Reminder
Dispatch & Announcement History
| Date Sent | Recipients (To) | Subject Line | Type | Attachments | Actions |
|---|
Contacts Directory
Independent address book (saved separately from the birthday dashboard)
| Name | Category | Phone | FB Link | Tags | Notes | Actions |
|---|
🌳 Family Tree Chart
Hierarchical visualization with automatic connectors (Saved independently)
Generations:
Gen 1:
Grandparents
Gen 2: Parents
/ Uncles
Gen 3: Self /
Siblings
Gen 4:
Children
Family Members in Active Tree
| Name | Role / Relationship | Generation | Parent(s) / Connected Under | Birth Year / Info | Notes | Actions |
|---|
Yap & Gonzales Family Portal Manual
- Dashboard & Live Countdown: The system automatically calculates next birthdays, turnings, and days remaining relative to today's date in real-time.
- ☁️ Google Apps Script & Cloud Sync: Deploy your Birthday_code.gs backend in Google Sheets. Paste your Web App URL to sync all multi-tabs and trigger automated background Gmail sending with Base64 attachments.
- 📢 Events & Announcements: Fill out recipient Gmails (comma-separated or quick-fill all), write custom messages, and attach files (Images, PDFs, documents). When sent, it automatically delivers the email via Gmail API and logs the dispatch to your database!
- Editable Categories & Cascade Sync: Renaming any category or custom tag updates every linked contact and active filter dropdown across the portal immediately.
- 📇 Private Contacts Directory: An independent contact book for phone numbers, Facebook links, and email addresses.
- 🌳 Multi-Tree Family Chart: Switch between maternal and paternal lines, duplicate entire trees with one click, and manage parent-child generations.