Sorting by Category

johnny · 2021-02-01T07:08:56.247Z

Hey Bubblers,

Anyone have any ideas on how I can approach building something like Best Tech Jobs & Startup Jobs 2024 | Built In, where I can sort by a category?

image1158×385 51.4 KB

The way I thought about it was creating an RG of categories, but the issue is that there is sometimes subcategories

image1434×753 72.6 KB

rico.trevisan · 2021-02-01T08:14:17.871Z

johnny:

The way I thought about it was creating an RG of categories, but the issue is that there is sometimes subcategories

I would go the same route. The subcategories, how are they related to the main category? Certainly a database relationship, no?

So, I’m thinking:

1st RG with the categories.

Ensure your search term is sorted as you want (alphabetically?).
That RG is 6-columns wide (or as you see fit).
that RG has a group inside of it that is hidden
when the user clicks on a category, the hidden group is made visible, and

Inside that group, there’s a 2nd RG that is populated with a list of subcategories via a search also sorted alphabetically.

cmarchan · 2021-02-01T12:40:11.044Z

Hi @johnny

I think you are referring as to how to visually display the inputs so that they are dynamic.

If so … I am thinking a dB model like one needed for a dynamic form builder where if you need more inputs of different types (input, multi line inputs, date pickers, image uploaders, etc) to be added dynamically to a form you can do so.

Options set called “Category Type”
Display (text)

Input
Title (text)
Category (category type)

This way you can add different “inputs” which hold each of your true thing’s category which in turn holds different sub-categories itself.

Hope this makes sense … or at least that it sparks ideas

johnny · 2021-02-01T17:37:08.751Z

Thanks y’all for guidance! For the categories, do you think that option sets might be a good option rather than making a new type of categories? I’m trying think of which one is going to be better performance wise.

cmarchan · 2021-02-01T18:01:55.980Z

I usually prefer option sets although many folks prefer using data types when API actions are involved.

johnny · 2021-02-01T18:27:40.139Z

That’s good to hear, so I guess the decision I’m going to have to make is if I’m going to be releasing an API for the app I’m building.