WEBVTT

00:00:00.000 --> 00:00:09.767
In this video we build a small real-estate portal with
List Manager: typed columns, filter drop-downs, a global
search, a detail view and exports.

00:00:10.017 --> 00:00:19.195
In List Manager, use Database Options, New table, to
create a table called l m properties with columns for
title, city, type, price and more.

00:00:19.395 --> 00:00:24.521
Click Add, name the list Properties, choose the l m
properties table, and save.

00:00:24.721 --> 00:00:33.493
Open Fields and Columns. Give each column a label and the
right type: Number for price and area, Date for the
listing date, Textarea for the description.

00:00:33.693 --> 00:00:42.279
On the Display tab, add a suffix: a euro sign for the
price, square metres for the area. Turn on Visible for the
columns shown in the table.

00:00:42.479 --> 00:00:47.791
Open Display. Choose the Table or Card layout, and set a
default order on Price.

00:00:47.991 --> 00:00:56.368
On the Detail Layout tab, turn on On row click and Detail
in modal, then design the record template with the photo,
the price and the description.

00:00:56.568 --> 00:01:06.640
Open the Filters tab and add items for City, Type and
Operation. Set the type to Select, and List Manager fills
each drop-down with the values found in that column.

00:01:06.840 --> 00:01:13.069
On each column's Advanced tab, turn on Include in search
so the global search box covers the title and the city.

00:01:13.269 --> 00:01:21.530
On the Export screen, set the P D F to landscape and add a
heading. Add the P D F and Excel buttons, plus their
filtered versions.

00:01:21.730 --> 00:01:28.412
Create a menu item of type List Manager, and on the
Options tab select the Properties list. Save and close.

00:01:28.612 --> 00:01:33.076
The portal is live: a searchable, sortable table with
export buttons.

00:01:33.276 --> 00:01:39.854
Visitors narrow the results with the city, type and
operation drop-downs, and a Clear button resets
everything.

00:01:40.054 --> 00:01:45.258
Every screen and option is covered in the written property
portal tutorial in the List Manager section.
