For now on, there’re a-only one-to-many, many-to-one and many-to-many relashionships. But I’d like to be able to create one-to-one relashionship. For exemple, a girl can date only one boy, and a boy can date only one girl.
I think you can do this function using true/false.
When Logged in user dates? matches someone, you add a update action to update Logged in User and its partner Date status True. And when logged in user’s date status is True, logged in user cannot date anyone(use sometimes visible or sometimes happens.)
And when they break up? unmatch, U update their date status false.
Kaito: maybe I don’t understand your solution, but what I meant was having the possibility to create a one-to-one relationship in a collection. In my new example (check out the picture attached), Adalo doesn’t allow me to say that 1 particular startup is related to 1 particular pitch. I don’t want a startup to have multiple pitchs, and I don’t want a pitch to have multiple startups.
But not only in a true/false way, I want - in the database - that : in my Startup collection I can access its one and only pitch, and in my Pitch collection I can access its one and only Startup.
Don’t know if my explanation is clear enough? ^^
Gabriel Schemoul: my solution is relate pitch and startup many to many. And when they have already matched with someone which means The number of match is greater than 1, you use sometimes visible or sometimes happens so user cannot match -anyone anymore till they unmatch.
Does it make sense ? I think that would work !
Totally agree!
Right now I have to do an ugly workaround…
So let’s say, collections “Startup” and “Pitch”.
In “Startup” I would have an “ID” property (or whatever could make it unique), and in “Pitch” I would have an “startupID” property kinda holding a reference to the specific “Startup” entry related to that pitch entry.
That’s kinda what we do with databases when using code.
But then comes the ugly part:
To pull the “Startup” data from the “Pitch” reference I have to use a list that shows only one item by mathcing the “startupID” from “Pitch” with the “ID” from “Startup”.
This is horrible!
EDIT: Oh, btw, it would be less horrible if we could at least use the actual “ID” property Adalo has in every collection behind the scenes