@ThinhDinh’s suggestion should work here. Any time you need “at least” functionality, you should default to using a number schema. The helper table he describes to assign this number to the certification level will work well.
Thanks! Okay, so I want to make sure I am understanding this correctly so I can go implement.
By “helper” table, you mean just another table in Glide, yes? I am using Airtable so I would create another table of certification levels.
Then on the “Users” table, ad 2 additional “Lookup Fields” to the helper table. One is for the “User’s Certification Level” and the other is “Show my Profile to”. But instead of bringing back the name of the level, it returns the associated number.
Where does the query column go?
Also, this looks like it will only work with the logic of showing profiles greater than or equal to a certain level. As opposed to them just being able to select to show their profile to ONLY “Certified” or only to “Student” AND “Master”. Is that correct? I want to be able to communicate the caveats/limitations to the client.