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.


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.