Hello !
My business would like a way for a Financial record to be analyzed (questions and text-box answers) by multiple users that can see each others analyses on
the same screen/record that they are performing the analysis on.
So far I have two ideas for doing so.
1. Have all the analysts work on the same record and let Salesforce tell the user that they can't edit it because someone else is editing it.
2. Have the analysts work on different records, and each time they save their analysis, have a trigger send that analysis to a separate field in all related analyses.
The first has the concurrency issue and the second solution sounds a little rough as we have a Reviewer that checks over all of the analyses and there'd be multiple places he could go to see everyone's work.
Does anyone have a better idea or improvements on mine ?
Thank you greatly for your time !
#Salesforce Developer #Apex #Data Management #Salesforce #Salesforce Admin
Both your options fight Salesforce's record locking — #1 hits it head-on (only one person can edit a record at a time, so the others get locked out or hit a 'record was modified' conflict), and #2 gets messy fast. The cleaner move is to not have them share one record's fields at all.
Model each analyst's work as its own child record — a related 'Analysis' object, one per analyst per Financial record. Everyone edits their own child, so there's zero lock contention, and you surface them all together on the parent (a related list, or a small LWC that lays the analyses side by side). Your Reviewer then sees everyone's work in one place and nobody blocks anyone.
If you truly need 'see each other's answers live as they type', Salesforce isn't real-time-collaborative like a Google Doc out of the box — you'd layer an LWC that refreshes (or push updates via Platform Events / Change Data Capture). But the child-record model gets you most of the way on save, without the locking headache.
If this helps, please mark it as the Best Answer so it helps the next person — thanks 🙂
