In notification body how to fetch inserted, updated and ignored records while importing data in tabl

[aishwaryade3564]

I have imported data in 'Training' table now notification should trigger to the 'training_admin' role.

and notification body 

'

Hi Admins,

New trainings have been loaded into the instance. Please refer attached document for newly created trainings and here are the details of the load

Inserted Trainings Count:

Updated Trainings Count:

Ignored Trainings Count:

Total Count:

Thanks'

how to fetch this inserted training count, updated training count and ignored training count in notification body

[Mark Manders]

You will need to script to it. Trigger the notification with an event and script to the transform table.

Question is: why? What will this tell the training admin? It has no content, except a count. He will look at it and pick up the phone to call you and ask 'what was ignored? why was it ignored? what trainings were added?'. 

Wouldn't it be better to create a dashboard to show more data that is relevant? You can still trigger a notification to show the import is finished, but from a dashboard the information would be way more actionable.