- [Eddie] Hello.
This is Eddie from AppSheet here to help you make your own
custom to do list app without code,
directly from your own cloud-based spreadsheet.
For this example, we'll use a simple Google sheet.
But you could just as easily use Excel on Dropbox,
Box, Office 365, or even data from SmartSheet,
SalesForce, or SQL.
Here you can see that I've pre-populated
a simple spreadsheet for a to do list.
Our column headers, which should always be located
in the first row, include:
category, task, deadline, status, and image.
Of course, depending on your use case,
you could just as easily build an app
that makes use of spreadsheet data
for inventory management, employees, customer orders,
rental properties, or just about anything
you might throw on a spreadsheet.
Now there are two ways to start building your app
on AppSheet:
You can start from the AppSheet add-on,
or you can head over to http://www.appsheet.com,
and start for free.
From there you can click New App.
In this case, we'll start from our own data.
And we'll call this To Do List.
We'll look for our file.
And now you can see that just like that,
AppSheet has prepopulated our app
from our existing spreadsheet data.
Now we'll walk through some of the core features
of the editor to give you some sense
of how to build your app.
Starting from the Data tab, we'll head over to Tables.
And in this case we'll go ahead and allow adds and deletes,
so that you can add and delete rows of data
directly from the app.
Now we'll jump over to Columns,
and you can see that AppSheet has done its best guess
to identify which kind of data type each of our columns is.
Most of the time it gets it right,
but you can also modify the type as needed
for each of your data tables.
Now in the Slice section, AppSheet gives us the ability
to create a subset of our own data.
In this case, we'll create a slice called To Do.
We'll say status does not equal to completed.
So we're saying that for any to do list item
that isn't completed,
so that would be in-progress or not completed,
those data points would show up in our slice of To Do.
So we'll save that, and we'll head over to the UX tab.
We'll go ahead and start with our to do list view.
You can see that AppSheet gives us the ability
to quickly change what kind of view type we want.
We can go with a table, or gallery.
But I actually prefer a deck for this view.
AppSheet gives us the ability to have five views
along the bottom, and also additional views in the menu.
Here let's go ahead and group by category.
You can see that we've grouped by category,
with kitchen, bathroom, garage.
And let's sort this by ascending,
so now it's in alphabetical order for each section.
Let's also go ahead and change the icon.
We'll make it a clipboard.
And we'll save it.
Now we'll check out our calendar view.
And you can see that our data points show up
along our calendar,
and we can access our to do list through there.
Let's go ahead and change our description to task.
Now we can see the task for each date.
Now let's go ahead and create another view.
We'll base this off of our to do slice.
We'll sort it by the status.
And here at the top, I'll just briefly show you
we have the ability to customize our branding.
In this case, let's go ahead and use a wrench
for our app logo.
Save that.
We can also create custom formatting rules
if we wanted, to bold or color different text
in different ways.
Now if we wanted to explore our app,
you can also see that we have the ability
to preview our app in mobile view.
We can turn it to horizontal.
We could also see that this looks like as a tablet,
or as a full-screen web app.
From here, let's jump over to our Behavior section,
and check out some of our actions, workflows, and reports.
So actions are basically shortcuts
that enable us to send out emails or texts,
or add rows to our tables, or perform other basic functions
quickly with a single tap.
We can also create workflow rules.
In this case, we'll create one called Completed Tasks.
We'll say that whenever there is a change
and our status is equal to Completed,
then let's go ahead and email our supervisor@appsheet.com.
Let's jump over to Reports.
And again, we can perform similar kinds of reports
that we can send out on a daily, weekly, monthly basis
or at whatever intervals make sense for you.
In our Security section, we can choose to enable
whether this is a private or a public app,
and who our authentication provider is.
In this case we'll keep it a secure app
with our Google provider.
Here in the User section, we have the ability to share app,
whether we're still in kind of the drafting mode of our app
or as a finished product.
In this case, let's go ahead and share our app
with tester@appsheet.com.
And when we're ready to go,
let's go ahead and hit Not Deployed,
and this will run our deployment check.
And we'll move our app to a deployed state.
Now I wanna give you a quick demo
of what this actually looks like on a real device.
So this is my personal iPhone.
We'll jump over to my email.
You can see that AppSheet has sent us an email already.
And we'll go ahead and install our app To Do List.
We'll open up in Safari on iOS or Chrome on Android.
It will take us through, and we will go ahead
and create a app shortcut.
We'll add it to our home screen.
Now you can see we've created an app icon shortcut.
So we'll jump in.
You can see we have our fully functional app
with each of our to do list items.
And here we have our to do view
separated by in progress and to do.
And we also have our calendar view with our deadlines.
And that is how you make a to do list app
without code.
So let us know what you think.
We'd love to hear from you in our comments section.
And when you're ready to get started,
go ahead and head over to http://www.AppSheet.com,
build your first app, or copy the sample data set
I've used in this example, which you can find
in the video description.
And with that, don't forget to subscribe.
And thank you so much for watching.