馃攳
Vendor Management Software | Build your own vendor management app | App DNA - YouTube
Channel: App DNA
[0]
are you a shopkeeper a retailer or even
the owner of a very big online
[5]
marketplace then this video could be
ideal for you
[12]
hello guys welcome to our DNA where we
talk about all things apps and today
[17]
we're gonna take a look at the vendor
management application managing a lot of
[21]
vendors at the same time could prove to
be a very big hassle because different
[25]
vendors would be supplying with
different things brands varieties and
[29]
quantities so owners are often clueless
with who is providing what and they
[34]
often adhere to the list or the receipts
given by the vendors this happens
[39]
because there is too many of them and
it's very hard to manage
[43]
well worried not because those days are
long gone
[46]
with the help of Zoho creator we'll be
creating a comprehensive mentor
[49]
management system which will help in
managing the vendors which will help in
[53]
giving them new contracts having a
vendor database and much more
[57]
importantly we could create a rating
system for vendors which would help you
[62]
decide in the future whether you would
want to renew the contract of a certain
[66]
window this would make the system much
more foolproof and transparent so
[72]
without further ado let's get started
and make a good and comprehensive when a
[76]
management application
[80]
so guys it's time for us to create a
winter management application and as
[84]
usual we're at the create application
page of Zoho creator we'll be creating
[89]
the application from scratch and let's
name the application as when the
[97]
management
[99]
from that we are going to create
[103]
correct form which will be used as a
database which will collect information
[107]
about the products and we'll be using
the product name field in this
[112]
particular form as a lookup in other
forms aim the form as products
[120]
we'll be dragging and dropping a
single-line field for product name and a
[125]
multi-line field for description
[130]
it's time for us to create the next
forum which is the ad vendor forum
[138]
this form and report will be the database
which contains information about the
[144]
vendors here I'll be dragging and
dropping a single-line field for the
[150]
vendor name
I'll also be dragging and dropping basic
[153]
fields such as phone number and email
will be also dragging I'm dropping a
[157]
lookup field to lookup the product name
field from the products form this way we
[163]
can enter information about the products
as well in the ad vendor report we are
[168]
done making the two basic forms we
discussed before the two main features
[172]
of this application is that you'll be
able to hand out contracts to the
[176]
vendors and also you'll be able to rate
the vendors accordingly so that you can
[180]
decide whether to renew the contract or
not other than having so these are the
[185]
two features in the application other
than having a database for products and
[189]
vendors the next form that we are going
to make is add contract form let's create
[193]
the add contract form
we'll be dragging and dropping a lookup
[198]
field for the vendor name now it's time
for us to drag and drop the currency
[203]
field for and contract amount now we'll
be dragging and dropping a lookup field
[208]
for the products now it's time for us to
add the start date and the end date so
[215]
we'll be dragging and dropping two date
files so we'll be dragging and dropping
[218]
two date fields for that
[222]
it's time for us to drag and drop the
file upload field so that you can upload
[228]
the copy of a legal document or of a
contract irrespective of what format it
[233]
is whether it is JPEG PDF or word in the
field as contract file
[241]
so we are done with the ad contract form
now it's time for us to create the
[248]
backbone of this application are the
most important part of this application
[256]
a new form for that will be naming our
form as trade your vendors
[266]
now we need to drag and drop to lookup
fields for the vendor name and the
[270]
product name so let's do that
[274]
now it's time for us to drag a couple of
radio fields so that we can rate the
[280]
vendor based on average and excellent
that are the three categories that we
[284]
have so we'll be dragging and dropping
radio fields first one will be quality
[290]
delivery
we'll be doing the same for price
[295]
service and risk
[300]
so we'll be giving three choices for all
these radio fields three choices our
[306]
poor average and excellent will be also
dragging and dropping another field so
[314]
that we can calculate average rating
drag and drop a decimal field to
[320]
calculate the average rating so the
average rating will be our of ten let's
[325]
give it here as after educating us to
create our workflow which will
[330]
automatically calculate the average
rating so for that we'll be choosing the
[336]
ratio vendor form and we will name the
workflow as later your vendor workflow
[343]
we'll be doing this on user input and
let's select the risk field we could
[350]
select any of those radio fields so now
it's time for us to do the deluge coding
[356]
here I'll explain what each line of code
does so I've written the code here so
[361]
what we're doing here is that we are
assigning values to each choices in the
[367]
each and every radio field that we have
entered in that particular form so we
[371]
are giving it as if input or quality not
equals none that is each choice will be
[376]
assigned with a particular value Q is
equal to 3 here means that the choice
[381]
poor has got a value of 3 out of 10
average has a value of 7 out of 10 and
[387]
excellent has a value of 10 out of 10
and else we're giving it for each and
[393]
every radio field so here P is equal to
3 means that the choice poor in the
[399]
field rice has a value of 3 out of 10 we
have done it for quality delivery price
[406]
service and last but not the least the
risk field give assigned values to each
[411]
choice in each and every field now it's
time for us to calculate the average
[416]
rating so we are going to write the
final line of code here for calculating
[420]
the average rating so what we have done
here is that we've given task input or
[424]
average rating is equal to Q plus R plus
s plus P plus T Q is the quality art is
[430]
the risk S is service P is price and D
is degree we have added all this
[437]
together and it will come 250
the total value will be 50 so we are
[442]
dividing it by 5 so that we get the
average rating out of 10 so let's update
[448]
or save custom action here so we are
done creating our application now it's
[454]
time for us to test the application and
see whether it works so two of the main
[460]
features of our application was that we
be able to an out contracts to the
[464]
vendors and also we'll be able to rate
the vendors so let's do a contract
[472]
she will be adding the contract file
here so you can see all this information
[477]
in the contract report over here now
it's time for us to read the vendor so
[482]
let's select a vendor let's select a
product and we'll be giving readings
[487]
based on the three choices which are
poor average and excellent
[494]
so the average rating have come here as
six point six out of ten because we have
[499]
given average for quality poor for
delivery excellent for price poor for
[504]
service and excellent for risk out of
ten this particular vendor
[515]
we can also see this in the rate your
vendor report so that next time while
[520]
you decide to hand out a contract you
have an average rating over here and
[524]
you'll be able to see wait a second what
view all this information in the rate
[528]
your vendor report over here so the next
time while you decide to hand out a
[534]
contract to a particular vendor you'll
be able to see the average rating and
[538]
decide on whether or not to hand out a
contract making vendor management much
[543]
more easier if you own a business I hope
that this video will help in managing
[548]
your vendors much more easily you can
add more bells and whistles to the
[552]
application once you get the angles Ojo
creator and to know more about creator
[557]
and the applications that you can build
with it please take a look at our
[560]
channel and do subscribe as well thank
you until next time goodbye
Most Recent Videos:
You can go back to the homepage right here: Homepage