Send email notification when user importing the data from excel and duplicate records inserted

  • 0
  • 2
  • Question
  • Updated 2 years ago
  • In Progress
Hi All, In our recruitment tracker application , we have table for Applicants where we are import the data from excel. In excel we are getting the data from multiple sources and also getting duplicate applicants.

we need to import all of the applicants including duplicates but somehow want to send notification or high light those records in any report. 

I am aware of the option to have summary report using unique field to show duplicate records but its not fulfilling our requirement.

If it is not possible using native quickbase then could you please guide any approach using scripts ? IOL technique is already configured and also we are using other script to generate unique codes etc.

Thanks in advance !


Regards,
Rahul
Photo of Rahul Gangwar

Rahul Gangwar

  • 110 Points 100 badge 2x thumb

Posted 2 years ago

  • 0
  • 2
Photo of Matthew Neil

Matthew Neil

  • 31,698 Points 20k badge 2x thumb
To get what you are looking for it will require some coding to run, and possibly merge the duplicates if they exist.  Sending an email notification would be a result of the script 'flagging' the record as a duplicate.

There are no native solutions for this beyond reporting and a human looking at it, so if you need it automated, you will need a script.