The basic gist of what I am trying to do is look at the email (multiple value cck text field) fields in a an event content type that I am using to send emails.
I need to compare this emails to emails on the site so that I can reference emails that belong to site users and set a node reference on the user profile (regular profile, not profile2) to the event node. This way, I can build a view that will show the user which event he has been invited to.
I just can't seem to figure out how to extract (on node save) these email field values and compare them to site users and then change the users node reference field data to set the particular event node (just saved).
I have:
1. event Content type: event
has field: field_invitees (text field unlimited).
2. A user field: invited_event (node referencing pointing to event)
3. A rule that sends email on creation of event types (to the emails in the field_invitees). Noting that the email field can be for anyone (not just site members).
I need:
4. The rule to compare the emails it is sending out to site emails and set invited_event to the nid of the sending node (event).
Please forgive me for rambling. I'm not sure how clear I am being and I have been at this for a week and at wits end.
Thanks in advance guys.