Send email notification with body consisting of old and new values to multiple fields on a form

[Rochel hans]

Hey All , @Chuck Tomasi @Ankur Bawiskar 

Need help with below task :

We have a table with a few fields and when ever these fields have data changing , we need to have those previous and current values sent to the respective record users to notify them about the change of values on those multiple fields but only with a single email at the end of the day . 

so basically it has to be a scheduled email, can you please help with achieving this requirement?

Regards

Rochel

[Ankur Bawiskar]

@Rochel hans 

unless your table is audited you won't know the previous value

[Rochel hans]

@Ankur Bawiskar : Hello Ankur , if the data is coming from an import source , is there a way we can get its previous value?

Regards

Rochel

[Ankur Bawiskar]

@Rochel hans 

you can know this from import set table provided it's not cleared since import set tables are usually cleaned up every 7 days

[Rochel hans]

@Ankur Bawiskar  : Hey Ankur , is there anyway Metrics definitions usage can help here?

Regards

Rochel