Forum Discussion

RahulGangwar2's avatar
RahulGangwar2
Qrew Member
9 years ago

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

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

1 Reply

Sort By
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    9 years ago
    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.