I have an auditTrail collection with the fields Date, Action and performedBy. The performedBy is linked with the users collection and I can fetch the auditTrail Collection using list view successfully. However, my challenge is that the permedBy field is showing the users document reference Id. I want the users field in the auditTrail collection to reference the Display Name field of the users document instead of the default document id.
I need your guidance Asap?