AnsweredAssumed Answered

Calculation per Portal Row

Question asked by craig157 on Jan 22, 2018
Latest reply on Feb 13, 2018 by jbrown

Hi All,

 

I've got some Company records that I am comparing to our current database (basically just for a deduping process).

 

All I am doing is a portal that looks up the postcode to match the new data which works fine.

 

I am using the below to find the number of matching characters.

Example:

New Data - Filemaker Community Limited

Old Data - Filemaker Ltd

cMatchedCharactCount = 10

 

Now the problem occurs in the portal, as it only calculates the result on the first portal record.

Is there something I can add so it calculates each portal result?

 

Some companies can have several other companies appear in my matching portal so would make the process quicker.

 

Thanks

Outcomes