Forum Discussion

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

Qrew Legend

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

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!