Tutorials

Tutorial: publish a client portal

Build a small portal where clients sign in and see only their own orders. It uses the application builder, a user source and filtered data sources.

Step 1 – Data

In a database create:

Clients: Name (text), Email (email), Password (password field), Role (single select: Client).

Orders: Number (text), Client (link to Clients), Status (single select: Received, In progress, Shipped), Total (number), Date (date).

Add a client with an email and password, and a few orders linked to it.

Step 2 – Create the application

  1. + New → Application named Client portal.
  2. Application settings → Integrations → add a Local Basemind integration (it acts with your permissions, on the server).
  3. Application settings → Users → add a user source of type Local Basemind for the Clients table, with Email as email, Name as name, Password as password and Role as role.

Step 3 – Login page

  1. Add a page Login with path /login.
  2. Add a Login element that uses the user source.
  3. In its Events tab, after login, Open page → Orders.

Step 4 – Orders page

  1. Add a page Orders with path /.
  2. Page Visibility: Logged-in visitors; redirect others to /login.
  3. Data → List multiple rows from Orders, with a filter Client has → the formula User → Id. Each client only sees their own rows, because the filter runs on the server.
  4. Add a Heading with the formula Welcome, + User → Name.
  5. Add a Table element with the data source and the columns Number, Date, Status and Total.
  6. Add a Button Log out with the action Logout.

Step 5 – Order details

  1. Add a page Order with path /order/:id.
  2. Data → Get single row from Orders, row id = page parameter id, with the same client filter.
  3. Show the fields with Heading and Text elements.
  4. In the Orders table element, make the Number column a link to the Order page with id = current record id.

Step 6 – Theme and publish

  1. Settings → Theme: set your brand colors and font.
  2. Settings → Domains: add a subdomain such as portal.apps.example.com, or your own domain with a CNAME to the server.
  3. Click Publish.

Test it in a private window: sign in as the client and check that only their orders are shown.

Security notes

  • Always filter by the logged-in user in the data source (server side), never by hiding elements only.
  • Give each element and page the smallest visibility needed.
  • Remember to publish again after every change.