Let's say I have a custom record on a customer with a date field and I want to do the following on another custom field on it.
I want to automatically select a value from within a list with values which isn't used in any of the custom records on the specific customer with a date within the year of the date field.
Can I do that with the search module? Normally I would say let's use the query module but since it's beta I don't prefer to use it.