Calendar prevent two entries at the same day

[Alina]

Hello!

Is there a way to not allow user to add the second event on the same day? I mean is there a way to allow user to add only one event per day via calendar add event action?

[MatthewS]

Sure, just need a condition on the action that only allows a new entry to be added, if an entry for that day doesn’t already exist. Use some sort of relation to check if the desired start date already has an event scheduled.

[Alina]

But relation to what? I only have a date stamp after the event is submitted via calendar

[ThinhDinh]

I think the complexity here lies in the fact that Glide might not be able to know which “date” you’re clicking in when using an inline action.

I would do it like this:

• Create an “Add” title bar action that links to a custom form.

How do I create a custom form?

I’m just dropping this here so I have something to refer people to when they ask. This is a simple concept app (copyable), that demonstrates the following techniques: Building custom forms for adding and editing list items (as an alternative to the native forms provided by Glide) Preventing duplicate new entries using User Specific Columns and Relations Enforcing mandatory input items The use of visibility conditions and user specific booleans to control user flow There is nothing particula…

• Create fields to store the event name, starting time and ending time.

• Create a query column to check it against your existing Events table, filter by user’s email/ID equals to the signed-in user’s email/ID, and starting time is within the same date as this row > starting time.

• If the query is not empty (meaning the user has booked for that date), don’t allow submitting a new event, else allow booking, via an add row action.

[Alina]

Thank you for your input!

Yes, you are right, this is the problem exactly.

So in other words it is not possible to do via the calendar interface.

Buttons is another thing, there are lots of possibilities, of course.