Skip to main content

Using comparison values for filtering

L

I am new to Airtable, and am building a very simple database for a school to allow families to find the necessary books assigned to their students’ classes. I like the Gallery view for this, but when I set up a filter so that a parent can simply select the course from a drop-down menu, I am not given the option to select comparison values for that filter. The course names are controlled vocabulary, so I should be able to give the user an alpha list of courses to choose from.

If this doesn’t work, then there’s no point!

Thanks.

3 replies

Databaser
Forum|alt.badge.img+19
  • Databaser
  • Inspiring
  • 866 replies
  • January 16, 2021

Hi @Lori_Deibel and welcome to the community!

You are trying to use a single or multi select field as a filter I understand (?), but Airtable doesn’t work that way. Depending on how you are sharing the info (shared view link I guess?), people can filter the data themselves.

Not sure if I got your question right though :man_shrugging:

Jan - Databaser
L
  • Lori_Deibel
  • Author
  • New Participant
  • 1 reply
  • January 16, 2021
Databaser wrote:

Hi @Lori_Deibel and welcome to the community!

You are trying to use a single or multi select field as a filter I understand (?), but Airtable doesn’t work that way. Depending on how you are sharing the info (shared view link I guess?), people can filter the data themselves.

Not sure if I got your question right though :man_shrugging:


Thank you for your response! I am a librarian, so I am used to using controlled subjects to “force” filters. In the start-up documents I read online, I saw that when I’m setting up a filter, the third step is to select comparison values that will give my parents a pull-down menu of course names to select. That’s the only filter they will need. Is that possible?

Lori

Databaser
Forum|alt.badge.img+19
  • Databaser
  • Inspiring
  • 866 replies
  • January 16, 2021
Lori_Deibel wrote:

Thank you for your response! I am a librarian, so I am used to using controlled subjects to “force” filters. In the start-up documents I read online, I saw that when I’m setting up a filter, the third step is to select comparison values that will give my parents a pull-down menu of course names to select. That’s the only filter they will need. Is that possible?

Lori


I’m afraid it isn’t possible to limit the filter possibilities to just 1 filter.

Jan - Databaser

Reply


Most helpful members this week

Terms & Conditions