Case Study: Event Check-In App

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