I am creating a booking system for our small advertising agency. We work with clients who book either single press insertions, groups of press insertions over weeks, months or a year - and also insertions which run continuously such as radio/online which would run from Date X to Date Y continuously.
Does anyone have experience or suggestions and be able to share the best way of approaching this?
The date entry is key as we bill by insertion date so I need to be able to easily search or create a report of all ads booked or running from one date selection to another.
I also need to log copy deadline dates so clients know when they have to submit their ads by.