Create a 'Check in by' DateTime field

Not sure if any other EB Users would like this feature?
We have events where we need people to be at our events and to be checked  in  say  30 minutes before or no later than 15 minutes after the EVENT START time.
We want to be able to put this field in the Booking Confirmation and Reminder emails we send out. It would also be nice to see this on the Booking Form.
So what we want is a field in the Event something like EVENT_CHECKIN_BY.
The easiest way would be for this DateTime Field to be added to the EB Events table where we could add that date and time when creating the event and carry it through to child events where applicable
The only way I see at the moment is  create a custom field in Date format and then use SQL to get the Event Start Date and calculate the Check in time by. ie Eventdatetime - 15 minutes.
Has anyone done this?
Would appreciate any advice on how this could be achieved
David
 

You can try to handle it using Event Custom Field eventbookingdoc.joomservices.com/basic-s.../event-custom-fields

The idea is creating a custom field to allow entering that date time, and then having it displayed in email using the syntax

[NAME_OF_FIELD_IN_UPPERCASE]

That should work for your need.

Tuan

Hi Tuan,
Using Event Custom fields would only work for a single event, but not for recuring events (Parent and Children)
e.g you have an event that starts on Jan 1, 2023 10:00 . You could put the checkin_by field with Jan 1, 2023 09:45 but if that events repeats say every month
ie
Feb 1, 2023 10:00
Mar 1, 2023 10:00
.
.
.
.
Dec 1, 2023, 10:00 
All these child events would still have checkin_by as Jan 1, 2023 09:45
The only way we can do this at the moment is to us 'Custom Fields'
eventbookingdoc.joomservices.com/basic-setup/custom-fields
Make the checkin_by field a SQL type field and use SQL to calculate the Check in time using the eb_events table and field event_date
i.e. checkin_by = event_date - 15mins
Is this correct?
David
 

No, the SQL field is only used to allow generating an dropdown contains list of options to allow users to choose from

It could not be used to calculate and set value for the field as you said. You would need to develop a plugin for that purpose, I'm afraid of

Tuan

Tuan,
Thanks for the explanation. I think I will go with the Event Custom field as you suggested with some text like ' Please arrive 30mins before the event start time'
Kind regards
David

Yes. That could be used as workaround for now !

Tuan