Report · 5 September 2026

The job feed

Every job on Tour Dash was only visible to the people who could take it. Right for a marketplace, wrong for a shop window: with no contractors on the live database, nobody could see the handyman job Carey posted except Carey. tourdash.io/jobs now shows what agents are posting to anyone, at town level, and every job has its own page, built to be sent to the person who should take it.

Scope two public pages, one database function, one new scope on the board Verified 1440 and 390 wide, light and dark, on sample data Live tourdash.io/jobs, function created 5 September

The short version

A demand feed, not a third board. It shows the work exists and points at the account that can take it. Applying still happens in the app.

tourdash.io/jobs. Every open, public job, grouped by the day the work happens, with the town, the pay, when it was posted, the brokerage, and who takes it. Three figures over the list are counts of the rows under them. When there are no rows, the page says so.
tourdash.io/jobs/<id>. One job, for sending on. What, where roughly, when, for how much, who takes it, and two ways to be that person. A filled job says it has been filled rather than vanishing.
Nothing sensitive leaves the database. A security-definer function is the only path the anonymous role has to listings. It returns no address, no time of day, no MLS and no poster name, and it rounds coordinates to two decimals.
"All nearby" on the board. Inside the app, Find opportunities gains a For you / All nearby switch. All nearby shows every open job inside the radius; the ones you cannot take say who does and carry a Copy link button to the public page.

The pages

tourdash.io/jobs at 1440 wide on sample data: the headline The work agents are posting right now, a three-figure strip reading 15 jobs open, 8 towns, 15 posted this week, then jobs grouped under Tomorrow, Mon Sep 7 and so on, each row with a service mark, title, town, who takes it, when it was posted, the brokerage and the pay. A rail on the right reads Take this work with Create an account and Sign in. — The feed. Same chrome and market scene as the landing, held still. A filled disc is work another agent covers; a ring is a trade booked from the vendor directory, the mark the app already uses.

One job's page: Home Showings, the title Buyer showing, 4BR colonial, Short Hills, then a card with When, Pay, Posted and Who takes it, and buttons reading Sign in to apply, Create an account, and Send this job to someone. — A job's page. The time of day and the address are named as things that unlock after sign-in, so the page is honest about what it withholds.

The feed in the dark theme. — Dark, for free: every colour on the page is a token.

The feed on a 390-pixel phone: headline, figures, then the day groups in one column. — The feed at 390.

A job's page on a phone: the facts card, then three full-width buttons. — A job at 390. The share button uses the phone's own share sheet where there is one.

The in-app board with All nearby selected: twelve opportunities within five miles, a legend that now includes Ring = vendor work, and the usual cards. — The board's new scope. The segmented controls take a raised card rather than the accent, so Post a job stays the one amber element.

Live

The function was created on the live database the same afternoon, and the first job on the public board is the one that started this: the handyman job in Seaside Heights. The page shows its town, its date, "by quote", the brokerage and who takes it, and none of the address, the time or the poster's name. A link to a job id that does not exist says the job is not on the board any more rather than erroring.

The live page for the Seaside Heights handyman job: Handyman in Seaside heights NJ, Today, Saturday September 5, time of day shown after you apply, By quote, posted 2 hours ago by an agent at Signature realty, Handyman booked from the vendor directory, and the three buttons. — Its page. This is the link to send to a handyman.

Town and brokerage names arrive in whatever case the poster typed them ("Seaside heights", "Signature realty"). The feed shows them as entered rather than guessing at capitalisation, which would get names like McLean wrong.

Files

File	What it is
supabase/job-feed-migration.sql	job_feed(limit, job_id): the public read, security definer, granted to anon and authenticated.
src/hooks/useJobFeed.ts	The feed and one-job queries, with the demo store's twin.
src/lib/job-feed.ts	Who takes it, town and pay labels, posted-ago, grouping by day, the figures.
src/components/marketing/MarketingShell.tsx	The still version of the landing's chrome, shared by both pages.
src/pages/Jobs.tsx, src/pages/Job.tsx	The feed and a job's page.
src/components/NearbyWorkCard.tsx	The board's card for work this account cannot take.
src/pages/FindOpportunities.tsx	The For you / All nearby scope.
src/lib/hosts.ts	marketingHref(), the link from the app back out to the public page.
src/App.tsx, src/demo/DemoApp.tsx	The two routes, on either host, signed in or out, and under /demo.