How to build a freelancer marketplace in Bubble

In the Data tab, create these Data Types: (1) UserProfile — extends User with fields: role (Option Set: Freelancer/Client), bio (text), hourly_rate (number), skills (list of Option Set: Skill), portfolio_images (list of images), rating_average (number), total_reviews (number). (2) Gig — fields: title (text), description (text), category (Option Set: Category), freelancer (User), price (number), delivery_days (number), is_active (yes/no). (3) Bid — fields: gig (Gig), client (User), message (text), budget (number), status (Option Set: BidStatus — Pending/Accepted/Rejected). (4) Project — fields: gig (Gig), client (User), freelancer (User), status (Option Set: ProjectStatus), total_amount (number). (5) Milestone — fields: project (Project), title (text), amount (number), status (Option Set: MilestoneStatus — Pending/InProgress/Completed/Paid). (6) Review — fields: project (Project), reviewer (User), reviewee (User), rating (number), comment (text).

Create a page called 'explore' with a search bar (Input element) and category filter (Dropdown with Option Set: Category as data source). Below, add a Repeating Group with data source: Do a Search for Gigs with constraints: is_active = yes, category = Dropdown's value (with Ignore empty constraints checked), title contains Search Input's value. Inside each cell, display the gig title, freelancer name, price, rating, and a thumbnail image. Link each cell to a 'gig-detail' page that receives the Gig as page data. Add pagination with a maximum of 12 items per page to keep load times fast.

Create a 'gig-detail' page with page type set to Gig. Display the gig title, description, price, delivery time, and freelancer info. Add a Send Proposal button for clients. Create a 'profile' page with page type set to User. Display the freelancer's bio, skills (as tags using a Repeating Group with the skills list), portfolio images (in an image gallery Repeating Group), reviews (Repeating Group of Reviews where reviewee = Current Page User), and average rating. Include a Contact button that creates a direct message thread.

On the gig-detail page, add a Proposal form (visible only when Current User's role is Client) with a message textarea and budget input. When the Submit Proposal button is clicked, create a new Bid with status = Pending. On the freelancer's dashboard, show incoming bids in a Repeating Group (Do a Search for Bids where gig's freelancer = Current User and status = Pending). Add Accept and Reject buttons in each cell. The Accept workflow should: (1) Change the Bid status to Accepted, (2) Create a new Project with status = Active, (3) Change all other Bids for this gig to Rejected. The Reject workflow simply changes the Bid status to Rejected.

When a project is created, the freelancer defines milestones from the project management page. Add a form with milestone title and amount fields. The workflow creates a Milestone with status = Pending. When a milestone is marked as Completed by the freelancer, the client sees a Release Payment button. This button triggers a Stripe charge using the Stripe plugin or API Connector — charging the milestone amount to the client's saved payment method and transferring funds to the freelancer's connected Stripe account. After successful payment, update the Milestone status to Paid. When all milestones are paid, update the Project status to Completed.

When a Project status changes to Completed, show a Leave Review prompt to both the client and freelancer. Create a review form with a star rating (1-5 using an Option Set or custom state) and a comment textarea. The Submit Review workflow creates a Review record and then updates the reviewee's rating_average field using the formula: (existing rating_average multiplied by total_reviews plus new rating) divided by (total_reviews plus 1). Also increment total_reviews by 1. Display reviews on the profile page sorted by newest first. Add privacy rules so only users involved in a completed project can leave reviews.