Hi everyone,
I'm trying to find a way to create a field that counts the # of times an email address exists within a table based on a date field within that record.
Example: Record is created with an email address and a date of interaction. Goal - return the # of times that email address already exists in other records on or before the date of that interaction.
My formula query currently is: Size(GetRecords("{145.OBF.'" & [Date of Interaction] & "'}"))
Which DOES work, but it's counting huge numbers, and I don't understand why. The results are in the thousands, for an email address that if I search for it, only exists 21 times.
I *think* it's because my field 145 is also a formula query which reads - Trim(If([NEW Contact Email Address]="",[Contacts Table Field - Email Address],[NEW Contact Email Address]))
I'm wondering if it's not counting the results in the field, but query; however, when I switched the field to the field 'NEW Contact Email Address] I returned tens of thousands of records rather than the very few times a staff member manually entered it as a 'NEW' contact rather than looking up the email from our contacts table.
Ideas? and thank you!
