Scenario
A teacher in a primary or 2ND school who want to have a tiny database system in order to manage his/her classroom via internet network and mobile application.
You need to have
Basic computer skill ,Ms Excel ,and internet skills
Computer PC orLaptop
MObile phone android or iOS
internet network or Mobile phone network
First step
Go to google Drive and select Google Sheet to make a table for keeping database information
Type the table name as Student Time In
Name the colunm as follow
- Student Name
- Photo
- Home address
- City
- Phone
- Class
- Date
- Time In
- Attend
- Reason
- Qrcode
- Student ID
Next Step
Go to Appsheet
Create New App and Name as Student Attend
Select Google as a resource database
On data menu click on column View
Look for the data type of each column as follow
- Student Name as Text
- Photo as image
- Home address as Text
- City as Text
- Phone as Text
- Class as ENUM**
- Date as Date
- Time In as Time
- Attend as YES/NO
- Reason as ENUM***
- QRcode as Image*
- Student ID as Text and Mark as Key UNIQUEID
** For Class as Enum
add new value for simple select as follow
Grade 1
Grade 2
Grade 7
Highe School
etc.
*** For Reason as Enum add new value to select as follow
Sick Leave
Personal Leave
Absent
Qrcode as Image*
add the url in order to generate the student Qrcode automatically as follow
"https://barcode.tec-it.com/barcode.ashx?data="&[MYID]&"&code=MobileQRCode&dpi=96&dataseparator="
Next Step
ON UX menu choose Form and Save
Next step
input some students as sample
Student A
Student B
Student C
