- I have a content type called Office (field_office), which contains the regional office name (imported from LDAP, but that probably doesn't matter.)
- I have an entity reference user profile field called field_user_office that links to the Office content type.
- I created a content type called Blast Message with an entity reference field called field_office_sms which also links to the Office content type. When a user wants to create an SMS they create one of these nodes and select one or more offices to send to.
When I set up my rule I'm not seeing the fields exposed as I expected. I tried adding two Entity has field conditions, Parameter: Entity: [node], Field: field_office_sms and Parameter: Entity: [node], Field: field_mobile_phone, the last of which is the actual mobile number saved in the users' accounts.
How do I navigate from the original content (Blast Message) through the Offices, then to the specific Users who are linked to that office, and ultimately retrieve their mobile phone numbers?