Discussions

Expand all | Collapse all

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

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

    Posted 05-01-2017 14:45
    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


  • 2.  RE: Send email notification when user importing the data from excel and duplicate records inserted

    Top
    Contributor
    Posted 05-03-2017 05:26
    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.