I am hoping to create a Property-based website which has two databases:
1. Database of Properties
2. Database of customers looking to buy a property
The database of Properties will contains information about property such as Property Age, Property Value, Number of Bedrooms etc
Each property will have its own node, and the information about the property will be stored as fields.
The database of customers contains details of the features specific customers would like in a property, with details such as: Desired Property Price, Desired number of bedrooms, Desired Location.
Each Customer will have its own node, and the information about their desires will be stored as fields.
I want to make it that if there is a match between the fields between both databases, an email is sent out.
Is it possible to do this form of textual comparison with rules?
I know that Rules has a textual comparison function, but it seems more geared to searching a field for a specific text string rather than checking that two fields match.
If it is not possible with Rules, are there any other modules that could help?
Thanks for any help that can be offered!
UPDATE: I have posted this as a job ad:
http://groups.drupal.org/node/88759
(I wasn't sure how to convert this existing post to a job ad. I hope it is not a problem)