I am facing a persistent problem…
I work directly on glide editor:
I have an Events table, a User table, an Event_participant table.
I would like a user to be able to subscribe or unsubscribe from an event.
My user is on the event page. When registering, with the “Add row” action, it’s create a new row in my “Event_participant” sheet.
However I have a real problem to delete the line. In fact, the “delete row” action does not allow you to delete a row in other sheet of your page (here Events).
I tried to create relationships, but I notice that actions are possible with “one to …” relationships but not with “many to…” relationships.
In desperation, I thought to myself that I would create a column for each potential participant. It’s not very pretty, but in my case I could limit registrations to 20 people.
However, this solution gives me another problem:
I would like to retrieve the participant’s ID in the Event table in one of the columns Part_1, Part_2,…Part_20 depending on the first which will be empty.
Do you have an idea ?