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? |