0:00
good day everyone Welcome to our quick
0:01
demo of feeds table Pro let's dive into
0:04
what feeds table Pro is all about feeds
0:07
table Pro is a stack that lets you take
0:09
data from feeds and display it in an
0:11
HTML table while it's essentially an
0:13
HTML table stack its true power comes
0:16
when you connect it to data sources via
0:19
Weaver space's feed stack feeds by
0:21
Weaver space allows you to connect to
0:23
multiple data sources like CSV RSS Json
0:27
or total CMS right out of the box with
0:30
additional database packs you can even
0:32
connect to myql Maria DB sqlite in SQL
0:37
Server
0:38
databases I created feeds table Pro to
0:40
provide a clean customizable interface
0:42
for displaying data you can customize
0:45
column names manage data and add simple
0:47
sorting and searching
0:49
capabilities let's start by setting up a
0:51
simple HTML table drag feeds table Pro
0:54
to your page you'll see it comes with a
0:57
header row cell here you can add headers
0:59
like name
1:03
name
1:07
date age and favorite
1:12
color now let's add some rows to the
1:15
table for now we're not going to connect
1:17
any feeds instead we'll manually add a
1:20
row and fill in some
1:28
data once we preview it you'll see we
1:31
have a simple table with a header and
1:33
one row of
1:35
data let's duplicate the row and change
1:38
some of the data to have a demo
1:45
table here you can see we've added some
1:47
table data manually this data isn't
1:50
connected to any feeds it's been entered
1:52
manually while this approach isn't ideal
1:55
for larger data sets it's one use case
1:57
for feeds table Pro feeds table Pro also
2:01
supports search and sort
2:03
functionality by enabling these features
2:05
you can sort by any data in the columns
2:07
let's add the feeds table Pro search
2:09
stack to the page right from the start
2:12
it's important to note that feeds table
2:14
Pro assigns a table ID to each table and
2:17
the search stack also has a
2:19
corresponding table ID you can have
2:21
multiple tables on a page but each one
2:24
must have a unique ID a search field
2:27
will only work with the table that
2:28
shares its ID
2:33
for example if the table ID is seven the
2:35
search stack should also have an ID of
2:39
seven now let's preview the
2:41
data now we have a search feature what's
2:44
great about it is that you can enter
2:46
multiple search queries and it searches
2:52
instantly for example if you search
2:55
Joshua the results appear immediately if
2:58
you then search for July it filters the
3:00
entries to show only those from July you
3:03
can even search John to narrow it down
3:07
further you can sort by
3:11
name and feeds table Pro also supports
3:14
sorting by date it automatically detects
3:17
date fields and arranges them in
3:18
calendar
3:21
order and of course you can arrange by
3:23
numbers as
3:25
well if you arrange the color column
3:27
it'll be back to alphabetical
3:31
now let's load some Dynamic data by
3:33
adding a feed
3:36
stack we will then add a row into the
3:38
feed stack Drop Zone
3:42
area I am just going to steal this CSV
3:45
data source with some demo data in it
3:47
ready to
3:49
use then let's remove these headers and
3:52
add the headers from the CSV header Row
3:54
in the demo data
4:01
next we need to add six
4:03
cells the feeds macros use double curly
4:07
braces around the column ID like
4:13
this we've set up the headers and Define
4:16
the macros if you've used feeds before
4:19
this will be familiar these macros will
4:21
connect the data from the database into
4:23
this
4:24
row now let's take a look at our data
4:27
perfect as you can see we now have a
4:30
table populated with data we can sort by
4:32
dates salary email country age and name
4:37
currently we can't sort the data by last
4:39
name only by first name however with the
4:42
power of feeds and feeds table Pro we
4:44
can make some changes to enable that
4:46
we'll explore that shortly the search
4:48
function is excellent for example if you
4:51
want to search by age you can type in 37
4:54
to see all the 37 year olds if you
4:56
search by country like UK it will
4:58
display relevant Eng R note that it also
5:01
searches within other data points like
5:03
2022 and it will filter that out from
5:06
the date column even after filtering
5:08
your data through a search you can still
5:10
sort the remaining rows by the data
5:12
that's
5:13
left to bring back the data simply clear
5:16
the search field or reload the page now
5:18
let's look at formatting the data we
5:20
want to format currency and split the
5:22
first and last names into separate
5:23
columns using the power of twig and
5:25
feeds we can customize how this data is
5:28
displayed in feeds table Pro first we'll
5:30
create a second header cell so that we
5:32
have separate columns for first name and
5:35
last name now I'm going to copy a
5:37
pre-made twig statement to speed up the
5:39
process this statement takes the data
5:41
from the name column and splits it into
5:43
separate first name and last name
5:45
columns next we'll update the macro in
5:47
the first row cell to first name then
5:50
duplicate this cell to create a last
5:52
name cell when we preview the table
5:54
you'll see that the first name and last
5:56
name have been split from the original
5:58
data in the the database it's still a
6:00
single field but with feeds and feeds
6:03
table Pro we've separated them into
6:05
individual columns now you can sort by
6:08
both last name and first name making
6:10
this a powerful way to display and
6:12
organize your data next let's format the
6:15
salary I'll use a pre-made macro from
6:17
another screen this macro adds a dollar
6:20
sign before the salary value and then
6:22
formats the number as currency using
6:24
twig let's see how that looks now
6:27
originally the table contained raw
6:28
numeric data but with twig we formatted
6:31
it directly within the table this shows
6:34
how we can manipulate data outside of
6:36
the database which is a major advantage
6:38
of using feeds the beauty of feeds table
6:41
Pro is that it can still sort and search
6:43
this formatted data for example you can
6:46
search for a specific amount like
6:48
$50,000 or filter data by years such as
6:51
2021 2022 2023 or 2024 now let's explore
6:57
some additional features available to
6:59
you
7:00
as we review the table we notice that
7:02
the first name and last name columns
7:04
have more space than needed to optimize
7:07
this we can adjust the column widths
7:09
here's how we do it we'll add a column
7:11
width setting since we're only adjusting
7:14
the first name and last name columns we
7:16
only need to modify the first two
7:17
columns we'll change the width from Auto
7:20
to a specific value let's start with 150
7:23
pixels after previewing we can fine-tune
7:26
it if 100 pixels is too small we'll try
7:29
100 110 pixels which is almost perfect
7:32
we'll continue adjusting until it looks
7:34
just right once the first name column is
7:37
set we'll do the same for the last name
7:39
column setting it to 115
7:43
pixels now that we've set the width for
7:45
the last name column let's consider
7:47
making the date column narrower as well
7:50
the date is in column 7 so we need to
7:52
adjust that specific column while
7:54
leaving the others set to Auto we'll
7:56
start by setting the width to 200 pixels
7:58
but that's too wide so we'll try 100
8:01
pixels that's a bit too small so let's
8:03
adjust it to 120 pixels perfect 120
8:07
looks just
8:08
right if we set the preview window to
8:11
manual adjustment and start collapsing
8:13
the table you'll notice that the data
8:15
begins to line break which disrupts our
8:18
rows we can prevent this by setting a
8:20
minimum width for the table for example
8:23
around 877 pixels is where the table
8:25
starts to break so we'll set the minimum
8:28
width to 87 70 pixels after applying
8:31
this setting in feeds table Pro the
8:33
table maintains its structure and
8:35
doesn't break even when the window is
8:37
resized what's really cool is that the
8:40
data becomes scrollable within the table
8:42
itself if you scroll down you'll see a
8:45
scroll bar but the search bar at the top
8:47
remains unaffected you're only scrolling
8:50
within the table this feature ensures
8:52
that your data and table layout look
8:54
good on smaller devices it also means
8:57
you can still use the search and filter
8:58
functions effectively on mobile devices
9:01
if you're a foundation 6 user you have
9:03
the ability to stylize your table using
9:05
table styles to do this we'll apply a
9:08
parent class to The Container which
9:10
we'll call styles from here we can use
9:13
the Swatch to adjust everything from the
9:15
table header and body settings to text
9:18
size and more for instance if you want
9:20
to make the text smaller you can easily
9:23
do
9:28
that you can also adjust the header text
9:31
size or change the text weight to bold
9:34
this flexibility allows you to create
9:35
smaller tables with smaller text if
9:37
needed Additionally you can fully
9:39
customize the table's background in
9:41
other Style Elements while my example
9:43
may be a bit extreme it demonstrates the
9:46
range of customization options available
9:49
overall feeds table Pro is a powerful
9:51
stack that gives you extensive control
9:53
over how you format and present your
9:55
data there are also alignment settings
9:58
for header rows body rows header cells
10:00
and row cells use these settings as
10:03
needed to create beautifully customized
10:05
tables for your Web projects with these
10:07
simple yet powerful features feeds table
10:10
Pro combined with the power of feeds
10:12
enables you to display sort and search
10:15
your database data quickly cleanly and
10:18
efficiently thank you for watching this
10:20
video I hope you'll consider picking up
10:22
feeds table Pro today to power your next
10:24
database table
10:30
n
10:32
[Music]