@dharmel I gave your problem some thought. Here are a few ideas. This post is long.
Before reading any further, you might want to watch Glide’s two following tutorials:
Array columns
Multiple categories
How your organizers are to input their offering
- I would force them to input a min. age and a max. age, which would define their offering.
- They can input for instance “4” and “8”. You can make it pretty on the front end by confirming that they are offering “4 à 8 ans” (by using a template column in the Glide data editor)
- This is to guarantee that your data is clean and it will save a lot of headache with cleaning the data in GS. Some will write “De 4 à 8 ans”, others “4-8 ans”, others “4 - 8 ans”, some will write “14.5 ans”, other “14,5 ans”. This is a headache.
- Here is a screenshot:
- “Organizer”: user input
- Min age: user input
- Max age: user input
- Category offering: template column in the Glide data editor. You can display this to your users to make it user friendly. I did this in GS, but it is a better practice to do it in the Glide data editor. In GS, here is the formula I created in row 2: =B2&" à “&C2&” ans".
Categorize your organizers by age category
- I would suggest creating age categories: we can then display and filter on these categories.
- Let’s assume the ages of the children range from 1 to 18: you will then define 18 age categories, which you can call “Catégorie âge 1”, “Catégorie âge 2”, etc.
- You might want to avoid special characters such as é or â in your headers, let’s keep it safe.
- It is important that when you name your categories, the numbers start with 1 and go up 1 by 1.
- You can create these columns in your worksheet.
- Here is a screenshot:
- The values in columns E (“Age Category 1”) to V (“Age Category 18”) are populated automatically once the min. age and max. age are inputted by the organizer.
- The GS formula in E2 is: =sequence(1,C2-B2+1,B2,1).
- I do not know how to wrap the sequence() function inside an arrayformula() function.
- Edit: I don’t know how to pull sequence() down the column. Maybe someone else can help here. This part is important: this would then guarantee that each new organizer is automatically assigned to age categories. Maybe you do not need this to be done automatically in real-time.
Display the organizers and then filter by age category
- In the Glide data editor, in your organizers’ worksheet, create an array column of columns 1 through 18. You can call it “Age categories” (for instance).
- Here is the Glide tutorial on array columns, and here the Glide tutorial on multiple categories. Both are helpful to understand categorizing your organizers by age category.
- In the Glide layout editor, on your organizers tab, if you allow users to filter with the “in-app filter” feature, your users should now be able to select the ages they want to see and only the organizers that fit that age category will display.
You will probably need to continue to test layout options to find something you like. I have the feeling that creating age categories and fitting organizers within these age categories might now allow you to filter your organizers by age offering.