Library Management App | App development without any code

Library Management App | App development without any code


hello everybody this is Parveen and I
welcome you to App DNA anywhere we are obsessed about apps today I’ll be
talking to you about one of my favorite apps the library management app and that
is because I love libraries and books but what I used to hate about my college
library was that every time I would go to borrow a book my librarian would
stamp a seal at the backside which would tell me about the return date and
invariably I would always forget the return date and end up paying fine now I
wish that my librarian had some way to build a library app that would help him
to notify the students about the return date of the book so today I’d be helping
you through a library app with our low-code platform Zoho creator. Zoho creator helps
you build apps with a drag-and-drop interface where you’re drag elements and
drop them and build your own app even the simplest of library apps will allow
you to catalog your books in a database where the students can raise a borrow
request and the librarian in turn can approve this requests knowing this
workflow our basic library app today will have five essential features the
first feature is that we will catalog our books in a book database and also
have a student information form well we will know all our members the second
feature is that we will share the app with the students so that they can
browse through a catalog of books the third feature is that the students can
raise a borrow request for any book they want the fourth feature is that the
librarian will receive this request and he can either approve or reject the
request the fifth feature is that we will send notifications on the due date
to all the members so that they don’t miss out on the submission return date
now did we know all the five features we’ll go to creator dot Zoho dot come and
start building our app the first feature is that we have to capture the
information about our resources and members for that we’ll be building two
forms on creator through which we will be allowed to enter the book information
and the other form will hold our student information we welcome to creator
dot Zoho dot com we will be building our library app today your two buttons here
one is to create a new application or if you were already using a
spreadsheet to manage your books and library then you can simply import those
files with this button and create an app I’ll go for new application and this
takes me to the app gallery where we have more than 40 pre-made applications
by our developers these apps are ready to be installed right away and you can
use them after I’m done with the tutorial I’ll download this app and I
will show you how to do it we have our library management right here but let’s
go back to our I’m gonna create it from scratch and I will name it as library
app 2018 now this takes me to the edit mode where
I can create a new form by clicking here and I want to create my form from blank
I want to create a form for my student information and my books information so
let’s create the first form and name it as books now this is the drag-and-drop interface
that I was talking to you about we have our data fields here which we will drag
and drop here to create our form the information about books that I want is I
want the ISBN number of the books so I’ll drag and drop this number fields
here and I’ll rename it as ISBN next I want to know the name of the book
so I’ll use the single line field here and name it as book name
next I want to know the author’s well used a single line field again and rename
it as author now we want to know the available number of resources that we
have for this particular title so I’ll use the number field and I will name it
as available quantity and hit done so our first form is ready
and we can go to the live mode of this app here we can see the app running
through access this application here the difference between the edit mode and the
live mode is that in edit mode we create the app in the live mode we use the app
so this is our books form so let’s just enter a book and let’s say the book is
Alice in Wonderland available quantities and hit submit
every time you submit a form and creator it gets recorded in the report which
gets created automatically so in the books report we have our first resource
alice in wonderland’ now let’s go back to edit this application to create our
second form which was the member information so created by adding new
form from blank and we’ll name it a student member
so for the student member I want to identify them uniquely with a member ID
so I will use the number field and I’ll rename it as member ID next I want to
know your name their email and then we are done with our member form now we go
back to access this application and we can access our member form here so
let’s just put a new member let’s say the member ID is 1 name is me
Parveen Chaudhury and my email is Parveen dot C
and hit submit now you can see that in the student member put I am a member
here so we are done with the first feature which was to have student
database and the resource database now that we have our forms we are going to
share the app with our members and that is the second feature of the app to
share the app with the student members we go back to edit this application and
we use the green button here that says share and it says share application with
since the student is a user of this library app I’m gonna use user and then
I’m going to create a custom permission now enter name for this permission I’ll
say it’s student member and set permission for now I want the students
to have access to the books so I will choose the view books report here
because I don’t want them to access the books form per se because I don’t want
them to create new books or resources I just want them to browse through the
books catalog so I’m giving them view option of the books report and then
that’s it because I don’t want them to access the student member form then hit
next and then you can add user let’s say my friend Akshay is a user of this app
and he will get a notification through mail here you can access the library app now
and hit share sharing this dance so we will go to access mail and see if he got
any mail so here he got the mail and says I
invited him to access the library app 2018 here you can access the library app
now and he will go to the application and right here he can browse the book
catalogs since I have only Alice in Wonderland he can see that now what
remains to be done with this app is that he can’t borrow this book and that would
be taken care of in the third feature we have built our forms and we have shared
the app to our members now the third feature entails that we create a
workflow through which our students can click on a borrow button and raise a borrow
request for this we will create a workflow in creator we have to first
create a form through which the students can request to borrow a book I’m gonna
name that as borrow form and here I’m gonna use a special data
field called lookup which is used to relate two forms but lookup does is it
relates to form so that we can fetch the records residing in under the form for
the use in this current form so I’m gonna use student member form to
know the member ID so that we know which student wants to request for the form
and then I’m gonna choose your what else I want to know about them I want to know
their member ID and their first name next I’m gonna use the lookup fields
again this time to note which book the student wants to borrow so here I want
to choose the book title and along with the book title I want to know the author
as well and the available quantity of the book next I want to know the date on
which the book is going to be issued so I use the date field and name it as
issued date I’m gonna use the date field again and this one would be the return
date next I want to know the requested
quantity for this book so I’ll use the number field and rename it as requested
quantity next we want to know the status of the borrow request so we’ll use the
radio button and we’ll rename it as status the choices would be approved
rejected and pending now by default I want the status to be
pending so I click on this and then I hit done so we are done with our borrow
form if we access this application it will take us to our borrow book
form and now I want to create a new custom action button for the borrow so
I go back to edit this application and I want my button to appear in the books
report so I go to the books report and in the fields I want to create an action
which happens on the click offer record for a single record and I add a new item
now the menu display name would be borrow run this action for all records
let the workflow name borrow as well and then I want the execution to happen
for each record and write the workflow so I’ve created a new workflow and a new
action and now I want the action type to be a notification what I want our power
button to do is that I wanted to redirect it to the borrow form that we
have created so I redirected to a URL the type is form the form is borrow book
and open in the same window I hit save now I want a new action as well and this
one I want is to be a mail that will be triggered to the admin that a student
wants to borrow a book send email from the login user ID to the admin user ID
and the subject can be borrow a book now the message can be made with HTML
and I would like to say I want to borrow the book and hit insert and then we have the
insert field option here so I want to insert the field book title and then I
say now we have done two work flow so on the click of the button first it will
get redirected to the borrow book and then a mail would be triggered to admin
so now that we are done with the button updates the menu and now we want this
button to appear in our books report for that we go to fields click on this
layout and here this add fields here I want the borrow button to appear now
I’ll go to their live modes to see how our report looks like now with the fresh
button in it now that we know how to create workflows for the custom action
buttons the fourth feature is ready easy because we are going to build two
more custom action buttons but these are the approve and the reject button for
the admin to either reject or approve the borrow request so here here I have
the borrow button so when you’re sharing this app with the students now they can
see this borrow button so they click on this borrow and it would take them to
this borrow book form so you see now how things have been connecting first I made
the borrow book form and then I made the borrow button and now for demo I can
choose to borrow this book I listed one two that I put my dates I request the
quantity one and I hit submit submit at the form let me go to my mail and check
whether I got domain since I’m the admin and yes I got am in borrow book request
and it says Alice in Wonderland I want to borrow the book now I made some
mistake in the HTML the alignment so you can always customize the middle as per
your need and so we are done with the third feature that said create a custom
action for a borrow a book so that the students can easily raise a borrow
request for the books they want to create the approve and reject
custom actions we do it the same way we did it for the borrow request only this
time we are going to build it in the borrow book report instead of the books
reports so we go and create the same way we created the previous ones add new and this one would be called as approve
I want to run this action for selected records and this is because as soon as a
request has been approved or rejected it should not be active again so I want to
select the field status so as long as the status field equals pending this
approve button would be open as soon as the status gets approved or rejected
this button would not be active anymore now the workflow name would be approved
we create our workplace we add a new action and this time we are going to
create a custom action and create our own script so this brings us to the
deluge workspace where we will be coding with these daily tasks these are
pre-built blocks of code which we can drag and drop the same way we built our
form so it’s gonna be very interesting and let’s see what we want to code for
our approval button first I want the status of my borrower request to turn to
approved for that I simply type input dot status equals approved and next I want to
change the available quantity of our books so I want to minus the available
quantity by the requested quantity because once the request is approved I
will have to dole out the books to the students so my inventory will come down
how do I get to know what is the available quantity to know the available
quantity I’ll use the deluge task fetch records which will fetch the records
from another form for this purpose I can use a variable and that the variable
B book quantity the form would be books because that is
where we know the available quantity of particular books and the field would be
ID ID is a unique identifier by creator through which it differentiates between
the records the operand is equals and expression is input dot books
what this line does is this input dot books captures what the member has
selected as the resource and then it goes to the form and it looks through
all the records and the moments the ID of one record matches the ID of the book
that he has inputted it gets stored in the book quantity variable now once that
we know the variable which holds our particular record we would like to
manipulate it how would we do that we would take the variable book quantity
dot available quantity equals available quantity minus the requested quantity
input not requested quantity what this code
does is since we know the record which holds the available quantity now we want
to subtract that quantity by the requested quantity so that it reflects
the current available quantity now that we know the available quantity we would
like to know the member email so that we can send a mail to him about his request
so we will use the fetch records again to fetch the member emails and let this
variable be member email the form where it resides is the student
member form the field is ID equals input dot member that email but this line does is it goes
to the student member from it finds out those ideas which match our student
member in the current form and then it fetches their email once we know their
email now we can simply use the send mail task here to send the email to them
so From Zoho admin dot user ID to our member email and the subject can be
your request for the current book has been approved if you want a book name then just put
input dot books now the message can also be customized
let’s say I want to inform the return date in the message so let’s see your
return book date is input dot we have the return date here
as retained and now was saved save this workflow so you understand what we did
in this workflow was we change the status to approved we change the book
quantity to the current available quantity and then we sent a mail to the
student name remember about the return date now we save this workflow and had
done now we add this button in the layout just like we did for the borrow request so we go to the fields choose this layout and here we add the field so we
add our recently created approved button here let me save it now let’s create the
reject button the same way so we’ll go to actions will create a single line field
this one we’ll name as reject selected records status should equal pending and
then we name our work place create the workflow add new action the
custom action will create our new own custom script and this one would be very
similar to the approval one only that here we do not need to reduce the
quantity of our resources in the inventory we just need to recheck the
status so I’ll type input that status equal to rejected next I want to send a mail to the
members that their request has been rejected so to get done emails we will
use the fetch record once again let’s name it as member email
from the form student member field equals ID input dot member dot email
and then we use the segment ask from admin user ID
to member email subject should be the book you requested is unavailable the message can be please select the
resource after a few days so maybe we want to know the name of the
book so I put that books so what we have done here is we have
changed the status and then we have sent out a mail to the members that here book
is currently unavailable so we hit save now and then we hit done let’s add this
button the same we added for the reports we go to the report we go to the layout
and here we add the field newly created reject button and hit save now we will
go to access our application to see the buttons working in live so here is our
app running and as you can see our approve button and our reject button are
live so let’s just see what happens when we hit approve the requested quantity is
6 and these both have been frozen because they are no longer in pending so
the buttons are disabled it’s approved the quantity is 6 and we remember that
in the books report we have the available quantity now as 91 which was
100 so the students can still borrow them and in the borrowed book report
it’s showing 91 as well so now we will go to my mail and see whether I got any
mail as well and yes I got a mail that my request for the book has been
approved and my return book date is 9th February now my request for this book
has been a protest come in so many numbers because I have not put that
input dot books properly I guess so we can quickly edit the application and see
what’s wrong we go to our workflow so you see making corrections and creator
is really easy we go to macros where my approval is here and I think I made the
mistake here where I should have put instead of books input book start
book title so that instead of integer it also takes my title because books is a
collection here and in rejected I make the same mistake no reject is fine
so now that we got the mail the last fifth feature is that we are going to
have a schedule for notifying our members about the return date of the
book that they have forward let’s go to our first feature to create the schedule
I go to add new and I want to create a new workflow on a scheduled date now I
choose a date field from this option and the start date field resides in the
borrow book where the student member has asked for the return date now execute
the workflow on the above date at time let’s say the time is fine and repeat
the interval once now name my workflow as reminder and create work now it asked
me to add a new action the action is a custom action and this reminder workflow
is gonna be very similar to the previous one so I’ll be using the fetch record
quickly to get the emails let’s name it as what you mean
form is the student member from I’d equals input student member and now
that we know the males I’ll just use the send mail task from admin user ID
to fetch him in subject is return date reminder you have to return the book today and
maybe I want to add the name of the book as well input dot books that book title and then
we hit say now shield is saved we hit done and every time that we access our
application and create a borrow request by the student we will get a
notification for the reminder so we are done with the fifth feature now that we
are done with all the features and our app is ready I would like to take you
through the entire workflow once more so this is the form where we create our
resources we check them in this report we add our student members here we check
our memory code here and then when they try to request for a borrow from here it
takes them to the borrow request and then the admin can either accept approve
or we check the form now I want to tell you that creator 5 allows your app to be
available on mobile and tab as well so you can quickly see the mobile version
of your app that you can download from the app store again from Play Store so
this is how your app will look like your library app 2018 is here you can see the
forms you can see this is the report how the report will look like and this is
the entire interface of it you can also check out the tab how this the tab
version will look like and we have all the other features there now I will take
you to credits over comm where I will quickly take you through the library app
that was there in the app gallery and I promise to show you so we’ll go to new
application and it will quickly install the library app let’s find it out in the
sea of the apps here I’ll install it and here I had added eat Pray Love and here
you see that the interface is much more sophisticated because they put a lot of
effort into it they did a lot of coding and customizing which is very easy once
you get a hang of grater here is the resource tab where you can add the
resources so we have other categories publishers authors there are higher
requests there’s members there’s even the sophistication of having checked in
users so if you have physical library where the members come and read your
books you can have in and then you can check out your checked
in readers to readers history the admin panel where you have hired resources
renewal requests users like there’s so much in here you have publishers
languages I can go on and on about it but I want to in you to install this app
and check it out for yourself and even here you can see how the mobile app
looks like it looks very very sophisticated so this is how it looks
like in the mobile app so you can download the mobile app and use it on
the go I’m sure you’ll be feeling really accomplished if you have been through
this video with me and you could build your own library app as well if you
liked this video you could check out the other videos that I have made on other
custom business problems and also remember to Like and subscribe our
Channel if you have any comments or doubts regarding this app then just
comment below and I would reply to your right away until then keep making apps
and be happy Thanks

Only registered users can comment.

Leave a Reply

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