Asset status changed by email?

(Tim Trodd) #1

Hi,

 

I have an asset listing which displays all pages currently in safe edit mode and displays the name of the last person to change the status and how long ago the change was made.

 

I am trying to create a mailto function which will input the last person to change the status of the assets email address into the "to" field.

 

I have used %asset_status_changed_by_name% to bring back the name but I am not sure how to get the email address of said user? email is a required field when creating the users (created manually not by LDAP) and the field name is "email".

 

Thanks,

 

Tim

(Peter McLeod) #2

Hi

 

You could add a new metadata field to the assets to hold the email address (or a reference to the user),  and set a trigger to update it's value when ever a user changes the status to safe edit. 

 

Then in your listing access the metadata field of the asset to get the email. But you would have to update all asset that are in safe edit before you implement it.

 

Not sure if there is a simpler keyword modification you could use though?

 

Thanks

Peter