I am considering migrating a nonprofit site to EE. The existing site runs some news articles with an image and copyright attributions to the copyright holder.
- I created a channel called "Copyright Holders" with no fields other than the title.
- I created a channel called "News Articles" with a Channel Images field and added a Relationship field to the Copyright Holders channel.
The EE workflow for this seems really clunky. The content creator would first have to review the list of all copyright holders to make sure the one they are adding is not on the list. Then they would have to publish an entry in the Copyright Holders channel if there isn't already the right one. Then, finally, they can publish their entry in "News articles". At the end of it, if they mess up the first step we'll end up with duplicate entries in the dropdown.
If I were writing this as a PHP application it would be trivial to give the user an autocomplete field to enter the copyright holder. After the submit, if they entered an existing (enforced-unique) field from the MySQL table then reference it; if not then create it and reference it. This would be a simple and logical workflow for the content creator and would keep the data clean.
Is there some way to achieve the above in EE?
Or are my choices 1. live with the pain, or 2. write a custom CMS?