SQLite Web: app.db

id

Primary key. INTEGER

automation_id

INTEGER NOT NULL

status

TEXT NOT NULL

start_time

TEXT NOT NULL

end_time

TEXT

logs

[{"timestamp": "2026-02-27T22:02:52.237181", "level": "info", "message": "Starting automation execution. Context: {\"field_1771059625885\": \"Lat\", \"field_1771059732881\": \"+212766595311\", \"field_1771059775104\": \"0-50\", \"field_1771059785751\": \"\", \"field_1771059794160\": \"\", \"field_1771059803951\": \"[INFO TECHNIQUE]\\nWhatsApp: OUI\\nPays: Maroc (+212)\", \"form_id\": 1, \"form_name\": \"Product Form\", \"submission_id\": 83, \"form_created_at\": \"2026-02-27T22:02:52.213284\", \"source\": \"doctors-agent-landing-page\", \"chatbot_id\": 38, \"name\": \"Lat\", \"body\": \"[INFO TECHNIQUE]\\nWhatsApp: OUI\\nPays: Maroc (+212)\", \"customer_name\": \"Lat\", \"customer_phone\": \"+212766595311\", \"message_volume\": \"0-50\", \"preferred_date\": \"\", \"preferred_time_slot\": \"\", \"additional_notes\": \"[INFO TECHNIQUE]\\nWhatsApp: OUI\\nPays: Maroc (+212)\", \"_field_labels\": {\"field_1771059625885\": \"customer_name\", \"field_1771059732881\": \"customer_phone\", \"field_1771059775104\": \"message_volume\", \"field_1771059785751\": \"preferred_date\", \"field_1771059794160\": \"preferred_time_slot\", \"field_1771059803951\": \"additional_notes\"}}", "node_id": null}, {"timestamp": "2026-02-27T22:02:52.237468", "level": "info", "message": "Standardized variables: ['full_name']", "node_id": null}, {"timestamp": "2026-02-27T22:02:52.237629", "level": "info", "message": "Triggered by node trigger-1 (Form Submitted)", "node_id": "trigger-1"}, {"timestamp": "2026-02-27T22:02:52.237752", "level": "info", "message": "Executing node if_else-3-1772095076195 (if_else)", "node_id": "if_else-3-1772095076195"}, {"timestamp": "2026-02-27T22:02:52.237860", "level": "info", "message": "DEBUG: Processing node if_else-3-1772095076195, type=if_else, action=None", "node_id": null}, {"timestamp": "2026-02-27T22:02:52.238044", "level": "info", "message": "If/Else: AND conditions [False] \u2192 branch='false'", "node_id": null}, {"timestamp": "2026-02-27T22:02:52.238185", "level": "info", "message": "Executing node action-4-1772095275643 (action)", "node_id": "action-4-1772095275643"}, {"timestamp": "2026-02-27T22:02:52.238296", "level": "info", "message": "DEBUG: Processing node action-4-1772095275643, type=action, action=send_whatsapp", "node_id": null}, {"timestamp": "2026-02-27T22:02:53.076801", "level": "info", "message": "Successfully sent WA message to 33766648942", "node_id": null}, {"timestamp": "2026-02-27T22:02:53.077175", "level": "info", "message": "Skipping edge to action-6-1772153862357 (handle='true' != branch='false')", "node_id": "if_else-3-1772095076195"}, {"timestamp": "2026-02-27T22:02:53.077361", "level": "info", "message": "Executing node action-6-1772095880187 (action)", "node_id": "action-6-1772095880187"}, {"timestamp": "2026-02-27T22:02:53.077503", "level": "info", "message": "DEBUG: Processing node action-6-1772095880187, type=action, action=delay", "node_id": null}, {"timestamp": "2026-02-27T22:02:53.078470", "level": "info", "message": "Executing node action-5-1772095876275 (action)", "node_id": "action-5-1772095876275"}, {"timestamp": "2026-02-27T22:02:53.078607", "level": "info", "message": "DEBUG: Processing node action-5-1772095876275, type=action, action=send_whatsapp", "node_id": null}, {"timestamp": "2026-02-27T22:02:53.898953", "level": "info", "message": "Successfully sent WA message to 212766595311", "node_id": null}, {"timestamp": "2026-02-27T22:02:53.899164", "level": "info", "message": "End of path at node action-5-1772095876275", "node_id": "action-5-1772095876275"}, {"timestamp": "2026-02-27T22:02:53.899228", "level": "info", "message": "Automation completed successfully", "node_id": null}]

TEXT

context_snapshot

{"field_1771059625885": "Lat", "field_1771059732881": "+212766595311", "field_1771059775104": "0-50", "field_1771059785751": "", "field_1771059794160": "", "field_1771059803951": "[INFO TECHNIQUE]\nWhatsApp: OUI\nPays: Maroc (+212)", "form_id": 1, "form_name": "Product Form", "submission_id": 83, "form_created_at": "2026-02-27T22:02:52.213284", "source": "doctors-agent-landing-page", "chatbot_id": 38, "name": "Lat", "body": "[INFO TECHNIQUE]\nWhatsApp: OUI\nPays: Maroc (+212)", "customer_name": "Lat", "customer_phone": "+212766595311", "message_volume": "0-50", "preferred_date": "", "preferred_time_slot": "", "additional_notes": "[INFO TECHNIQUE]\nWhatsApp: OUI\nPays: Maroc (+212)", "_field_labels": {"field_1771059625885": "customer_name", "field_1771059732881": "customer_phone", "field_1771059775104": "message_volume", "field_1771059785751": "preferred_date", "field_1771059794160": "preferred_time_slot", "field_1771059803951": "additional_notes"}, "trigger": {"field_1771059625885": "Lat", "field_1771059732881": "+212766595311", "field_1771059775104": "0-50", "field_1771059785751": "", "field_1771059794160": "", "field_1771059803951": "[INFO TECHNIQUE]\nWhatsApp: OUI\nPays: Maroc (+212)", "form_id": 1, "form_name": "Product Form", "submission_id": 83, "form_created_at": "2026-02-27T22:02:52.213284", "source": "doctors-agent-landing-page", "chatbot_id": 38, "name": "Lat", "body": "[INFO TECHNIQUE]\nWhatsApp: OUI\nPays: Maroc (+212)", "customer_name": "Lat", "customer_phone": "+212766595311", "message_volume": "0-50", "preferred_date": "", "preferred_time_slot": "", "additional_notes": "[INFO TECHNIQUE]\nWhatsApp: OUI\nPays: Maroc (+212)", "_field_labels": {"field_1771059625885": "customer_name", "field_1771059732881": "customer_phone", "field_1771059775104": "message_volume", "field_1771059785751": "preferred_date", "field_1771059794160": "preferred_time_slot", "field_1771059803951": "additional_notes"}}, "full_name": "Lat", "if_else-3-1772095076195": {"branch": "false"}, "action-4-1772095275643": {"status": "success", "recipient": "33766648942", "message": "\ud83d\udce9 Nouveau Lead\n\ud83d\udc64 Nom :  Lat\n\ud83d\udcde T\u00e9l\u00e9phone :+212766595311\n\ud83c\udff7\ufe0fNombre de message par jour : 0-50\n\ud83d\udcd2Notes : [INFO TECHNIQUE]\nWhatsApp: OUI\nPays: Maroc (+212)"}, "action-6-1772095880187": {"status": "error", "error": "name 'context' is not defined"}, "action-5-1772095876275": {"status": "success", "recipient": "212766595311", "message": "Bonjour \ud83d\udc4b\nMerci pour votre demande d\u2019agent IA r\u00e9ceptionniste \ud83e\udd16\nNotre \u00e9quipe va vous appeler tr\u00e8s prochainement inchaAllah pour en discuter.\n\n\u00c0 tr\u00e8s vite ! \ud83d\ude80"}}

TEXT

app.db — automation_runs

Update row 86 in automation_runs