Contact person: Adalo × Make × OneSignal — One notification per recipient per day (even if multiple messages are received)

Phone:Show

Email:Show

Location: Chofu, Japan

Budget: Recommended by industry experts

Time to start: As soon as possible

Project description:
"Title
Adalo × Make × OneSignal — One notification per recipient per day (even if multiple messages are received)

Goal
・ One notification per recipient per day, even if multiple messages are received (extra messages ignored)
・ Delivery time = random within 24 hours of the first received message
・ Must work properly on iOS and Android (Adalo app)

Requirements
Scenario 1 (Sorting Hub)
・ Receive messages from Adalo (already via Webhook)
・ Group by recipient + date (YYYY-MM-DD, Asia/Tokyo)
・ Decide due_at (random 0–1440 minutes from first message)
・ Logic:
　・ If no record exists: create new record with recipient_id, date_key, first_msg_at=now, last_msg_at=now, message_count=1, due_at, sent=false
　・ If record exists: ignore new message for notification, update only message_count = message_count+1, last_msg_at=now, do not change due_at

Scenario 2 (Courier)
・ Search Data store for sent=false AND due_at<=now
・ Send notification via OneSignal (badge/count always = 1)
・ Update record: sent=true, sent_at=now

Current Status
・ Adalo → Make Webhook works (Custom Action built)
・ Scenario 1 built but Upsert not working correctly
・ Scenario 2 not created yet

Scope of Work
・ Fix Scenario 1 (Upsert issue) or rebuild
・ Build Scenario 2 (schedule, search, OneSignal send, update)

Access (after award)
・ Make (Data store)
・ OneSignal
・ Adalo IDs (if needed)

Budget & Deadline
・ $57 (success-based, including passing test)
・ Delivery within 4 days after offer is sent (JST)

Acceptance Criteria
・ One notification per recipient per day (multiple messages ignored)
・ Delivered randomly within 24h of the first message
・ Works on iOS + Android
・ Record updates to sent=true after delivery
・ Minimal logging: message_count, first_msg_at, last_msg_at" (client-provided description)