For capturing marketing activity, I have created a custom field using the Field Type: Select List (cascading) with two select lists of values.
The first is Partner and the second is event type which is often a date e.g. July 2018 Event.
The reason I have used a select list is so I can easily search and extract reports.
However, moving into the next FY I need to add additional values for new dates. I don't want to lose the previous data but also don't want the ridiculously long list of options as stakeholders will ignore or more room for error.
Could you please advise if there is a better way to do this?