Forum Discussion

JenniferJuhasz's avatar
JenniferJuhasz
Qrew Cadet
6 months ago

Count instances of value in table prior to date

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 a...
formula query
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 months ago

try this

var text QUERY =

"{99.EX.'" & [my email field] & "'}

& " AND "

& "{145.OBF.'" &[Date of Interaction]) & "'}";

Size(
GetFieldValues(
GetRecords($QUERY),3))

 

// change the 99 to the fid of your email field.

  • JenniferJuhasz's avatar
    JenniferJuhasz
    Qrew Cadet
    6 months ago

    Hi Mark,

    Thank you so much for this - it does contain syntax errors that I'm not sure how to resolve.  It is looking for a semi-colon at the end of the first statement, but then when added it says the & in line two is "expecting a number".

    145 = the fid of my email field; not quite sure how to work my way out of this one.

    Thank you though for your help!