Hi everyone, would really appreciate if anyone could chip in with any ideas to the problem I’m currently facing, literally any idea you could think of will be of great help to stimulate myself to solve it as well. Details as below.
It is an event aggregator app, where each event can have one or multiple categories.
X event categorized as a Business event.
Y event categorized as a Data Science event.
Z event is categorized as both a Business and Data Science Event.
(Event data is inserted by admin directly into spreadsheet)
In this app, each user may select one or more preferred event categories.
User C prefers Data Science, Law and Mathematics categories.
(User preference data is collected via multiple choice component in Glide.
Hence raw data format is Category1,Category2,category3)
My goal for the main feature is to have a homepage where it has a list of events that are only within the preferred category of the currently logged-in user. (As long as the event has one category that matches the user’s selected preferred categories, it should be displayed to the user)
Unable to implement the filtering of events tailored to each user.
What we have tried:
Using the filtering option from list component, using “includes in”, but that seems to see if the
text includes another set of text. Hence “Science,Mathematics,Law” not considered to include “Science,Law”