How to write software for internal project management, inventory, or HR in Bubbl

In the Data tab, create Data Types for each module. Inventory: Product (name, sku, category, quantity, reorder_level, unit_cost, supplier, location). HR: Employee (user, first_name, last_name, department, position, start_date, salary, manager, status — active/inactive), Leave_Request (employee, type — vacation/sick/personal, start_date, end_date, status — pending/approved/rejected, approved_by). Project Management: Project (name, description, owner, status, start_date, due_date), Task (project, title, assignee, priority, status — todo/in-progress/done, due_date). Create Option Sets for departments, leave types, task priorities, and product categories.

Create an 'inventory' page with a Repeating Group showing all Products. Add search by name/SKU and filter by category. Each row shows product name, SKU, quantity (color-coded: red if below reorder_level, yellow if within 20% of reorder level, green otherwise), unit cost, and location. Add an 'Add Product' button that opens a form popup. Add 'Adjust Stock' functionality: a +/- button on each row that opens a popup for quantity adjustment with a reason field. Create a Stock_Adjustment Data Type to log every change with timestamp, user, and reason for audit purposes.

Create an 'employees' page with a Repeating Group of Employees filtered by department dropdown. Each row shows name, department, position, start date, and status badge. Click a row to open the employee detail page showing full profile information, employment history, and leave balance. Build a 'request-leave' page where employees submit Leave_Requests. Create an approval workflow: the manager receives an email notification, opens the approval page, and clicks Approve or Reject. Approved leave automatically updates the employee's leave balance.

Create a 'projects' page listing all Projects in a Repeating Group with name, status, owner, and due date. Click a project to open its detail page showing a Kanban-style board. Create three columns (Groups in Row layout): To Do, In Progress, Done. Each column contains a Repeating Group of Tasks filtered by status matching the column name. Each task card shows the title, assignee avatar, priority badge, and due date. Add drag-and-drop between columns using a plugin, or use dropdown/button status changes. Add a 'New Task' button that creates a Task linked to the project.

Create a 'dashboard' page that serves as the home screen for internal users. Add summary cards at the top: Total Products (count), Low Stock Items (count where quantity < reorder_level), Pending Leave Requests (count), Overdue Tasks (count where due_date < today AND status is not done). Below the cards, add recent activity feeds: last 5 stock adjustments, last 5 leave requests, and last 5 task updates. Use Repeating Groups with 5-item limits and sorted by date descending. Add quick-action buttons for common tasks: Add Product, Submit Leave, Create Task.

Add a role field to User (Option Set: employee, manager, admin, hr). Create Privacy Rules for each Data Type: Products — visible to all logged-in users, editable by admin and managers. Employees — each employee can see their own record, managers can see their team, HR and admin can see all. Leave_Requests — employees see their own, managers see their team's, HR sees all. Tasks — visible to project members and admins. Add page-level access checks: on each page's Page is loaded event, check the user's role and redirect unauthorized users to the dashboard with an access denied message.