- [Eddie] Hello, this is Eddie from AppSheet
here to help you create your own suite
of custom applications for managing your classrooms,
school or university all without a single line of code.
Today, we're gonna start with two things.
We're gonna give you a quick background
on AppSheet and education,
and then we are going to have a demo
of a quick, simple student directory app.
So the first thing to know is that AppSheet does education.
We know what we're talking about.
AppSheet is in use by reading organizations like Harvard,
Dartmouth, University of Virginia, University of Michigan,
and public school districts around the country.
The Harvard Business Review has actually even featured
us in one of their posts talking about how AppSheet has
helped to transform what they do with Google Sheets,
and their directory systems.
Second thing to note is that
if you are a education provider,
do not miss out on our 50% discount
for educators and non profits.
We'd love to support what you're doing.
You'll find the link in the YouTube description section.
And the final thing to note is that AppSheet is a platform.
So rather than offering a single use app
or even multiple apps,
we have a platform to allow you to build
your own customizable apps without code to meet the needs
that you have on the ground every day.
So AppSheet is a platform that connects
with your existing cloud base data sources,
which is helpful because then your data is no longer siloed,
but rather you can maintain your single source of truth
but whether that's on Google Sheets, or Drop Box,
or SQL Server, or other common data sources.
AppSheet can also scale with you as you grow,
so whether you're just using a couple hundred rows of data,
or you're using a couple million rows of data,
AppSheet can handle that.
Another thing to note is that AppSheet is platform agnostic,
which means that we actually don't care
where your data's coming from.
We'll help you make the most of it.
So whether you're using something
like Google Sheets to build a really simple app,
which is what we'll be doing today,
or you're using a system like Sales Force or SQL,
we can also help you maximize those platforms,
which often times allow you to use even larger data sets.
So a common question we get is what kind of applications
do people actually build and use on AppSheet?
In the education section what we've often seen
is educators using us for things like assignments,
and activity scheduling and contact directories.
There are also schools and districts
which use us for managing grades and meal planing.
We've also heard of administrators
who use AppSheet to build their own flash card systems
to remember students' names.
And at the university level,
we've also seen a lot of unique niche use cases
for AppSheet in things like lab testing,
library management, and waste management coordination
just to name a few.
One analogy I like to use for AppSheet
is that it's a little like learning to play the piano.
Everyone starts with learning a couple chords and scales,
but once you've mastered the basics,
that allows you basically unlimited possibilities
to build anything from any common data source,
leveraging all of our functionality and feature sets.
From here, let's go ahead and get started.
I'm going to head over to Google sheet,
and I'm going to go ahead
and type in a set of column averages.
Our first row is very important,
because this is how we detect
the equivalent fields for our app.
I'm gonna go ahead and fast forward
to get the data in here.
Now you can see we have our high school classroom
with professional athletes from around the world.
Now to get started,
let's go ahead and head back to AppSheet,
and go to start for free.
If we're a first time user
it'll walk us through the short sign in process,
but for me we'll go ahead and jump here to new mobile App.
We'll start with our own data.
We'll call this data Superstar High School Directory.
And we're going to have this be a education App,
and we'll choose our data source,
called the student directory.
Now here you can see we've just created
our first App with AppSheet.
And AppSheet is directly pulling the data
and displaying it in a mobile-friendly format.
What we can see is that even our image,
which is drawing from these URLs
is now being expressed visually in our app.
If we click into any of our individuals,
you can see the same data is reflected
inside the app as well.
One thing to note too is that
the AppSheet App and your spreadsheet
are both totally connected.
So if you were to change Danica Patrick's GPA
from 3.4 to 3.52,
and we save that,
then that change will now be reflected in our Google Sheet.
Your AppSheet App is also off-line compatible,
so if we're in a location that does not have access to WiFi,
you can simply save your changes on your local device,
and when you reach WiFi, your App will automatically
connect and seek your data as appropriate.
So to get under the hood and understand what's going on,
let's head over to our data tab.
Here we can see we have our one student directory database.
And let's go ahead and make sure we allow Adds and Deletes.
And that just insures that we can add new data from our app
into our spreadsheet if we're trying to add a new record.
Let's also head over to columns,
and you can see that here we have
our various columns expressed.
Now, AppSheet has already identified what most of these are,
but in case we want to change some of these,
we can do so here.
And we can also create slices.
For instance, if we wanted a sub-set
of our data on how to represent the Dean's List.
We'll call it Dean's List
and we'll make use of this AppSheet expression.
An expression is a lot like a Google Sheet formula
or Excel formula,
and we'll simply say her GPA is greater than 3.499999,
and that person would be on the Dean's List.
So we'll save that, now let's head over to our UX section.
In our UX section, you can see that we have
our Student Directory tab that we're in right now.
And we're in a deck view,
we can change that to a table view if we wanted,
or a detail view.
But I actually prefer for this particular
data set a gallery view.
We can see that we have all of our 10 outstanding students
visually represented here.
We could also change the icon if we wanted to,
let's turn this into a person.
We can also change to our other view.
So here, we have our Student Directory One view,
and let's turn this into a form.
Now what this does is it allows us to enter in
a new student on the go.
We can also see above that we have our Dean's List view
which isn't reflected yet, but we can go ahead
and add a gallery view for Dean's List as well.
Our Dean's List only has six students
because only six of them made a 3.5 count.
But let's change our original one to New Student.
Now our form is reflected properly and if you scroll down
we see that we have a Dean's list.
The Dean's list right now is in the Menu View section
so we can see it here, but if we wanted
we can change that to be in our main tab.
So now we have three views reflected here,
and let's go ahead and make that a star.
Let's add an icon for our Dean's list as well.
So here you can see we've created three simple views.
If we wanted to, we could create up to five views
in our bottom row, and a number of additional views
in our menu section as well.
We could also customize some of the branding,
in the brand section.
We can create our own formatting rules
to make the text bigger or smaller,
or add different conditional formatting elements
for how the names are displayed.
And we also have our Behavior tab.
Behavior allows us to add various actions,
and workflow reports that affects how
we use the app on a regular basis.
For instance, we could create a party action.
So here, what we're doing is
we're going to set a column for tardies,
and we're going to set it to a new value
every time we use this action.
And we're gonna set the task Tardies+1.
So essentially what that's saying is that
anytime let's say that Cristiano Ronaldo is tardy for class,
right now he's at six tardies.
But we could mark him as tardy,
and he would be up to seven tardies.
We can also create workflows,
for instance we could have a workflow
for unexcused absences.
We'll call that unexcused absences.
And we'll say that whenever a change happens
and unexcused absences is greater than five.
Let's go ahead and e-mail the Parent E-mail.
And here we could either type in an e-mail,
or we could use our expression
and remember we have our columns
and one of our columns is Parent E-mail.
So we'll just even insert Parent E-mail here,
and we are good to go.
Finally we have reports.
If we wanted to, we could add a report
that would send the Dean's List,
or our tardies, or unexcused absences,
or any other key information we want at whatever interval
makes sense to these specified stakeholders.
Once we finish setting up our UX in behavior,
we can jump over to security.
In this case, we would want to require user sign-in
because we have confidential data.
We have phone numbers and e-mails,
and we don't want that getting out.
So we can select our domain authentication,
right now we're using Google.
For the vast majority of the apps that you'll be creating,
you would likely want to require a user sign-in as well.
And once we finish with security,
we can briefly explore Intelligence.
Intelligence allows us to make use of features
like Smart Assistant, which is a voice assistant
that enables you to find what you're looking for in the app,
just by your voice.
So once we're done finalizing our app,
we can head over to Not Deployed.
In this, we'll go ahead and automatically
run a deployment check.
And we can see that our app passes.
And so we're going to go ahead
and move our app to a deployed state.
Once our app is deployed,
we'll go ahead and check our e-mail.
And we can see that we've received our app,
Superstar High School Directory is ready.
If we're on the phone, we can go ahead and install
this as an app on our phone,
but for now we're just going to view it in our browser.
And you can see that we have our fully functional app
with our Dean's List, Slice, our Student Directory,
and our form to create new students
right here in our browser ready to go.
If we jump back over to the editor,
you can see that here we have our Share App sections.
We can share our app with our entire domain
or specific users.
And there you have it.
That is how you build an app on the AppSheet platform.
So whether you're a teacher, school staff,
district administrator, or you work at the university level,
know that there is a path for success for you.
You can get started for free,
just by following the link in this video,
or head over to AppSheet.com, and hit Start For Free.
Or head over to the Sample App section,
and go over to Education,
and you can start thinking through ideas
on what might make sense for you and your institution.
If you have any thoughts or questions,
we'd love to hear from you in the YouTube comments section,
or jump over to community.appsheet.com,
and with that thank you so much for watching.