AnsweredAssumed Answered

Searching for a match in previously submited records?

Question asked by david.bondy.metrolinx on Jul 11, 2017
Latest reply on Jul 12, 2017 by david.bondy.metrolinx

I'm looking to create a calculation that will search previous entries and populate the field with 'True' or 'False (or any similar feedback).

 

For example, if someone has previously submitted a survey with a SurveyID of '12345', when a new survey with the same SurveyID (i.e. 12345) in entered then the calculate field will identify that it already exists in the dataset and provide feedback accordingly.

 

I was looking at regular expressions that could suit my needs and it seems like match or search could do the trick but I can't figure out how to structure the formula so it works (although these functions might not be supported).

Outcomes