Your site's data, in the Database app

Everything a hosted site collects or sells already lives somewhere - a list of products, a stream of leads, a queue of reviews waiting on you. This page is about seeing and editing all of it from one place: the Database app, right alongside every table you've built yourself.

What shows up

Open the Database app and look under your site's name. Depending on what that site does, you'll see some or all of:

• Products - name, price, currency, stock, category, kind and image. Change a price or a stock count here and it updates on the site.
• Orders - order number, status, total, customer, email, and when it was placed and fulfilled. You can move an order to fulfilled, canceled or refunded right from the grid.
• Leads - every form submission, with a stage column that fills in automatically once a lead has moved into your CRM pipeline.
• Bookings - name, email, the slot booked, and status. Cancel a booking from here.
• Subscribers - your newsletter list, with confirmation status.
• Reviews - rating, reviewer, the review text, and status. Approving a review here publishes it on your site immediately.
• Content - your blog (or other content collection) posts, editable as title, date, draft status and body - this one needs your Drive connected, since that's where content files live.
• Inbox - your site's email threads, with a status column so you can close a thread from the grid.
• CRM - once you've set up a company, its sales pipeline: stage and next action per lead.

New activity on your site - a form submission, an approved review, a paid order - shows up in the grid within a few seconds, without needing a refresh.

Editing is real, not a copy

A cell you edit in the Database app writes straight back to the site's own data - the exact same place the site's own pages and your Settings panels read from. There's no separate "sync" step and no risk of the two getting out of sync. Some columns are read-only (an order's total, say) because the underlying record doesn't allow changing them directly; everything editable behaves like an ordinary table.

Putting a table on your site

Any table you own - one of the built-in ones above, or a table you built yourself in the Database app (a menu, a team roster, a price list, an events calendar) - can be bound to a section on a page. Open your site in the Site Editor's builder, add a Table section, and pick:

• which table to show,
• a layout - list, grid, cards, menu, price list, or schedule,
• optionally, which columns to include, a sort order, and a filter.

Publish, and that table's current rows render right into the page. The data is baked in at publish time (like the rest of a hosted site's pages), so publish again after editing the table to refresh what's shown.

Your on-site concierge chat can also answer questions from a table you've put on a page - a visitor asking "what's on the menu" or "when's the next class" gets an answer straight from that table's own rows.