SQLite Web: app.db

id

Primary key. INTEGER

name

TEXT NOT NULL

description

TEXT

chatbot_id

INTEGER NOT NULL

trigger_type

TEXT NOT NULL

is_active

INTEGER (default 1

flow_data

{"nodes": [{"id": "trigger-1", "type": "trigger", "position": {"x": 36.156307129798904, "y": 107.58500914076785}, "data": {"label": "Form Submitted", "triggerType": "form_submission", "nodeName": "form", "form_id": 2, "testResult": {"triggered_at": "2026-06-10T08:21:45.589980", "trigger_type": "form_submission", "name": "Test value", "email": "", "phone": "+33612345678", "Phone": "+33612345678", "body": "", "form_data": "{\"field_1781075185808\": \"Test value\", \"field_1781075194735\": \"Test value\", \"field_1781075209963\": \"Test value\", \"field_1781075240170\": \"+33612345678\", \"field_1781076568798\": \"Test value\", \"form_id\": 2, \"form_name\": \"Walid-Form\", \"submission_id\": 136, \"source\": \"test\", \"chatbot_id\": 47, \"phone\": \"+33612345678\", \"Phone\": \"+33612345678\", \"name\": \"Test value\", \"motif\": \"Test value\", \"pr\\u00e9nom\": \"Test value\", \"nom\": \"Test value\", \"t\\u00e9l\\u00e9phone\": \"+33612345678\", \"utm\": \"Test value\"}", "field_1781075185808": "Test value", "field_1781075194735": "Test value", "field_1781075209963": "Test value", "field_1781075240170": "+33612345678", "field_1781076568798": "Test value", "form_id": 2, "form_name": "Walid-Form", "submission_id": 136, "form_created_at": "2026-06-10T08:21:45.589980", "source": "test", "chatbot_id": 47, "motif": "Test value", "pr\u00e9nom": "Test value", "nom": "Test value", "t\u00e9l\u00e9phone": "+33612345678", "utm": "Test value", "_field_labels": {"field_1781075185808": "motif", "field_1781075194735": "Pr\u00e9nom", "field_1781075209963": "Nom", "field_1781075240170": "T\u00e9l\u00e9phone", "field_1781076568798": "utm"}}}, "width": 220, "height": 112, "selected": false, "positionAbsolute": {"x": 36.156307129798904, "y": 107.58500914076785}, "dragging": false}, {"id": "action-1", "type": "action", "position": {"x": 250, "y": 300.5}, "data": {"label": "Send WhatsApp", "actionType": "send_whatsapp", "template": "Bonjour {{trigger.pr\u00e9nom}} \ud83d\udc4b\n\nOn a bien re\u00e7u votre demande pour **{{trigger.motif}}**.\n\nBonne nouvelle : votre premi\u00e8re consultation au Centre Dentaire Halim est enti\u00e8rement gratuite \ud83c\udf89\n\nDites-nous vos disponibilit\u00e9s (jour et cr\u00e9neau) et le Dr Walid vous confirmera un rendez-vous.\n\n\ud83d\udccd Immeuble 89, 1er \u00e9tage, Avenue Abou Bakr El Kadiri, Casablanca\n\ud83d\uddfa\ufe0f https://maps.app.goo.gl/S1mK6eAmV7iRy69S9\n\nNous recevons du lundi au jeudi et le samedi, de 9h \u00e0 18h.\n\n\u00c0 tr\u00e8s vite \ud83d\ude0a", "nodeName": "sending msg", "recipient": "{{trigger.phone}}"}, "width": 220, "height": 112, "selected": false, "dragging": false, "positionAbsolute": {"x": 250, "y": 300.5}}, {"id": "action-3-1781455990284", "type": "action", "position": {"x": 526.1969040984659, "y": 522.7268880172206}, "data": {"label": "New Action", "actionType": "send_whatsapp", "nodeName": "notification assistant", "template": "Bonjour ! J\u2019ai rempli votre formulaire et j\u2019aimerais en savoir plus sur votre entreprise.\n\nquel_est_le_principal_motif_de_votre_visite_?:  {{trigger.motif}}\n\nNum\u00e9ro: {{trigger.t\u00e9l\u00e9phone}}\n\nnom_complet: {{trigger.pr\u00e9nom}}", "recipient": "212629035220"}, "width": 220, "height": 112, "selected": true, "dragging": false}], "edges": [{"id": "e1-2", "source": "trigger-1", "target": "action-1", "type": "deletableSmoothstep"}, {"type": "deletableSmoothstep", "animated": false, "style": {"strokeWidth": 2, "strokeDasharray": "8 4", "stroke": "var(--color-border, #94a3b8)"}, "interactionWidth": 20, "source": "action-1", "sourceHandle": null, "target": "action-3-1781455990284", "targetHandle": null, "id": "reactflow__edge-action-1-action-3-1781455990284"}]}

TEXT NOT NULL

schedule

TEXT

created_at

TEXT NOT NULL

updated_at

TEXT

webhook_token

TEXT

app.db — automations

Update row 8 in automations