Request for Assistance in Implementing "Approved By" Field Functionality

[sapyantuk]

Greetings, developers,
I have implemented a new field called "Status," which includes options for both "Reject" and "Approve." To enhance this functionality, I am looking to introduce another field named "Approved By." This "Approved By" field should function similarly to the "Created By" or "Modified By" fields. While multiple users will possess the authority to either approve or reject, I am specifically interested in capturing and recording the user responsible for approving a transaction.
My aim is to track and store the user who initiates the change of status to "Approve." Could you please guide me on how to achieve this?

[victor]

If you enable the Audited option in the settings of this field, any changes to it will be made to the Stream. Does this functionality suit you?

[sapyantuk]

victor, No i need to Save this in Field.

[rabii]

Hey sapyantuk

You can create a relationship on your entityDefs, you can add the code below to your entity:

{
    "fields": {
        "approvedBy": {
            "type": "link",
            "readOnly": true,
            "view": "views/fields/user",
            "fieldManagerParamList": []
        }
    },

    "links": {
        "approvedBy": {
            "type": "belongsTo",
            "entity": "User"
        }
    }
} 

Then you can use formula or Hooks to catch the person who changes the status field like below:

if (entity\isAttributeChanged('status') && status == 'Approved') {
    entity\setAttribute('approvedById', modifiedById);
    entity\setAttribute('approvedByName', modifiedByName);
}​ 

Hope this helps.