Transcripts
1. Intro: Hey, I'm till, I'm a filmmaker based in Germany
and the Philippines. During this video,
I'm going to show how we're building from scratch a social media base that allows us to have the
overview of every post, every client, and
everything we're doing in our social media world tier within air table and why
we all love air table. The possibilities are endless. We can really design this the way we want it to look like. We can tweak it. We can change to view
as we want to be, and change it the way
that it's so much a year for the client to find certain things if you
have all those data. Also nice to share those data to the clients so they can
comment on certain things. We have of course,
endless possibilities, how we can expand and
how to work on that. We can accomplish
something where we have a social media overview
for everything basically.
2. Template Overview: Let's start here with a
different kind of tables. We have. We have overview, we have our content view. We have comments view, assets view, style guide. View where we can
input our reports, campaign tracking, results, hashtags,
and possible clients. This is just the base
without real clients, without real projects,
but it will showcase the power of the how we can
use the space basically. So here in the overview, it's showing us basically
the overview of the social, let's say, of the
Instagram grid. So that let's say the client can see how it will
feel like if we showcase nine or even
an 18 long grid for, let's say this month, we can implement such things as, let's say the
current followers we have the current
Facebook followers, we have Twitter, but of course
we can change everything. How we want it to be. The client has the
ability to comments here. But if we want to be
in the single post, we can change the view here. This is the content
review view basically. So here we can see the
single items from Instagram. Basically, we have here the headline, sub-headline,
the hashtags. So the client could comment
here, they could approve. We could write down where this
post is going to be going. What channels, for example, to blog, email, Instagram. Let's check out our other views. Here in reports, we
can upload reports that the client sees exactly
what this performing. I will not showcase in the open. And you kind of
report because for the detailed report
we are using, we're using as our main
social media source in terms of communication, in terms of posting and
in terms of report, this showcase basically just surface of what's
going on currently so that the client have
basically just have one view. Without switching like apps. It's so much easier for the client to find
certain things. So let's say the client wants
the report from last month. It's super easy here. So in this case, for example, he just has
to look for the report. This is the report
you want and then he can download it
so he can open it, download it and so on and so on. And he can also
comment here inside. He has basically here a nice
overview what's going on? Again, this is just an
example based because I can't show any confidential
data of real clients. But this allows you to have
the grasp of what could be accomplished here
with an air table and why we all love Airtable. Then we have some ad results we can showcase again like what we want and you can
customize it the way you want. That's basically it for now.
3. Tables & Fields: Let's start from the beginning. What you see here is
so-called the air table base. Inside the air table base, we have different
kind of tables. So this here is a table. Here we can input
the information. And tables can be connected
with different tables. Here on this side, we see our view for
our empty base. And of course like an air table. If we start with something, you can always expand it. And it's better to start with something really simple and then make it more complicated. Give it more advanced feature
when we really need it. But start as simple as possible. This is really the way to go. Here. We start with our overview. We're going to rename
the table here and give it a name over view. For that. Let's create your directly the next table and that's the
content because we're gonna start with an
overview and content so that we really understand
what's going on here. I'm going to start
with an empty table. And by the way, there are so many nice air table templates out there so you don't have
to start from scratch. If you are new, I would highly recommend checking
out the templates. Why? Because it gives you or it allows a good
starting point. And so you can just expand it on however you want it to be. In the end. Here in our case, we start with the empty table. We'd give it a name
and call it content. Now we have two tables, okay, the one overview
and other content. As I said, this video
is not for beginners, so we're going to
cover here a lot of topics which might look
complicated in the beginning, but I tried to keep it
as simple as possible. Let's create one of the
most complicated things and that's formula, okay, So instead of giving
each row here a name, what we try to do is to
create a name automatically, instead of doing here the
naming manually, one-on-one. What we're trying to do
here is give it a name that is created by air table
using a formula for that. We're going to change
it to formula. And let's just save it for now
and leave everything here. It's saying like, okay, there is a mistake
because you don't have selected or done
anything for that. What we're going to do is
press just for now on notes. Let's do first the other
things in terms of the overview about what
month are we talking about? So let's select something. Here, let's change it. We can also create a new one and select single select item. Here we can give it a
name and call it month. Now we can give it the options. And what we can do here
is write each month. That's enough for now. Let's create the fields here, and let's move it to
the left side here. The next thing
would be something where we have the overview, as I said before, where we see the Instagram grid, like the nine or the 18th view where we see basically
not the single post, but how it going
to feel and look like when we see it on
the bigger picture. So for that we're going to
let the attachment there. So here we can upload
basically the grid view. The next thing we're gonna do
is we create a text field. And we're going to
write there for now. Later on I'm going to
show you how we can link a record to the client view. But for now let's create just a text field
and give it a name, and let's call it clines. So the next thing we're going
to do is like automated ID. So that means every time
we create a new row ID, like a single ID,
will be created. It's kinda like counting
from one to whatever number. That's the only thing
it's gonna do here. We can choose anything it
just like count basically. That's why I call it ID, because that will create for
each name for the formula, a specific the ID. As you see we have here 123. So all this is doing here is
creating the idea One 23. Let's find enough for now. In our case, we have
here the formula. As of now it's doing nothing. Why? Because all we
have done is say like Look what we're
writing here in notes. So when we're writing something, it's going to copy the
information here to there. That's what we have
done with a formula. But it would be nice if
we can tell the formula. Look who our client is. We give our first client
name, client XYZ. The other one, let's
call it edu client. The next one, maybe Skillshare. Now, for this view, let's say the one client, let's say we are
working in advance. And this client here
for this attachment, let's say we have here one
file we are uploading. So this is gonna be the file. This will be the grid
for the client XYZ. Let's say the other clients has this file and the other
client has this file. As we can see here, everyone has a different grid. Now we have to tell
when will be this grid basically be uploaded in which month without going
into the details yet. This is really just all
about the overview. Here. We're going to say like, Okay, this client is for January, this one also, but this one
that will be for February. Now we have here the IDs, we have the client name, and we have the month. For now. I would like the
name to be the month, then the client's name, and then give it an id name
and ID number basically. So that when I'm creating, let's say another
overview for this client. That client has a specific
ID for the month. So I would just create
it without the ID. The problem is this
formula wouldn't work because then the name
would be the same. So if I would just say
January client XYZ, without giving it a number, then it would be the same
name in terms of the formula. Okay, so now let's
change the formula. This is how we're gonna do it. So here we have to
customize the type. Take the notes out here. Now we are choosing month. Then we are typing and basically we're typing here, 00. This case, this one here. And clients. What I've done here
is basically I'm telling the name of the formula. Please look at our month view. For which month it is it. Then look at our ID. But before you look at our ID, put some zeros inside there. So it's not just
month one and client, but it will look like month
zeros, 01 and clients. So let's save it and let's
check how it looks like. Okay, now as you see generally 00 clients, it's okay. But we see it didn't
feel and look organized. So first of all, let's give it let's
make the naming same. I can't right here the month
fully and here just fab, Let's change it here also
to only three letters. Then it will look and feel
already more organized. Now we have January zeros 01, but I would like to
implement like a gap between 001 and
clients for that. And going again here. So after the id, going to put another
end in-between, we're going to write
something, save it. So now it's already
looking way better. Generally 001002 clients, edu and February
zeros 03, Skillshare. Now, this is something
really, really simple. Of course I can go here and
do something way more crazy. But for this case,
it's fine enough. Just, if you want to
learn more about formula. You should check
other video tutorials because I will not cover
it in this tutorial here.
4. Linking Records: Okay, so now let's
create a linked record. Because now we have this base, but now I would like to see what's going on here inside
in terms of the details. Because now I would
like to see what are the titles for this
specific post. What are the hashtags and what are we going to write
in terms of caption here? Okay, so let's go
here to content. Now, as I've mentioned before, we can connect those two basis. Basically, we can connect the overview base with
our content base. The way we are gonna
doing it is by creating a new view and give it a name
linked to another record. Here we're going to
link it to content. Content. When we have linked
it to content, it's going to ask us, Do you also need a lookup
field? Not for now. Later on when we're going to do a linked record to our
client, client base, we're going to use,
make use out of this, but not for now in
terms of content. Let's keep it for now. Now what I can do is I
can link everything. What's here inside with
what's here inside. You see, we have
here the overview. We have here, the contents for those who never heard about linking records with each other. It's one of the more
complex things, but it's also once
you understand it, one of the most helpful things. This is actually why air table
is so much more powerful than other tools out
there because you can easily link records. What I can do now here
is let's say I give it this content
name, just a test. Now, I can link the first
row here With overview. And only way I can
do it is either I can choose it here or I
go the other way around. Let's just take it
out here for now. And I can choose this one here. Now, why is this important? First of all, let's say we are working in terms
of single content. Instead of giving
all the informations that are not necessary here we the only thing we
have to do is like, okay, post 123456 are all belonging to
this overview here. So that we can get
all the informations. If we are expanding
the tables here, we have all the information
is here in our overview, but only those that are really important in
terms of overview.
5. Filters: Okay, Let's go back
here to content. Here inside of code set. We can delete this for now and build again the
table from scratch. This is how we're
going to do it. First of all, let's take
out here the fields. Let's start from scratch. This is the only field that we're going to
let because this is what we've built before. So let's start with something. And what we're also doing at the end is also a formula here in
terms of the naming. But for now let's
build status view. Here. Single select explains basically what that
showcase like. What is the current
status of this post? Why is this important? Because we need to know, Let's say we have
like 1020 clients. Every client has maybe, let's say for each
month 3030 posts. If we just count 20 times 30. And we are doing it like
for soul, so many posts, it's absolutely impossible to get to memorize each
and every status of each and every posts so that therefore we need a status view where we can later on create
a view that shows us, okay, As of now I
just need those WHO, which needs current attention. Let's say we have some of the posts will be
approved by a client. We can then hide them because they have been
approved already. So we don't have to work
on those posts anymore. So we can then move on
and give give it to the Social Media Manager
who is handling sensible or whatever social media
program we are using. For this status view here, Let's give it some names. And we're going to give it here, change it at options. The first one is planning. Second one in progress. Ready for view on hold and life. Let's change some colors. I would like to do
everything that's on, hold. On. Red would like to give everything that's
live or out-there, green, make it green
and everything else here in a more bluish tone. Now, let's say we have
here our post one. We have here our
status that says like, okay, this is
currently in progress. And the post one is belonging
to client or to Overview. Number one. Now what we need or
what we are going to be doing next is of course, the picture of the post itself. Now we are adding a field, Attachment field and creating one for our single post item. Now as before, before we
have here the overview now I want each individual single
post item here inside. Let's upload something. And let's upload year more. Let's just assume they would be. All they have all the
same status and they have all the same overview since
they are all coming from the same client and it's
the same month and it's the same nine or 18th grid. Now we can of course upload
more than one picture. So let's say you are
doing a carousel and you need more than one picture,
this is the way to go. So the next thing we're
gonna do is another status. It's basically like
a protection layer on our end that says like, is it approved by the client? Yes or no? If it's approved by the client, then we can basically
take it out of this view. Let's do here another single
select item and give it a name by clients. And let's make it simple. Yes and no. Let's move it here to the left. And now I'm going to show you
how we can change this view here and why filters and
groups are important. But let's do a simple filter. We can add a condition and give it a until what kind of
condition we want here. So in our case,
approved by client. For that we have here greater the filter
where we are saying approved by client is not yes. That means everything here inside those posts we still have to deal with because there are not yet
approved by the client. In this case, we
name grid here also to everything in progress means basically like let's
say we are posting here and planning already like
in advance for March, April, and so on and so on. Instead of being in progress, we can call it planning, but it will not
change anything here. Later on when we are creating
an interface, basically, we can tell the
interface that is showcasing to the client only those things that
are ready for review. But as you see here, inside of our view,
doesn't change anything. Why? Because we have
only applied one filter. And that is saying, like, if a client has approved that, then take it away
from this view here. What we can do here is like
another grid and let's call it all the posts. So create a new view. Now, this is the
view where we see only the posts that are not
yet approved by the client. And what we can do here is, let's try it out
and let's assume that this posterior is already
approved by the client. So give it a yes. We see it's here, post one, but here, it's not here anymore. So now we just have
to deal with post 23. Why did we apply? Hear a no? Because we can just say like, every time the client
has not yet approved, but has seen it already. Basically means this is
especially urgent and they need or we need to
change certain things because there must be a reason why they haven't
proved that yet. Maybe they didn't like
the text or the image. But if we are putting hit it and know it stays here in the base. But it also indicate by this color that there is
something that's going on. So either we need something, then we can change the
status into on-hold. Or if it's just a quick
just a quick change, then of course we can put it on ready for review
and tell the client. Okay. Could you please
check it again? And should he approve it, then? We can then move it and
tear and all the posts. Of course, we can change
then that this is now live, and this is now live. Should it be live? Of course, in our case, let's move back all the things. So take away the approved minus. So it should show here again and put everything
into in progress. For now.
6. Lookup & Advanced Linking: Let's just say you want
to give it hashtags. Now we could do it the
way most people are doing it and giving it
like doing it this way. Creating a single line text
and give it the name hashtag. And now we can write down
here all the hashtags. Let's just say we copy
like a hashtag three, and now we can open it and now we can do minor
changes here. So I can maybe take this out and instead do
other hashtags. And of course, we
can also copy it. The problem is like in
terms of flexibility, it's not really flexible. Again, we can have our
templates here and there, but more and more
efficient and easy ways actually to build a system that basically
just let you choose the right hashtags for the right clients in
terms of linking records. So let's create here
a new empty table, and let's call it tags. Now. Let's just write
some hashtags down. So let's say the first
hashtag is group food. The next one is also group food. The next one we call it, let's say group desert. Desert. So now we're going to change this one here into TextField also costs we don't need a long
text field here. And this one here actually
is the hashtags itself. Now we can change it
to single line here. And we can take out
this this instead. What we're going to do now
is we delete this one. Now what we can do is we
create a link record. Two hashtags, give it a name. Let's call it hashtag group. No need for a lookup field. Now, let's move it
here to the left. Let's create manually
a lookup fields, or we could have done it before, but let's do it manually. Now, lookup field inside the
view of the hashtag group. And now we have to tell
where should it look like? What information do we
want to display here? In our case, the hashtag. Let's create a field here, and let's move it
here to the left. Now, let's imagine we're
writing some headlines. So in our case here, headline number one,
headline number two, headline number three, and
hop headline number 123. Now, giving this post hashtags is really easy because we can
build now here templates. As of now we don't
have any hashtags, so we have to fill out. Like imagine this
is template one, template to template
three and we can endlessly expand this one here. Let's just copies some hashtags. You can use any hashtag tool out there what you would like. And let's just copy
this hashtag three. And let's place this one here for our next template
and for our desert. The third here, or
next hashtag tree. Okay, So as you can see here, we have those hashtags
inside of group food. And there are different than our group food number
two, as you see here. Now what we can do is
we can tell this here, give it those hashtag
inside of this template. So let's say we would like
to have a mixed between group and the group, food. And the third, and now we can display all the
hashtags we have created. And why this is really
so much better. Because we can then
mix it so much easier. Instead of starting
with group food, we can then start
with group desert. Then do let us say food too. Now here foo2 and food one, you see every hashtag has
basically the same hashtags because like we just have built three different
templates here. But again, like we can
be multiple templates. Like we can mix and do specific hashtags
like how we want it to be, like really targeted hashtags, but then also
individual hashtags. So we can do, let's
say hashtag of the week and then
hashtag off the month. It's like a hashtags we want
to implement all the time. And hashtags, hashtags
we only want to implement like maybe
for this specific post. We can do it all by using
and connecting here the hashtag group with a look-up table and
then we can display it. And I'm going to show you
how it can be looking like. This is the base we
want to build ups here. This is the base
we want to build. And here inside of Interface, when we are going
to content review, this is how it look like. The client sees like, Okay, we have here the headline, sub-headline and the hashtags. Now the client could
comment here as well. For that, we don't need to
build another view here.
7. Other Essential Tabs: Okay, so now let's fast
forward certain things. So just to show you what we
have here in our showcase. We have the hashtags, we have the image, we
have the image URL, we have a specific view
just for comments I can showcase later on
why we have this view, because we are
using another tool on how to display it for clients and not
the interface tool here inside of air table. But we are going
to using software. It's basically the
front end we could use to display it to our client. We're going to have
here the release date and then here all our channels. So when you are going as before, you can select instead
of single select, you have the choice here
to do a multiple select. This allows us basically to add more than one option here. So in our case, may be this post is going
into more direction. Then just Instagram
and tomorrow channels. Then we have, of course, the overview which
we have put here, all onto the right. We have here campaign tracking
and a link to our assets. Now, I have more
than those fields, but I hide them. Of course we have here
again like the ID, the email of the
client database view. Then when was the
last time we have modified this
specific view here. But I've highlighted
in this view here. Let's go to the next items here. So as I said, we
could then build on those different views. And if you are running ads, of course, you can then
also create an ad view. And this is just
something I've took out of a template
from air table. They have created
this nice template, which is a great starting point. I would highly recommend it. You can check those
templates out if you need to know what template
and talking about, please let me know so I
can send you the template, but they have created here
already like formulas. You then have to change
according to your needs. Of course, like you can't just let this formula how it is. So it really depends
on how you need, but this is a great
starting point. If you're running
ads and then you can just expand it to your needs. As I said. Then we have year
or client pays. Again, this is just an example
that you really have here. The showcase on how
we really have here, The showcase on, on let's say if we need further information
in terms of the client, let's say you would like to save the password
for any accounts. I would not recommend
to do it here inside. There was another tool
I would recommend, but this is not the
topic of today. But anyway, you could basically
store everything here in terms of client information. So this is also really, really useful if you are using external tools
like software, which I will showcase
again in a bit.
8. Building Interface For Client Interaction: So now let's go and
move on to interface. Let's start here by
starting building, because this is really
something then you can share to the client and they can comment and work with you
together on certain things. Let's start by using
the given templates. Here. We have here
four different, three different templates,
like a starting point. In our case, let's start
with the record view, which we can use S our way
on how the clients could leave a feedback or even write on specific
records on their own. So let's just choose this
one here and tell this one. No, don't look here
at the overview, but please check content out. So let's move on to next. And SUSE. Like even without
doing anything, it already looks great. So let's just give
it a name content. Now here inside of content SUSE, we have, here are
three posts, 123. Now we can do the
adjustments here inside. The first thing, of course, the most important
thing is like, if we want to build this because we want to
give it to the client, then they need to, they need a way on
how to comment. So the first thing is we are going here into
all the elements and looking basically
for record comment, just drag and drop it here. Now declined could
start commenting here. Here in terms of the pictures, what we want to have. Of course, it's like
a better view. Here. We can then choose
like this size. In our case, since
it's Instagram, Let's do it smaller. The good thing is really, we then have also the
ability to see like here, for example, we have two items. Let's just check how
it would look like. This is the view how the
client would see it basically. So here we can then
run the current cell. They can see it also
in the big picture. Now let's apply
here more things. So go here and then let's
put here the current status. Let's put it maybe
here, down here. And let's move here
also the status of the client. Make it smaller. Then what we need is also
the headline, of course. Take this one here out. Then we need, of course,
to sub-headline. We don't need the
URL of the image. Let's take that out, but let's make this
one here bigger, this one as well. Now of course we need
the hashtag here. We have to take care. So we don't want
this link record that we want to look up. View here. We have here all the hashtags. It's already looking quite nice. Now we have to change
it the way we want. So if you like your clients to write down immediately
to make them, to allow them to change
certain things on their own. You can give them the
permission and just go here and put this one here instead of just view only and
make it editable. Now they can edit the
headline and sub-headline, but we will not give
them any permission. And changing the status. We will only give
them the permission. Is it approved by the client? Yes or no. Okay, So now can change it. Now, let's say we, this here is the view
of all our content. We can then also apply
here filters that basically says like here inside, please only show that those posts that are not
yet approved by the client. Okay. Let's go here. First. View it. When we press yes, as you see, it's approved, but it hasn't changed
anything here. It's not disappearing. But what we want here is
that the client really sees only those posts they
have yet to approve. This is how we can
apply a filter. So in our case, let's just do two views. The first view is the
content where we have all the content so
that the client, if, for example, he
approved something, but once to take it back into the stage
of not approving it, he could basically recover or just change or whatever
it is in his mind. So that's why we let
this view here as it is. And what we're gonna do
is create a new view. What we can do here again, the same layout basically
until this one here. Have the same view here
also from content. But now we can apply here
directly the filter already. In our case, we apply it
from our view in progress. But of course you could tweak and do your
own filters here. So now you could apply it
here from in progress. So every time somebody's
approving something, it will not be showcased here. In our case, it's fine. We can then already applied here our same thing with hashtags. Headline. We don't need the URL. So far, so good. Let's then name it. Review so that the table, we have to now like
all content and then the view that the
client should review. Here, Let's make the
changes quick and fast. Let's apply here
to comment again. And let's put this down
here and this down here. Again, let's make
those editable. They could change it. This one, we leave it
as it is and this one, Let's make it editable. Now. This shouldn't
be fine enough. Now let's view it
and preview it. This is how the client
would see it in our case. Let's turn this one
into this one into yes. Let's change the view here. And as you see, they
have been gone. Of course, the problem is
like they have to refresh it. Basically. Once it's refreshed, then we will not see
it here anymore. Let's go here back
to the content. And here in the review view. Basically, what we have
here is no more data. But in our case here, in terms of content, we still want to
display them here. So let's change that one. I've put back here the conditions so that we can
see how we can change it. Here inside of review. We can change the view. So let's say here in content, Let's first rename it. Let's name it all content. As we see here. When we just press
here on this view, on the search bar, we can then apply the filter in our
case, we took it away. Then press on Done. Change the view here to review. And now we press here
and we see we have here the condition
we have gave it. So here we have the condition
approved is not yes. Now, when the client is
approving something, so let's press on yes. Here at the same here also ES. Now let's preview it. Let's move to the table. Like once it's out
there, it shouldn't be. Updated immediately
when we publish it and then they see it
basically immediately. Okay, so now let's
go to all content. As you see we have
here all content. And when we are moving
back to in review, you see that those we have
approved not visible anymore. So let's say the client
is happy with everything. Let's check it again. So here in our case, everything is here inside and
as we see, it's approved. Yes. Yes. Yes. And when the client has
approved everything, he's basically we can then say we can then move to
send a bill, for example. Someone can then start to
schedule those posts and copy all the information
and also the picture needed to be posted
on those channels. Okay, So this is
basically how we can then create the interface. Let's just show in a really, really simple way how we can
do it with the overview. Let's go first here to overview and exit
the preview view. We can give it, of course, a description and then
create here a new view. In this case, instead
of having this view, can then choose
other views here. We could, for example, use this one here. This one to create, for example, a board for the overview
in terms of report, we can make charts
for our campaigns, ads, but also like how was how our improvement went from
in terms of the growth. What posts has been viewed
the most and so on and so on. Like we can really build it
the way we wanted to do. Now, I'm going to leave
here the interface view. We can just check
out like how it looked here in our example
social media template. Here we have the overview and
this is how we've done it. Basically, it was
the same template. In our case again, we just give it this
example name here, generally very zeros 01
and then the client name. Just some really the
most important updates like how many
followers do we have? How is the picture
or all overall? And again, the client can
then change the view here to content review and can
go from post to post. And of course we can
change then here also the image size
and so on and so on.
9. Managing Multiple Clients: Okay, so the next thing is like because this
works if you have, like if you have like
one client for one base, let's say you have one client and you have
created your own base. And then it's going
to be working fine. The problem is like we
can't give any permissions. That being said, if you
have multiple clients, the client from could basically see the posts
of the other clients, which is absolutely
not what we want. Now you have two options. You can do multiple basis, so one base for each client. Because we can't again, like we can't give specific permissions
to specific clients. Once we invite them
into the base, they see basically everything. This is like the disadvantage of sharing this view
to multiple clients. But luckily, there are
some tools out there. There is this tool here
called software I owe. And what it allows us
basically to display all our data from air table into something
we can then adjust. Basically we could do and
build a client portal. So we can say we can give the client's permission
so that they only can see specific views
we want them to see. In our case. This is just an example here, again with the same base. So now we have created
overview page here. This is basically then what the client scene like
here are all my reports. If they want to go in detail, they can download it and
see the full report. Can just see here
the overview like how many followers do we
have currently on Instagram, Facebook, Twitter, YouTube,
you can expand it. It's again the same
view as we have here. Let's go here to overview. As you see, we have your
Instagram follower, Facebook, and so on. So we can really adjust it. We have here the overview, how does the grid overall look
like for what month it is? How did our campaigns went? And we can then, of course, build something, which I will not explain now
in this tutorial. But we can do another tutorial, tutorial to show you what is possible and how you could
build your own interface basically so that you can share it to
multiple clients and everyone can log in and
see exactly only that, what they should suppose to see. So let's go here to the other page and let's
call it content review. So now they have
here the overview. See here all the single posts. This is how it
basically looks like. Now, let's say you have
built this portal. Again, this is just an example
portal so that you have the overview because
we can't show any confidential data
of real clients. And that's why we can't show case here, our real interface. Let's say you have created
an example client. Let's go here to the base. And our client name here is this one here with
this email address. Now here inside of
our base, the cell. You could basically do it
in the most simple way. We have to say software I O, please allow only those
clients that have the same email
address that logged into this portal. View. The images and the content that should suppose to be
only reserved for them. For that, I have to give
all the views here, all the tables,
the email address. That's why we have
hidden here the field. And you see here, we have here basically our example client that
is attached to this post. And here we see that
this client can only see those posts
here at the top, but cannot see, for
example, this post here. Sorry, let's take this out here. Now, this can't be seen
by this client anymore. So the only thing the client
can see are those posterior. Let's take it out also here. Now. What we are saying basically is inside of our air table base, we have created a linked
record to overview. Because of that, we can pull
data from our overview. What we have pulled there is the e-mail address
because in our overview, the overview is connected
to the client database. It's kinda like this, is connected to this and
this is connected to that. You could of course
connect them directly, but this is how we have done it. Here we have the e-mail address. Again, we can hide them. You don't need it to showcase. It's really just for a, our interface in
software that they know. This is the email
address that is attached to this specific posts. Now let's imagine we are
logging in as Lucy example. Let's log in as Lucy example. Now this is basically
what Lucy example is seen here inside
of content review. Again, this is pretty ugly, but this is just to showcase
what we could do basically. And just showcase like how easy it is to build
a client interface here. Now, this client can
see the overview. And now it could see like
the posts, the single post. And if the client
would have to have more details now that
could click here on the post itself and see like, okay, this is the
title of the post. This is the texts, the subtexts, the hashtags, and here it will be, it will be released. Now let's say the
client is not happy, or maybe the client is
happy and he comments like, Hey, Skill Share. Now he could release
the comment. When we check here, it will go directly
to our comment view. And as we see here, it has created a
comment, Hey skillshare. This is connected to this post, so post number six
generally number one. So let's go here and we see it's the same general
January number one, post number six, client XYZ. Let's update the page. Unfortunately, you have to do that to see all the comments. But here you see all the comments that
are not yet solved. Here we have all the
comments and as we see, Hey, skillshare has been there, has applied there as well. Now we could expand the
view here so the client, you can like the
project overview. You could create an
review system here. You could upload
all your invoices which could be connected
to another database, but it would be too complicated
to showcase you here. But again, with this table or
with this whole base here, basically, you have
multiple options. You can use it only
to have the overview, but then you can use it if
you just have one client, you can use it in specific
for one client and share the interface which is new to air table to your clients so
they can do the adjustments. If you have multiple clients, I would suggest using software. I O. Here you could basically
create a view or a review system that is like
the way you want it to be. You can really customize it
the way you want it to be by using the data you have
here inside of air table.
10. Outro: I have tested so
many different apps, so many different
application and software. Air table is way
better because we can accomplish something
where we have a social media overview
for everything. In the beginning, airtight will seem a little complicated, but it will showcase the power of how we can use
the space basically. Okay, That's it. And thanks for
staying this so far.
Vonas PH, A network of creatives
