List Manager Tutorial
How to let each Joomla user manage their own records from the front end?
Many sites need a member area where every logged-in visitor can add, edit and delete their own entries — listings, bookings, a personal inventory — without ever seeing anybody else’s. With List Manager you build this with configuration only: one list, one User column and the Show only user records option. No code.
The idea
- A User column stores the Joomla user who owns each row.
- Show only user records makes the list display just the rows belonging to the logged-in user.
- The New, Edit and Delete buttons let that user manage them.
- A menu item with Access = Registered keeps the page away from guests.
1. Prepare the table
Use any database table that has a numeric column for the owner, for example my_listings with title, city, price and owner_id. You can create it with the component’s database options or with your own database tool (see creating a list from a table).
2. Create the list
In Components → List Manager click Add, name the list My listings, pick the Database Table and save. If you prefer, the Quick Setup wizard does the following steps for you.
3. Set the owner column to type User
Open Fields / Columns. For owner_id choose the column type User. On the front end this column is filled in automatically with the logged-in user when a record is created, and it shows that user’s name. In the back end an editor can choose any user. Details: the User column type.
On the same screen, mark the columns the user may change (title, city, price) as Visible and Editable. Leave owner_id non-editable so nobody can hand a record over to someone else.
4. Show only the user’s own records
Open the Display settings of the list and enable Show only user records. From now on every visitor sees only the rows whose User column matches their own account.
5. Add the buttons and the form
- In Data Layout, drag the New, Edit and Delete buttons from the Options list into the layout, next to the table and the search box.
- In Form Layout, design the add/edit form using
##column##placeholders, e.g.##title##,##city##,##price##.
See front-end display settings and the input form and Data Layout, Detail Layout and Card layout.
6. Publish it for registered users only
Go to Menus → [your menu] → Add New Menu Item, choose the type List Manager → List Manager, pick My listings in the List drop-down of the Options tab, and set Access to Registered. Joomla hides the link from guests and asks them to log in if they reach the URL. More in publishing a list.
7. Check the permissions
Open Options (or the Permissions tab of the list) and make sure the user group your members belong to is allowed to create, edit and delete rows on the front end. See history logs, saved searches and permissions.
Test it
- Log in as user A, press New and create a record.
- Log in as user B — user A’s record is not there. Create another one.
- Back as user A you see and can edit only your own record.
Want an extra safety net? Turn on Save history on the list’s Advanced screen to log who inserted, edited or deleted what, and add a fixed custom filter such as published = 1 if you want to moderate entries before they appear.
Common questions
- Can I also show everybody’s records publicly? Yes. Create a second, read-only list on the same table and publish it with Access = Public, as explained in two lists on one table.
- Can administrators see all records? Yes, in the component’s back-end data view (managing records in the back end).
- My users see an empty list. The existing rows need the owner’s Joomla user ID in the User column; only new rows created from the front end get it automatically.
