I have 3 content types:
1. Client Fields: business name, description, contact name (all standard text fields)
Field collection (called 'client campaign'): Fields: Entity reference field to campaign content type - so I can select campaign to tie this client to.
2. Campaign Fields: Campaign brief, campaign duration, campaign budget, campaign monthly hours (all standard text fields)
Field collection (called 'collection publishers'): fields, publisher status (paid, live, dead, pending) [select list], publisher live date [pop up date], publisher payment amount [integer], Entity reference field to publisher field - so I can select publisher from drop down
Fields: website url, name, contact email, payment method (all standard text fields)
If I now:
1) add a client (create one client node) 2) add a campaign (create one campaign node)
I now can add publishers to my campaigns via the field collection added to this content type (collection publishers) This is set to unlimited to I can add as many as I want, in each one I can add in details for each publisher such as 'payment amount' 'live date' and all the other fields that are within this collection.
This all works fine but I need to be able to see all my publishers in one view with details of them and 'reverse' add them to a campaign all at once, perhaps via checkboxes. This will save loads of time. I tried an editable view but cannot seem to get this to work. I am not sure why. It is almost like I need to somehow write to the database without opening up the publisher node..
Was wondering it anyone out there can give me some pointers here or just tell me I am doing it all wrong! I don't mind which.
(the end goal here is to track publishers working across multiple campaigns and then I can see what's gong on at all times through views I'll create)
ADDED A SCREEN SHOT OF THE 'LOGIC' BEHIND THIS!
Thanks for any help in advance.
Screengrab 2 shows how the current campaign node edit form looks - the field collection is showing the publisher nodes.
Screengrab 3 shows how I would probably like this to look, an editable view of publishers that I can assign a campaign to then save. However, this may not work as publishers can work over many campaigns...