We are trying to use SharePoint for Quality Control / correction ticket system and we want to know if we can control column's user permission based on 'Status' of the ticket.
Here are our plan:
1. User creates ticket.
2. Upon submitting ticket, QA team gets notification from SharePoint, then QA team changes status of ticket to 'In Progress'
3. Once ticket status in 'Progress', end user can not edit certain column of ticket and can only view ticket.
We recently bought Column Protector from Datapolis. This allows us to control column access permission based on group or user. So we were able to block end user from entering / edit information on QA team's comment section. But now I guess what we like to do is, expand this column access feature.
Is there any tool or add on we can buy? If not, what would be the best way to go about this?