Am a teacher and trying to build a app for my students to practice exam question for their National exam. Since am new to app tech and glide, am assited by Chat GPT. anyway GPT gave me 10 steps build my app but have problem following through. can anyone help by puting the correct Glide pictures to the respective steps. Thank you…
THE STEPS
STEP-BY-STEP: BUILDING THE APP IN GLIDE
Step 1: Upload Google Sheet to Glide
- Go to https://www.glideapps.com
- Click “New App”
- Choose “Google Sheets”
- Upload the
Grade12_Exam_Revision_App_Template.xlsx
to Google Drive and link it - Select “Users” sheet as the source for sign-in
Step 2: Enable User Sign-in
- Click “Settings” → Privacy
- Select: Public with Email
- Enable: User Profiles
- Choose the Users sheet as the User Profile sheet
- Map:
- Name → Full Name
- Email → Email
- Subscription → Subscription
- Subjects → Subjects Entitled
Step 3: Create the Home Page Layout
- In Glide, this is the main screen after login.
Display:
- Details layout → show:
- Student Full Name, School, Province (use text components)
- Inline List: “Subjects Entitled”
How to show subjects:
- Create a Relation column in the “Users” sheet that links
Subjects Entitled
to theSubject Name
inSubjects
sheet. - Use an Inline List from that relation (filter by user login).
Step 4: Subject Interface (on subject click)
When a student taps on a subject:
- Create a new screen showing:
- Filters: By Year, Unit, Topic, AI Generated
- Use Choice components (linked to the
Questions
sheet)
- Use Choice components (linked to the
- Filters: By Year, Unit, Topic, AI Generated
Below the filters:
- Add a “Start Quiz” button
- Action: Link to screen → Filter questions by subject + chosen year/unit/topic
- Show 30 questions one by one
Step 5: Question Interface (Quiz View)
You will create a custom quiz screen:
- Use a form or custom action flow to:
- Show question text
- 4 Multiple Choice options (A–D)
- Submit answer → store in
Responses
sheet - After 30 questions → show score + feedback
Step 6: Result Summary Screen
After the quiz:
- Create a screen that pulls:
- Number of Correct vs Incorrect
- Link to view answers + explanations
- Use:
- Bar Chart or Pie Chart from
Responses
andAnalytics
sheet - Show per-topic accuracy, if desired
- Bar Chart or Pie Chart from
Step 7: Offline Mode
- Use a tab or visibility rule to show
OfflineQuestions
sheet - Display a static list of 30 questions (answers only, no solution)
Step 8: Timed Quiz Mode
- Use Glide’s built-in Timer/Date columns:
- When quiz starts, capture start time
- On submit, capture end time
- Calculate duration in the
Responses
orAnalytics
sheet
- Show “Time Taken” on result screen
Step 9: Performance Dashboard
- Create a separate “Analytics” tab
- Use charts:
- Pie Chart: Correct vs Incorrect
- Bar Graph: Accuracy by topic
- Line Chart: Progress over time (group by timestamp)
Step 10: Subscription Control (Free vs Subscribed)
Use visibility rules:
- If
Subscription = Free
, limit:- Number of subjects
- Hide AI-generated option
- Lock full solutions
- If
Subscription = Subscribed
, unlock all