It really is a pain to check if a record is exists right now.
Each journey can have many waypoints and each waypoint can belong to many journeys. Point is I want to add data to that relationship, like date and time when the waypoint is reached. So I created a new table called ETA (Estimated time of Arrival). Each ETA belongs to a Journey and a Waypoint.
Now I want to get this ETA, simple right? On the journey page I have a list of waypoints. In that list I show a list. of ETAs. It should only show the ETA that belongs to this waypoint and this journey, so I said Show list of ETAs, Current Waypoint → ETAs. Great! Now I only have to make sure it shows the ETAs from this journey. So I should be able to simply add a filter and say where Current ETA → journey is equal to current journey.
You CANNOT do this, Why???
Now I have to manually create an ID for each record (while Adalo also creates an ID, which I cannot use…). I have to make sure it is unique and then check it. And making sure something is unique isn’t that simply either, you would say just get the count of rows and add 1, but what if a user deletes a row? Exactly, you will have multiple rows with the same ID!
I actually rather use many to many relationships because then I can simply say if x contains x then this. (Which for some reason doesn’t work if you want to use it for visibility rules, so I can’t use it for this purpose…)
Why isn’t that possible with a one to many relationship?
Please make this small feature happen, it will make everything so much easier!