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

Ask for Help
1

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?

2

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:

3

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

Dear Darren_Murphy and ThinhDinh

Hope you are doing well.

Thank you for your advice.

As per your advice, I have revised the table and was able to resolve the issue through the ‘Things in Things’ video.
I appreciate your helpful response.

5

Great to have helped! I marked Darren’s comment as the solution.