I’m still trying to wrap my head around the concept of Lists…
I have a use case where I need to replace individual members of a group (as the group has a fixed number of active users at one time), but I want to retain a historical record of each member of the group (effectively flag them as ‘previous’ or ‘ex-member’).
I thought I could do this with a list in the ‘Group’ data type but I can’t quite get my head around how I set the status of ex-members in a list. Lists don’t support multiple attribute values do they?
In a relational database, I would approach this with a join table that would have fields: Group - Member - Join Date - End Date, but in Bubble, how would I achieve this with a list? Any thoughts on different approaches?
Note: Individual members can be active in multiple groups
I am seeing this need for multiple attribute values on lists popping up frequently, so I’m looking forward to getting clear on Bubble’s method of handling data in these scenarios.