Hello, community! Would you suggest a design of collections for requests and check-ins. In my application, I have two collections: Users; Tournaments. Collection “Tournaments” contains data about a sport tournaments and have a property “Participants” as a relation to “Users” collection. Users …

Hi @Kostas , I would suggest introducing a 3rd “junction” table (collection) - let’s call it “Participants”. Fields in the table: Name (not really used, put something to identify the record here) Relationship to Users (one User can have many Participant records, but each Participant belongs to on…

Hi @Kostas , I have made revision here, [image] Need help creating a clock in/out time tracker Get Help Hi @chrisatyt , I made an example here, you can clone it to see what is inside. [compressed 2021-11-16 at 3.18.09 AM] It is now called check in/out. Maybe th…

Hi guys! Thank you all for answering. @Victor , you are precisely caught my question. Will do so. Would you please give a clue to which relations, except many-to-many more convenient. A player would have many tournaments and tournaments would have many players.

Hi @Kostas , Not sure that I understood your question :slight_smile: M2M relationships could be replaced by junction tables - which I’ve described. The reason to avoid M2M is speed - it takes more time for this relationships to be “processed” in Adalo apps, which leads to bad user experience due to …

A design of collections for requests and physical check-ins

Get Help Database

Yongki December 20, 2021, 9:54am 2

Hi @Kostas ,

I have made revision here,

It is now called check in/out.

Maybe this can be your reference.

Topic		Replies	Views
Event and user management, participant list Get Help	2	686	January 17, 2021
Sportscoaching/TrainingApp: Users in a group should see if other users have also registered for a race Get Help	3	50	July 12, 2025
Dual Registeration for App Database	6	395	May 8, 2022
Relational Database Collections Not Connecting to User Database	18	1120	May 2, 2021
Two Connected Collections in Adalo Database	4	578	July 5, 2022

A design of collections for requests and physical check-ins

Related topics