How to display lists along the sections which the lists belongs to

Dear Users

I have a table of questionaries, and each questionary belongs to a section (e.g., Section 1, Section 2, etc.). Each section has 5 questions like 1.1, 1.2, 1.3, etc

I want to create a screen where users can see a list of Sections first, and when they click on a Section (for example, Section 1), it opens a new screen that displays only the questions related to that Section (e.g., 1.1, 1.2…).

What’s the best way to set this up in Glide?

1 Like

You should separate them into 2 tables - Sections and Questions

  • The Sections table should have two columns: RowID and Section name
  • The Questions table should have 3 columns: RowID, SectionID (RowID from Sections table), and Question
  • Then create a multiple relation column in your Sections table that matches the RowID with the Section ID column in your Questions table.
  • Finally, use that relation as the source of a Collection.

Learn more below:

2 Likes

Here’s some sample data to demonstrate Darren’s suggestion.

Sections Table

RowID Section Name
S001 Section 1
S002 Section 2
S003 Section 3

Questions Table

RowID SectionID Question Number Question
Q001 S001 1.1 What is X?
Q002 S001 1.2 How to Y?
Q003 S001 1.3 Explain Z
Q004 S002 2.1 Define A
Q005 S002 2.2 Describe B
Q006 S003 3.1 What is C?
Q007 S003 3.2 How to D?