I wanted to build a calendar of events, record when they happen and
where and cost and some details, and publish for people to see. I also
wanted to allow a small group to login and confirm their attendance,
and later on report on a short 5 lines on the event.
I thought it was trivial as I can make a table of events, a table of
people, and I can make a HBTM relationship, or even Has many through.
What is the issue now is that the event are only a few (20) that
repeat each month, at regular interval (like first thursday of the
month) with occasionally a shift date if there is a holiday.
suddenly, I don’t have a list of event, but conditions for an event to
happen on a given day, and I don’t know how to make a system for
people to confirm their participation, or even display the list.
The date is now part of the logic.
I thought maybe I should first use a system to create the next 20 days
of events by populating a list with the logic, and then get the people
to confirm their participation, not sure I am on the right track
anyone did this before? There is probably a simple answer but I can