Case Study: Event Check-In App
Updated: Sep 24, 2022
Questions about your Knack app? Let's Chat. https://www.knackbuilders.com​. Here is a case study of an app I built for a client: An event check-in app, where attendees self-check in to an event, and an attendance roll is created capturing demographic information. The Knack database is structured pretty simply, but it is quite a useful app. Please check it out this video.
Get a free Knack trial account here: https://www.knack.com/r/you-tube
If you are a fan of building great apps with Knack, please click the Subscribe button to join my channel, and ring the bell to receive notices on all my new instructional videos. Thanks!
You can check out my Knack database services here: Knack!
Full Transcript
dave parrish here again at
knack builders
sharing some uh experiences with uh the
knack app building platform
today's topic
it's gonna be a short case study
on an event check-in app i've done
several of these
they work really well and they're really
quite simple
um
i'll show you real quick
here's an interface when people are
coming to an event
they find themselves
and then check in and then it grabs
information about them i'll get into
that but i'll be right back and uh
and take you through how this works and
how it's built thanks
[Music]
okay uh let's roll we can jump into this
case study on a
event checking app here's how it works
in this particular case
people come to this event this is
a state-funded non-profit that does
safety training for the citizens of that
state and they put on a number of events
uh they need to track who's there and
they have to also track some
demographics of the people for reporting
to the state
uh when they're there there's a check-in
person
but typically the person who's checking
in is handed a
ipad or tablet and then they search for
themselves either by email
or
or their name and then people come up
and they select themselves
um
if they've already checked in for that
day
there's a process here where
uh but say yes you're checked in and
they're not able to select themselves so
they can't check in twice
and so these people are all in the
system they've been in there before if
they're not
they can
create themselves
and answer various information about
themselves
and then complete the registration and
through this process they're checked in
also
um
let's go back to that let's go find
dave
let's go here okay i select myself
and all they do is to sign in the event
here
says
check or it's a radio button it says
select
uh the reason it just says select while
i'm doing this today is because there is
not even an event today
if there was an event today
uh that event would show up and there's
a filter for this uh drop down or radio
button that says only show events that
are today so that prevents minimizes
people finding or picking the wrong
event
then they're checked in
and then a record of them or actually an
instance of them checking into an event
because they can check into more than
one event is captured it specifically
inserts a related record
and then for that event they have a
history of everyone who checked in it's
that simple
uh
let's take you how that's built
um
let's just go to schema
there's only four
uh objects in here one are the admin
people obviously they're gonna go in and
look at or create events create users
look at
the attendance and look at reporting
then there's the attendees obviously too
that can be
initially they were reimported
existing ones and then new ones
can be created by an admin or can be
self created at the check in at the
event itself
uh and then the data structure
is just this we have event obviously
that's gonna be a parent record
and we capture the name where it is
third time how many hours whatever
various various things about it
and then
a child record to that is
an instance of an attendee
attending an event
so it's just this is
captured every time it it looks at
the event the person checks in
and then information about them is
grabbed
uh from the attendee record
their current age
all their
demographics
uh
a number of different things but that's
how that works
um
and then in terms of how it's built
let's just go to
the event checking
the that's just rich text up top and
then this is a search function
one of these search
and it's a search
that is
when all we have is name and email then
it will result in this
and we have it result
in a table not a list uh let's see how
that works
input
and then it just shows some basic stuff
and then here's what happens when they
go find themselves
let's have this call up
there's a detail thing which is the
attendee and they do have the
opportunity to edit themselves and maybe
their email changed or something
um
and then
all we have is the event
and that's all they need to they don't
even have to actually have to select it
but it will only show events
right here's the filter event date is
today so it's gonna be pre-selected
and uh they just have to sign in
and when they sign in
here's how this works
let's go back to that we have rules
so record rules
first record rule is going to look at
that attendee that's what this is
and
uh
say they're yes they're checked in that
prevents them from checking in again
and then it's going to create a related
record
insert
a connected record into this attendance
line item which is the instance of them
attending someplace and it grabs all
their
specific stuff uh the event obviously
uh
age raised all the demographic stuff so
that's
captured in another record and in this
case by the way in this particular one
there's a rule in the state that they
can't have a name
attached to any demographic information
when you know any other reporting it's a
privacy issue uh so we do not capture
their name
and it's not available to see in any
other reporting and let's go to that
here's the admin side
um
here's a bunch of events
and accounts attendance and other stuff
but they can create a new event
date blah blah blah blah
and then it's there they can
look at an event
and see
people that attended
but it doesn't have demographics
with it or they can just look at the
demographics of it let's go to this one
just to show demographics but not
attached to any names and then
uh
sort of finish up here
then we have various reporting um
so don't worry about some of these uh
let's look at this one
so they can look at each event here's an
event and then see all the people that
showed up and it gives some summary
information
and then this thing here
i'm not sure what this acronym stands
for noms
um
let's have it populate
what this does is give them the ability
to look at certain dates
um and capture these information
demographic information that and then
they have to report this to the state on
some periodic basis maybe quarterly
uh and this before they were you know
very difficult spreadsheets counting up
calculations it was this right that type
of thing here they just have it they
select the range that they want they
have the information they actually can
copy it and uh
they make some other reports with this i
don't know that they use this particular
thing for it but this is the source of
the accurate data that's pretty much it
it's
pretty simple app a very simple app but
it's
very useful in fact
i said i think i've done four of these i
did the first one and then they told
someone else in another agency in the
same state and they said oh i want one
of that too and then all of a sudden i
did four others um that's the deal hope
that was helpful thanks