Ok thanks, will see if I can convince them to go EE. That would solve the issue I was having.
Regarding my first issue, I worked out a workaround which is OK-ish at least:
In the post I added a field “AssignTo”, foreign relation to admin users. Then in the model I added this hook:
async beforeUpdate(params, data) {
if (data.assignTo) {
if (data.assignTo !== data.created_by) {
data.created_by = data.assignTo;
}
delete data.assignTo;
}
},
That will make the row owned by the person selected in the assignTo drop-down. Slightly hacky since it’s changing created_by but that’s the only thing I found defines data ownership?