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-03-14T12:12:41.891109", "level": "info", "message": "Starting automation execution. Context: {\"field_1771059625885\": \"Test value\", \"field_1771059732881\": \"Test value\", \"field_1771059775104\": \"Test value\", \"field_1771059785751\": \"2026-03-14\", \"field_1771059794160\": \"Test value\", \"field_1771059803951\": \"Sample message for testing.\", \"form_id\": 1, \"form_name\": \"Product Form\", \"submission_id\": 127, \"form_created_at\": \"2026-03-14T12:12:41.858109\", \"source\": \"test\", \"chatbot_id\": 38, \"name\": \"Test value\", \"body\": \"Sample message for testing.\", \"customer_name\": \"Test value\", \"customer_phone\": \"Test value\", \"message_volume\": \"Test value\", \"preferred_date\": \"2026-03-14\", \"preferred_time_slot\": \"Test value\", \"additional_notes\": \"Sample message for testing.\", \"_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-03-14T12:12:41.891364", "level": "info", "message": "Standardized variables: ['full_name']", "node_id": null}, {"timestamp": "2026-03-14T12:12:41.891504", "level": "info", "message": "Triggered by node trigger-1 (Form Submitted)", "node_id": "trigger-1"}, {"timestamp": "2026-03-14T12:12:41.891634", "level": "info", "message": "Executing node action-1 (action)", "node_id": "action-1"}, {"timestamp": "2026-03-14T12:12:41.891706", "level": "info", "message": "DEBUG: Processing node action-1, type=action, action=send_whatsapp", "node_id": null}, {"timestamp": "2026-03-14T12:12:41.894390", "level": "error", "message": "No recipient phone number found for WhatsApp action", "node_id": null}, {"timestamp": "2026-03-14T12:12:41.894496", "level": "info", "message": "End of path at node action-1", "node_id": "action-1"}, {"timestamp": "2026-03-14T12:12:41.894576", "level": "info", "message": "Automation completed successfully", "node_id": null}]

TEXT

context_snapshot

{"field_1771059625885": "Test value", "field_1771059732881": "Test value", "field_1771059775104": "Test value", "field_1771059785751": "2026-03-14", "field_1771059794160": "Test value", "field_1771059803951": "Sample message for testing.", "form_id": 1, "form_name": "Product Form", "submission_id": 127, "form_created_at": "2026-03-14T12:12:41.858109", "source": "test", "chatbot_id": 38, "name": "Test value", "body": "Sample message for testing.", "customer_name": "Test value", "customer_phone": "Test value", "message_volume": "Test value", "preferred_date": "2026-03-14", "preferred_time_slot": "Test value", "additional_notes": "Sample message for testing.", "_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": "Test value", "field_1771059732881": "Test value", "field_1771059775104": "Test value", "field_1771059785751": "2026-03-14", "field_1771059794160": "Test value", "field_1771059803951": "Sample message for testing.", "form_id": 1, "form_name": "Product Form", "submission_id": 127, "form_created_at": "2026-03-14T12:12:41.858109", "source": "test", "chatbot_id": 38, "name": "Test value", "body": "Sample message for testing.", "customer_name": "Test value", "customer_phone": "Test value", "message_volume": "Test value", "preferred_date": "2026-03-14", "preferred_time_slot": "Test value", "additional_notes": "Sample message for testing.", "_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": "Test value"}

TEXT

app.db — automation_runs

Update row 130 in automation_runs