Many-to-Many Relationships occur when each record in a collection relate to several other records in another collection, and vice versa.
Having too many relationship properties (especially many-to-many) on a single collection definitely degrades performance in Adalo, especially at scale.
A many-to-many relationship exists when records in one collection can be connected to multiple records in another collection, and vice versa.
One task can be assigned to multiple users AND One user can be assigned to multiple tasks
M-M Relationships can not be added on creation of new record in database.
M-M Relationships can not be set upon Create Action for new record.
Relationships are essential for organizing data in Adalo, but they come with performance trade-offs. Understanding the difference between direct relationships and junction collections allows you to make informed decisions about your data structure.
Use relationships for simple, one-to-many connections and small datasets
Use junction collections when possible for many-to-many relationships and before number of relationships to any single collection becomes an issue
Plan ahead: Choose your data structure with growth in mind
Last updated
Was this helpful?
Was this helpful?
