The Best App for Businesses and Entrepreneurs

The Best App for Businesses and Entrepreneurs

– [Narrator] Hello, this is Eddie, here to share with you why
AppSheet is the best app or tool for business owners and entrepreneurs. So to give you a little background, AppSheet is a intelligent
no-code platform. You’re probably wondering what that is. So here we can see how AppSheet functions. So basically, we start with your data, you can use any number
of common data sources, and then we go ahead and
connect that with AppSheet and you can customize your app and then deploy it to your users. So AppSheet is essentially a platform just like WordPress, Squarespace or Wix, except instead of building websites, we’re building custom
business applications. And you might be wondering,
why would that matter to me. So I’m going to go ahead and
give you four quick reasons and then run me through a quick demo to give you an understanding
of why and how AppSheet works. So the first thing I’ll point out is that AppSheet is an agile platform. So if you were going to custom
build an app from scratch, that would probably take you months, and a substantial amount of
money to get that deployed. With AppSheet you can build an app in as little as a couple of hours, or if you really know what you’re doing, even a couple of minutes. Second thing I’ll point out is that AppSheet is a
very flexible platform. Our platform is in use by industries as wide ranging as automotive,
to medical, to technology, because the platform itself is
basically industry agnostic. So whether you’re trying to build an inventory management
system, time sheets, logistics, inspection apps, CRMs, you can do that all with AppSheet. AppSheet’s platform allows you to work across iOS, Android, web
apps, wherever you are, whether your desktop or on
the go with 99.9% uptime. Finally, as a business
owner or entrepreneur, one thing that really
matters is scalability. AppSheet has a free plan that allows you to build apps for up to
10 users free of cost, and from there, it’s a simple pricing of five to $10 per month per user. So AppSheet is in use
by individual hobbyists as well as fortune 500 companies, leading universities,
global nonprofits, and more. For organizations with more
than a handful of users, we also have enterprise plans, which allow for even more app creators and features for organizations at scale. So from here, let’s go
ahead and get started with a simple demo to show
you just how AppSheet works. To do so, let’s head
over to Google Sheets. This will pull up our drive. Let’s open a new sheet, And let’s go ahead and call
this Inventory Management. Now I’m gonna go ahead
and label the first row. Now what AppSheet does, it
takes your first row of data, and it uses this in the logic of the app to understand which fields are important. And from here, we can
also add in our data. I’m gonna go ahead and copy and paste this to make a little quicker. You can see that we have some common items from a grocery store, we have
direct URL links to images, we have the available quantity, the last time we checked
the inventory quantity, we have the unit price, we have the inventory value, we have the order quantity,
and we have the barcode. And the inventory value is simply the unit price multiplied by
what is currently available. So once we have our data in place, we can jump over to AppSheet. And let’s go ahead. If it’s your first time here, you can go ahead and start for free. It’ll take you through a
couple prompts to login. For me I’m already logged in. And I’m going to go ahead and make a new mobile app starting
with my own data. And we’re gonna call
this Grocery Inventory. And we will select our data from Google. Let’s go ahead and search
for Inventory Management. We found our spreadsheet. And there you have it,
AppSheet has basically taken our very simple spreadsheet with six rows and turned that into a functional app with a couple of items. We can dive into the
app, we can play around, we can edit the values. One thing to note is that
whatever we edit inside here is reflected in the spreadsheet. For instance, if we change
the unit price of avocado from $1 to $1.50, and we
save it, and we sync this, then we should see that reflected right here in the spreadsheet as well. And likewise, any change
reflected in the spreadsheet is added into the AppSheet app. The data can also sync offline so that if you’re in a place where you don’t have internet access, you can simply sync at a
place where you do have access or the app will automatically sync itself as well at periodic intervals. So to give you just a taste of what you can do to
build out an AppSheet app, we are going to run through
a couple of quick sections. And keep in mind this is
a really basic overview. But, let’s get started. Here we are in the Data tab, and here we have our Inventory
Management spreadsheet, we can choose to allow adds and deletes, which is to say that you can now add different stock keeping
units or delete them, we could also change
our column definitions, AppSheet automatically
detects what each of these are but it doesn’t always get it right so if it doesn’t, we can go
ahead and fix them in here. We also have slices, so we
can go ahead and make a slice. And a slice is a subset
of a larger data set. So we’re gonna call this Out of stock. And we’re going to say that whenever the column Available is equal to zero, then it is going to fall under
the category of Out of stock. Now we can also head over to our UX tab. In our UX tab, we can see that
we have these various views, we can choose to sort
them in different ways, we could change this from
a deck view to a table view if we wanted to see all the data at once, but I actually prefer the deck
view cause we get the images. If you’re using other data types, a map or a chart, or even a
calendar might be helpful, but for now a deck view is gonna be what’s most helpful for us. We could also sort our
data and group our data. And let’s go ahead and
group our data by category. Now we can see that we have groceries, personal hygiene and pharmacy
separated by category. Let’s also go ahead and we can change our second view right here,
and let’s make it a form view. Now what this does, it
gives us the capacity to add any new stock keeping
unit however we would want. And let’s go ahead and rename
our form view, New SKU, for stock keeping unit. We could also go ahead and
add a simple image for this. How about a soccer ball? Now you see we have a
simple app with two views. We could have up to five
views along the bottom, and we could also create a set of views to put in the menu section. So for now, we’ll keep two views since this is a really simple app but bear in mind, if
you’re using a data source with a lot more data, or
using multiple data sources, or you’re trying to make use of various complex
features of functionality, you will definitely want
to use more than two views. We can also add our own custom branding in the brand section, we
could create formatting rules. For instance, whenever
availability is at zero, we might highlight that in
red to make us extra aware. In the behavior section, we
could also add a new action, and will say Add order quantity. And we could say for what is available, let us have ordered
quantity plus available. The value of column Order Quantity plus the volume of column Available. And we’ll go ahead and save that. And what this is essentially saying is that for avocados
which have 70 available, whenever we hit that
action Order quantity, it will add 50 to it. So if we are in the app,
and we’re on the go, we can go ahead and
hit, Add order quantity, and that will be reflected to 120. 120. We could also create simple workflows, for instance, if we want a workflow for a low inventory warning, we could do so and we could say, when there is any change
and the order quantity is less than 25, then let’s go ahead and email [email protected] We could also create simple reports. Let’s have this be a weekly report. And we could say that on any weekly basis, on Monday at noon, let’s go ahead, for this table, we will send an email to [email protected] From here, let’s take a
look at our Security tab. We can see that we have a
required sign in through Google. We could also change
this to be a public app or get signed in through other
authentication providers. We also have an Intelligence tab, where we can have a smarter system which allows us to use
voice commands on the go. And so once we’re done
customizing our app, we can head over to deployment. Going to not deployed, and this will automatically
run our deployment check and says we’re good to go, despite a few warnings about
not having a description. And we will go ahead and move
our app to a deployed state. And once our app is now deployed, we can head over to our email and we will see that here is
our Grocery Inventory app. If this is on a phone, we
could go ahead and install it and it would show up as
a app icon, or tablet, but for now, let’s take a
look at the browser view. You can see that we have a functioning app in our desktop browser. And if we wanted to share this app, we’d go ahead and go to share app, and we could find all our coworkers, or we could simply use
an entire app domain. So there you have it,
we’ve covered four reasons why AppSheet is the best app or tool for business owners and entrepreneurs. It’s agile, flexible, stable and scalable. We’ve also walked through a simple demo that just scratches the
potential of AppSheet. From here, you can go ahead and get started over at, and you can start from your own data or you can jump over to
our Sample Apps section and copy one of our sample apps as an example to get started. If you have any questions or thoughts, we’d love to hear from you
in the comments section in this video or over at Also, remember to subscribe to the channel to receive the latest
videos from AppSheet. And thank you so much for watching.

You May Also Like

About the Author: Oren Garnes

1 Comment

Leave a Reply

Your email address will not be published. Required fields are marked *