Assignment Tracker App | Building apps with Low code platform | Web Application

Assignment Tracker App | Building apps with Low code platform | Web Application


Hello everybody, this is Parveen and I
welcome you to the App DNA channel where we are obsessed about apps. Today I’ll be
talking to you how you can build your own custom Assignment Tracker app. Every
time I think of my student days I get nostalgic about everything but what I
get most nostalgic about is– Assignments! you remember the teachers used to come to
class and they used to hand out this hand printed assignments for us to
complete and then we used to have to submit them on a due date. Now I remember
I dreaded the assignment due date because if I was absent I could not
submit the assignments on time, but with time things have changed and we have
apps today where we can submit assignments online. Today I’ll be talking
about how we can build a simple assignment tracker app with a low code
platform like ZOHO CREATOR. Zoho Creator is a drag-and-drop
interface where you drag elements and you drop them to build your workflows
and to build quick app. Let’s see what are the essential features that we need
in our assignment tracker app today. Mapping out our app is very important to
know its workflow. This app should have five desired features. The first is that
it should hold all the student information for the teachers. The second
is that it should have forms through which the teacher can upload
their assignments and the students in turn can upload their submissions. The
third feature is that we should be able to share this app with the students so
that they can check out all their assignments and new submissions. The
fourth is that it should notify the students every time a new assignment is
created by the teacher so that they don’t miss out on any assignments and
the fifth is that we should be able to create separate reports for the students
and the teachers so that the students are not able to see other student
submissions and copy them out. Once we know these five features you get an idea
of how this app is going to work. First the teacher is going to upload the
student information. Then they are going to create new assignments. Once they
create the assignments the student will get a mail notification from them.
The student checks out the assignment, they know the due date to submit the
assignment and then the teacher gets all the reports and
this is how our app is going to work. Let’s go to creator.zoho.com where
I’ll be showing you how to make this app in a quick tutorial. Our first feature is
creating the student database and that we would be doing by creating a form for
our student information. Welcome to creator.zoho.com where
we’ll be building our assignment tracker app. On the right side you can see that
this is the button for creating a new application or if you have already been
using spreadsheets to manage your assignments and student information then
you can simply import those files with this button and an app will be created
for you. I’m gonna create one from new application and this is our app gallery
page where we have pre-made applications by our developers. We have an assignment
tracker app even here which we can simply install and start using but I
will show you that later after we are done with our quick tutorial. This is the
assignment tracker app, and I’m gonna create one from scratch to show you how
easy it is to make your own apps with our low code platform. Let’s name this app
as “Assignment tracker 2018”, and this is our workspace where we are
going to create a new form for capturing our Student Information. I want to create
a form from blank and I’m gonna name it as “Student Information”. Now this is the drag-and-drop interface
that I was talking about. We’ll be dragging the elements from here and
we’ll be creating our form. Now, what do I want to know about my students? I want to
identify my students with a unique ID so I’ll be using this number field here and
I’ll rename it as “Student ID”. Next I want to know their name and their email
address so I simply drag and drop them to fill my data fields. And then I want
to know the subjects that a particular student has opted for because this app
is being used for a class where the only differentiating factor for the
students about their assignments will be the subjects. For this I would use the
multi select field here and I’m gonna rename the choices with the subjects.
Let’s say that the subjects are maths, arts and science so I’m gonna rename
them and then I’m done with my first form. Now
I’m gonna use the “Access this application” button here to go to the
live mode of the app. The difference between the live mode and the edit mode
which is this mode is that in edit mode we are building the app but in the live mode we are checking out how our app looks when it runs. So this is our
student information form and I will fill the first student information which is
gonna be me so let’s say I’m the first ID. I input my name that’s my email and let’s say I am
interested in arts and submit. Now every time you submit a form in creator it
gets recorded in the report which gets automatically created so in the student
information report you can see all the student details so I’m the student ID
1 and here are my details. So we’re done the first step that is creating the
student database. The second feature is that we need two forms: one for uploading
the assignments by the teacher and the second for uploading submissions by the
student and both of this we’ll be doing by creating two forms just the way we
built the first student form. We go back to edit this application where we can
create the next form that is the “Create assignment form”. We click on the plus
button here and it asks us to create a new component and we’ll create it
exactly the same way we’ve built the student form.
I’ll name it as “Create assignments” and now I want to identify the
assignment with their IDs so I’ll click the number field and name
it as “assignment ID”. I want to know the name of the assignment so I used a
single line field and renamed it as “assignment title”. Then I want to know a
little bit of description that the teacher might want, any instructions that
she wants to give to the students so I’ll use the multi line field which
allows for more information than a single line and I will rename it as
“description”. Next I want to know the Issue date and the submission due date
so I’ll use the date fields and I rename the first one as the “issued date” and
this one will be the “submission due date” next I want to know the subject for
which this assignment has been created so I will use the multi select field and
rename the subjects Once we know the subjects then next I
would use the upload file feature with which the teacher can use any excel
sheets or PNG files or JPG files so they can upload the files with this file
upload feature and I hit done. So our “create assignments” form is done
and when we access this application, I’m taken to the form. Now I’ll create the
first assignment let’s say it’s ID is 1 and the title is “create an app with
Creator”, the description can be any business app. We put the issue date and
let’s say that submission due date 2nd Feb. The subject is Maths and then
we try to upload a file and then hit submit now. Every time we submit a form
in Creator it automatically gets recorded in a report, so this is the report.
Here I have my assignment ID 1, create an app with creator, our second create
assignment form is ready. Now we go back to edit this application and create the
second form that was the “submit assignment form” which will be used by
the students so we create this form the same way we created the other two forms
and I’m gonna name it as “submit assignment” form
and here I’m gonna use a new data field which is very important and it’s called
“lookup”. So what lookup does it is used to relate 2 forms so that I can fetch the
data residing in one form into this form without having to you know submit
the details all over again so I’m gonna use the create assignment form because I
want to relate the assignment details to this form and I’m gonna choose the
assignment title and hit done. I’m gonna rename it as just “assignment” and then
here we can choose what all fields we want to be displayed so along with the
assignment title I want to display the submission due date as well. Next I’m
gonna use the lookup field to know the student who is gonna be submitting using
this form so I use the student information form and the field is name
field and here I can choose to know only the first name and then the email so we
have used to look up to know the assignment and the student and now I’m
gonna use the file upload feature again so that the student can upload their
assignment and then I’m gonna use the multi-line fields so that the student
can put some notes to the teacher and I’m gonna rename it as notes so our
submit assignment form is also done so we access it and go to the live mode and
check how it looks here let’s see if the lookup works so when we click on the
assignment, see our lookup is working because we get the details here from the
assignment form. I select that and the student information it’s me and then I
upload a file again and I can put some notes thanks and I hit submit. Now in the
“submit assignment” report this data will also be captured, so here is my submitted
assignment so we are done with the 2nd feature now. Now that we are done with
all the three forms we have to share the app with the students so that they can
access the app as well. For sharing the app with the students we go back to “edit
this application” and then you see the green button here saying SHARE we click on
that and then it asks us whether we want to share the application with user or
customer or developer. Since the student is the user for our app, we are going to hit
there and then we are going to ‘custom permission’ because we want the
students to have separate kind of accesses than the teacher. So it asks us
– the module and the kind of access that we want to give to the student, so for
the “create assignment form” I want to give them access to only view records
because I don’t want them to edit or change the assignments that the teachers
are uploading, and then we don’t want to give them any access to the “student
information” because that is exclusively reserved for the teacher. For the “submit
assignment” form we are going to give them access and also we want to give
them access to the ‘submit assignment report. Now I’m going to name this
profile as a “student profile” and hit next. Now we can add users here
so every time you have a new student in the class you can share the app and add
the users here so let’s see my friend Akshay is a user now sure and I’m gonna
send him a mail saying that you are now a user of the assignment app and hit share. Now akshay.arsenal
should get a mail from me as I’m the admin so let’s see if he got the mail.
It says sharing done successfully so we will go to the next step where this is
the mail of Akshay opened here as you can see Akshay’s mail and here he got the
invitation from me, and it says you are now student of the assignment app. Now when
he clicks on go to application it will take him to the app where he will have
the requisite access that we have provided him. So here he does not have
access to the ‘Create Assignment’ form but he can see the reports and in ‘submit
assignment’ he can submit the assignment by using lookups and then in the report
he can see the assignments that have been submitted. The only catch here is that
he can still see the assignments that other students have submitted, like me so
we are going to reform that in the fourth step. For now we are done with the
third step, that is sharing the app. We are making way with our app. Now the fourth
feature is that we have to create a send mail task which will notify our students
every time our assignment is created for the subject that they have opted for. To create the send mail task we have to create a new workflow so we go to the
plus sign and here is the workflow I want to create this workflow while using
the form and I want it to happen every time a new assignment is created, so I
choose the create assignment form run when a record is created and I’ll name
the workflow as ‘send mail to students’ -add a new action and it asks me the action
types so I want it to be a custom action that happens every time I successfully
submit a form, so- on success and this is also a drag-and-drop builder for our
workflows where we will be dragging these blocks of code here which are
called deluge tasks to create our workflow. I’m gonna use this fetch
records here which essentially fetches the records that are residing in another
form so it needs a variable. Let this variable be anything like get subjects
of students the form is the student form because I
want to know the mail IDs of the students who have opted for this subject
in which the assignment is created so the field would be subjects=input.subjects What this line does is it knows the subject that has been created
for this assignment and then it goes to student information form and fetches all
the students who have opted for the subject. .email because it fetches
their emails and then I use the function getall()
which essentially gets all the emails which have opted for the subject of the
particular assignment in question. Next we are going to use the send mail task
here from zoho.adminuserid to: our variable getsubjects and now I’m
going to use the function tostring() because this collection is a comma
separated variable whereas I want it to be converted to string so that when the
mail is sent it gets sent to real mails rather than you know comma separated
values. The subject would be- students you have got a new assignment and the message could be anything you
can customize it- Hi Student, you have a new assignment for this subject what the input.subjects does is it just
replicates the subjects that the students have put on what assignment is
being created for. Our send mail task is done we just save it and then we go to
“access our application”. Our app is open here and we will have to create a new
assignment to check if the send mail task is working so let’s quickly create
an assignment let’s say the subject is arts and just
upload a file and hit submit. Now the subject is art so let’s check which all
students have arts as their subject so I go to the Student Information and okay I
have arts as my subject so let’s check my mail if I have got the sent mail say
yeah here is the mail. students you have got a new assignment. It came right now-
you have a new assignment for this subject arts, so as soon as I know that I
have a new assignment I can simply go to my app which would be shared to me and
then I can check out the assignments so the fourth feature is done. the last
segment of the app is the fifth feature and here we are going to create separate
forms for the student and the teacher so that the student can see only his
submissions and the teacher can see the submissions of all the students Now to
create our new reports we will go to this plus and create a new report. You
have created form and workflow till now now we’ll be creating a report I want to
create a list report based on the form of submit assignment and I’ll name my
report as “student’s submission” I’ll open builder and now it asks me to
add a criteria so we’ll add a criteria and the criteria is that when the
student email=zoho.loginuserid and I save it. What this
does it checks if the email field in the student submission report equals the
logged in user and then it will show only those records which match the
logged in user ID’s mail and done. Now this is submission report but the
report with all the assignments is named submit assignment report I’ll just
rename the report as “all assignments submissions” and I hit done. Now this
would take care of the problem that we were facing in the second feature that
Akshay was able to see all these students submissions now we go to Akshay’s
mail and see, let’s refresh and see what’s happening here. so this time when
he goes to submit assignment he can see submit assignments, when he goes to all
submissions he sees mine as well, that’s because I have not created a new profile
with him so I will go back to share and again I will change the student profile
here I’ll create a new custom profile and this time they will be able to view
the records of create assignment and they will be able to access submit
assignment they will be able to view the records of only students submission so
this is the change that would happen here and I will name the profile
“students customized” and I’ll again share the app
with Akshay- New app and share. Now let’s see if Akshay got the mail, yes he got
the mail and this says new app so now he will go to this application at this time
when he goes to student submissions he does not see anything because he has not
submitted anything to so let’s make Akshay submit for some assignment let’s
say he submitted an assignment for this test hit submit and this time when he goes to
the student submission he can see only his assignment so our 5th feature is done
because he doesn’t see all the other students assignments he can see only his
submissions so that takes care of the part of the students can’t cheat on
their assignments, now my fifth feature is done. Now that we are done with all
the five features I’d like to do a quick recap of this app right from the start
so that we know what all we have done here, so first we enter a student
information through the student information form and then we see the
report where the student information would be residing. We create an
assignment so this is what the teacher would be using to create an assignment
and they can check all the assignments residing in this report this report
would also be shared with the students through our sharing and they can check
all the assignments here the students will use this submit assignment form to
submit their assignments and while the students can check their submissions
through this student submission report where they can see only their
assignments the teacher will use this tab where they can see all these
submissions that has happened for all the students so we are creating forms we
are sending mail notifications and we are creating new reports as we’re
sharing the app with the students this is this app in nutshell now we will go
back to CREATOR.ZOHO.COM where i will show you the assignment tracker app that
we our developers have built in the app gallery. we got to new application and
then we have the assignment tracker app here so quickly install this application
and here you can see that it’s a much more sophisticated app here even the
form looks sophisticated there are a lot of assignment types you can add homework,
classwork. You can assign them to different faculties so while my app was
designed only for a single class here we have different faculties and then we
have allocations to students we have active assignments so here I had put
some data with Akshay in mind then you have all assignments you have separate
submission forms and you have separate student profiles where they can see
their assignments, my submissions and we have entire settings where we have
teachers, students, classes, subject assignment types, so I leave this
for you to install and check out what all you can do with this assignment
tracker app. Let us congratulate ourselves because we have just built a
custom assignment tracker app all by ourselves. If you like this video just
hit subscribe and like it and check out the other videos that I have made on
other custom business apps with CREATOR, and keep making apps till the next time

Danny Hutson

Leave a Reply

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