Looking for a solution to sort applications into two groups, new application and duplicated appplication

[Tsai_Cheng-Yo]

Hi everyone,

I am here to sincerely ask for your assistance.

I receive several applications from suppliers every day. Some are new, and some are duplicates.
To manage my suppliers, I want to create a supplier database and also a suspicious report that informs me of duplicates.

I used Make, Seatable, OpenRouter, JSON, and Router to build a scenario. The whole process looks fine, but I failed to establish a supplier database and also failed to generate a suspicious list consisting of duplicate applications.

My method to differentiate the two groups is whether their “supplier name” and “Bank Account Number” are the same. If the same, the supplier is categorized as “duplicate”, otherwise the supplier is categorized as “legitimate” and saved in the “supplier database”.

Here are my current module deployments,

• Seatable
  Getting new applications, recording application logs, aggregating legitimate suppliers, and aggregating suspicious suppliers.

• Router
  Setting up conditions to categorize the application into two groups, legitimate suppliers and duplicate suppliers. The method to differentiate the two groups is “supplier name” and “Bank Account Number”.

• My whole Make process to sort applications into two groups.
  

  

• Seatable, for collecting new applications
  

  

• Seatable, for aggregate applications history.

• Filter to sort out duplicate applications.
  

  

• Filter to sort out non-duplicate applications.

• Seatable, for aggregating duplicate history.

• Seatable, for aggregating legitimate suppliers, in this way, the table constitutes a supplier database.

• Supplier list
  

  
  
  Notes: There is one intentionally duplicate supplier, and the other two are legitimate suppliers.

• Application history
  

  
  
  Notes: It looks good so far.

• Suspicious supplier list
  

  
  
  Note: Something is wrong here. It is supposed to have a record about “Alpha Stationery LTD”, the duplicate supplier here.

• Suppliers database
  

  
  
  Note: Something is wrong here. It is supposed to have two records about “Alan” and “Sophie”, the legitimate supplier here.

Your Assistance Is Deeply Appreciated.

Alan Tsai