Looking for advice on a way to structure our base

Hi,
we have a seatable enterprise licence on premise.
here is our need.
Users are filling requests that have to be reviewed by internal experts.
A form helps this users to complete the request, then all experts are notified that a new entry has been added.
After that, experts have to look at the request and give their approval or not.
We are awaiting at least 3 different opinions to close a request.
Experts are also interacting together to challenge their ideas.

For now, we are using a rich-text cell that each expert completes.
That’s really not efficient because if one works no the cell, the other may loose their ongoing comment, and the experts that have no notification that a new comment has been added.

I struggle to find a proper way to make that efficient.
I’ve tried to add a second table with linked comments, but I can’t manage to make a working automation, that would be smooth.

Any idea would be gladly welcome !

I would use an app and make a comment field for each supervisor which is only shown to him. And than I would bring the supervisor comment fields together in one cell with a formular “Supervisor 1:” {supervisor comment1}, “Supervisor 2:”{Supervisor comment2} and on going

To clarify, among a pool of 10-12 experts, only 3-4 experts will reply, and not always the same.

Still I would do it like that, maybe with an if formula if not empty use the cell

1 Like

Thanks, I will give a try on that.

1 Like