Interacting with small portions of a large form
Looking for ideas to approach this business need:
I have a form that holds customer project details, and I want different departments to edit/update different portions of the form. Sales updates customer requirements, Production updates parts purchases, Install updates employee assignments, etc. Right now I have Sales seeing everything and just scrolling thru and ignoring what they don't need. I have Production set up on a separate small form with lots of workflow to update changes made in the smaller Production form to the larger master form, and vice versa. It's time to add Install who will access on mobile and need to interact with their own fields within the sub-form. I'm really worried they are going to accidentally delete or overwrite data.
It all feels very clunky. I'm hoping there is a clean, easy solution that I'm just not aware of. Any suggestions welcome!