Calendar prevent two entries at the same day

[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.