@tanglemedia/directus-extension-bundle-form-submissions

--- package/src/shared/utility/migrations.js (excerpt) ---
const { exec } = require("child_process");
const { promisify } = require("util");
const path = require("node:path");
const execPromise = promisify(exec);

const moveMigrationScripts = async (logger) => {
  const ROOT = process.cwd();
  const EXTENSION_PATH = __dirname;

  let migrationSrcPath = EXTENSION_PATH.split("/");
  migrationSrcPath.pop();
  migrationSrcPath.push("migrations");
  migrationSrcPath = path.join("/", ...migrationSrcPath);

  let migrationDestPath = ROOT.split("/");
  migrationDestPath.push("migrations");
  migrationDestPath = path.join("/", ...migrationDestPath);

  // create destination folder
  let { stdout, stderr } = await execPromise(`mkdir -p ${migrationDestPath}`);
  if (stderr) return;

  // copy files
  ({ stdout, stderr } = await execPromise(
    `cp -r ${migrationSrcPath}/* ${migrationDestPath}`,
  ));
  if (stderr) return;
};

module.exports = moveMigrationScripts;


--- package/migrations/20260401B-form-submissions-~-add-initial-data.mjs (excerpt) ---
export async function up(knex) {
	await knex("tngl_form_submissions").insert([
		{
			body: JSON.stringify({
				email: "john.doe@gmail.com",
				message: "I would like to inquire about your services.",
				last_name: "Doe",
				first_name: "John",
			}),
			date_created: knex.fn.now(),
			form_name: "Contact Us",
			ip_address: "192.168.1.104",
			message:
				"First Name: John\nLast Name: Doe\nEmail: john.doe@gmail.com\nMessage: I would like to inquire about your services.",
			sender_email: "john.doe@gmail.com",
			source_url: "https://example.com/contact",
			spam: false,
		},
		{
			body: JSON.stringify({
				email: "sarah.mitchell@outlook.com",
				phone: "403-555-0192",
				message:
					"We are looking for a quote on a bulk order for our upcoming event.",
				last_name: "Mitchell",
				first_name: "Sarah",
			}),
			date_created: knex.fn.now(),
			form_name: "Contact Us",
			ip_address: "74.125.224.72",
			message:
				"First Name: Sarah\nLast Name: Mitchell\nEmail: sarah.mitchell@outlook.com\nPhone: 403-555-0192\nMessage: We are looking for a quote on a bulk order for our upcoming event.",
			sender_email: "sarah.mitchell@outlook.com",
			source_url: "https://example.com/quote",
			spam: false,
		},
		{
			body: JSON.stringify({
				email: "marcus.reyes@yahoo.com",
				interests: ["Technology", "Design", "Business"],
				last_name: "Reyes",
				first_name: "Marcus",
			}),
			date_created: knex.fn.now(),
			form_name: "Contact Us",
			ip_address: "45.33.32.156",
			m

--- package/migrations/20260401D-form-submissions-~-add-email-notification-flow.mjs (excerpt) ---
import { generateUUIDv4 } from "./helpers/generator.mjs";

const OPERATION_KEY = "send_email";

export async function up(knex) {
	const flowId = generateUUIDv4();
	const operationId = generateUUIDv4();

	// add directus flow
	await knex("directus_flows").insert({
	id: flowId,
		name: "Send Email Notification",
		icon: "bolt",
		color: null,
		description: "Sends an email notification when a form is submitted",
		status: "active",
		trigger: "event",
		accountability: "all",
		options: JSON.stringify({
			type: "action",
			scope: ["items.create"],
			collections: ["tngl_form_submissions"],
		}),
		operation: operationId,
	});

	// add directus operation
	const directusOperationsOptions = {
		to: process.env.ADMIN_CLIENT_EMAIL ? [process.env.ADMIN_CLIENT_EMAIL] : [],
		body: "<h2>Form submitted from {{$trigger.payload.form_name}}</h2>\n<p><strong>From:</strong> {{$trigger.payload.sender_email}}</p>\n<p>&nbsp;</p>\n<p>{{$trigger.payload.message}}</p>",
		type: "wysiwyg",
		subject: "New Form Submission from {{$trigger.payload.form_name}} form",
	};
	await knex("directus_operations").insert({
		id: operationId,
		name: "Send email",
		key: OPERATION_KEY,
		type: "mail",
		position_x: 19,
		position_y: 1,
		options: JSON.stringify(directusOperationsOptions),
		resolve: null,
		reject: null,
		flow: flowId,
	});

	// add module bar button to trigger the flow
	const flowButton = `${process.env.PUBLIC_URL}/flows/trigger/${flowId}`;
	const directusSettings = await knex("directus_sett