馃攳
Convert Your Google Sheets into Apps - YouTube
Channel: unknown
[0]
- [Instructor] Hello,
this Eddie from AppSheet
[1]
here to help you convert your Google Sheet
[3]
into a mobile or web app for business.
[6]
So to get started, let's
pop over to our example,
[8]
Google Sheets Spread Sheet for Inventory.
[11]
As you can see, we have a
number of column headers
[13]
including name, category,
image, available,
[15]
time checked, unit price, inventory value,
[18]
order quantity, and barcode.
[20]
It's important that these column
headers are in the top row.
[22]
But before we get started
[23]
building an inventory management app,
[25]
I just wanna show you real quick
[26]
that you could easily
use the same principles
[28]
to build a properties
app, an employees HR app,
[32]
a driver logistic app, or an orders app
[35]
using the exact same
Google Sheet to App system.
[37]
But from our Google Sheet,
there's two ways to get started.
[40]
We could use the AppSheet add-on,
[42]
or we could jump over to AppSheet.com
[44]
and go ahead and start for free.
[46]
And so from here we'll
start with a new mobile app,
[48]
start from our own data,
[49]
and we'll go to inventory management app.
[58]
And from here we'll find our data.
[63]
We'll take our example spreadsheet.
[68]
And here you can see how AppSheet
[69]
has taken our spreadsheet data,
[71]
imported that into a
functional mobile format.
[73]
We can see this on our emulator,
[74]
we can also see this
through my personal phone.
[77]
And so we can do that just
by going into our email,
[80]
and here we'll find AppSheet
has sent us an install email
[83]
and we'll go ahead and install
our inventory management app,
[85]
we'll open it in Safari on iOS.
[87]
You can also do so
through Chrome on Android.
[90]
Go ahead and install.
[93]
And here you can see our
fully functional mobile app.
[96]
We'll go ahead and create a shortcut.
[99]
Now we'll add this to our home screen
[103]
and we'll call this our
inventory management app.
[106]
So from within our app, you can see
[108]
that we have two preset views here.
[110]
We have one that I've already
created called New Skew,
[112]
new stock keeping in it,
[113]
and we could enter in a
new item if we wanted to
[117]
with a name, category, image,
[118]
how many are available, unit
price, all that information,
[121]
we could enter and save it.
[123]
And we also have our
standard inventory view
[125]
which allows us to see all
of our grocery inventory,
[129]
we can click in for
details and all of that.
[133]
And so from here let's
jump over to our editor
[134]
and we'll see how an app
like this is actually built.
[138]
You can see that AppSheet has
pulled in our inventory data
[140]
and we'll go ahead and make sure
[141]
that adds and deletes are enabled.
[143]
This allows us to add and
delete new rows from our app.
[146]
Now we'll jump over to columns,
[147]
you can see that AppSheet has
taken the columns in our data
[151]
and interpreted what type of data that is.
[153]
Most of the time AppSheet
gets this spot on,
[155]
but you can double check and see
[156]
if there's anything you'd like to change
[158]
or if you'd like to use any
number of other data types.
[162]
If you jump one tab over,
[163]
you can see that we also have slices.
[164]
Slices allow you to create
a subset of your data,
[166]
for instance, if we wanted to specify
[169]
a slice for out-of-stock inventory,
[171]
we could do that by creating
a row filter condition
[174]
that says that kind of very thing,
[175]
but that more AppSheet 2.0
so we'll skip that for now.
[179]
And here in the UX, you can see
[181]
that we have our standard inventory view
[184]
which is right here.
[186]
And this is a deck view right
now, but we can change that
[188]
if we want to into a table or
gallery, any number of things.
[194]
Basically AppSheet is just
taking that Google Sheet data
[197]
and interpreting that into visual form.
[200]
We could also change our
positioning if wanted this
[203]
on the left-most side,
we can flip it around.
[207]
You can see that inventory
is now on the left,
[208]
but let's go ahead and keep it in center
[211]
or what is essentially right right now.
[213]
We could also sort our data.
[214]
If we wanted to sort it
by alphabetical order,
[217]
we could do so, name ascending.
[219]
If we wanted to group it by category,
[221]
we could likewise do so.
[223]
Now you can see that we
have a grocery section,
[225]
a personal hygiene section,
and a pharmacy section.
[230]
One thing to note is
that we can also preview
[232]
other form factors and from our editor,
[234]
we could even see likewise
what it would look like
[236]
on our smart phone, as
I've already showed you
[238]
on my actual phone, or on a tablet,
[245]
or on a full screen web
app device like a laptop.
[254]
Heading back over to our editor,
[255]
let's jump over to the brand tab.
[257]
Here's where you can
change your color theme,
[259]
your logo, your launch image,
[261]
create special formatting rules,
[263]
for instance if we wanted to have
[266]
groceries and hygiene
be a different color,
[268]
we could easily do so through
this app editing tool.
[273]
Now let's jump over to
our behavior section.
[275]
Here we can add specific
actions, workflows, reports.
[279]
And let me just demonstrate
a simple action for you.
[282]
If we wanted to have an
action that would allow us
[284]
to add order quantity
basically whenever we get
[286]
a new shipment, we could
say, add order quantity.
[289]
And for the table inventory, do this,
[292]
there are any number
of things we could do,
[293]
but in this case we're gonna
go ahead and set the value
[295]
of some column in this row
[297]
and we'll set our available,
[300]
which is our available quantity,
[302]
to be available plus order quantity.
[309]
And what we're essentially
saying in this action is,
[312]
for our available, which is 100,
[315]
and our order quantity is 50,
whenever we hit this action,
[318]
let's go ahead and add
these two together, 150,
[320]
and that becomes our new available total.
[324]
Here you can see our app,
[325]
you can see that we have 100 avocados.
[327]
Let's add our order quantity to that.
[329]
Now we have 150.
[330]
We go ahead and manually sync that.
[332]
AppSheet will also automatically
sync every couple minutes,
[335]
but you can see now
that our available total
[338]
for avocados is 150.
[340]
Workflows allow us to send messages
[342]
whenever key changes occur.
[343]
In this case, let's go ahead
[345]
and create a low inventory warning.
[348]
And we can say, whenever,
for instance our inventory,
[352]
any change happens, and this is true,
[356]
let's say our available
becomes less than 25,
[363]
we can go ahead and let's
just say we will email
[366]
our [email protected].
[371]
Very similarly, in reports,
we could create simple reports
[374]
that say, at whatever time
interval for this table,
[378]
we could add some conditional
elements if we wanted.
[380]
Then go ahead and email
text or notify our manager.
[384]
From here let's jump over to security.
[386]
You can see that we've
required user signin
[388]
since this is a private app.
[389]
You could also change it
to off for a public app.
[392]
And you can also select your
authentication provider.
[394]
In this case we are on Google Sheets,
[396]
so we'll stick with Google.
[397]
And so, once we're ready to go,
[398]
we can go ahead and head
up to our deployment check
[401]
and if you just hit not deployed,
[403]
it'll run a deployment check.
[407]
And we'll go ahead and move
our app to deployed state.
[410]
If we wanted to share our app with users,
[412]
we can go ahead and do so.
[413]
We could share it with an entire domain
[414]
or we could share it by specific email,
[416]
[420]
and just like that we
could send off an invite.
[423]
So as you can see, we have only
begun to scratch the surface
[426]
of what is possible on a
platform like AppSheet.
[429]
There are countless features
we haven't touched on
[431]
and there are also multiple data sources,
[433]
like Excel, Sequel,
SmartSheet, Salesforce and more
[436]
that you can also connect
into the AppSheet platform.
[439]
The end goal for our users is
to help you build powerful,
[441]
intelligent apps without code
[443]
directly from wherever you're data lives.
[445]
You can visit AppSheet.com to learn more
[447]
or you can explore some of
our sample apps for ideas.
[450]
So let us know what you think.
[451]
We'd love to hear from
you in our comments.
[453]
Don't forget to subscribe to our channel
[455]
and thank you so much for watching.
Most Recent Videos:
You can go back to the homepage right here: Homepage