record owner from parent-table
Posted: 2018-06-28 11:04
It would be very useful, if you could have an extra checkbox beside the "Inherit access permissions".
The meaning should be : if checked - then owner of the record is set to the owner of the parent-record and NOT the actual user.
Scenario :
You are a sports club ( or whatever club ). Could be a tennis club.
Each member is created as a user in the system.
Each member is created as a rcord in a parent table, and the member is set as owner of the record.
Then you could have one or more child-tables.
One table is a table with economic transactions. ( member fees, fees for tournaments and so, and then the payments from the member ).
It is the cashier for the club that makes all the transactions, and he should be able to make them without being forced to log in and out as the different member he need to make a transaction on.
The child table is set with the new option "Set owner from parent-table".
This means that the cashier can make transactions in the child table which he is allowed to edit, and only this table he have access to edit.
The member that is set to have view-access to own records can see only his own member record (parent-table ) AND he can also see the economic transaction in the child-table as the ownership is from the parent-table. But he should of course, not have access to edit the records in the child-table.
This way, a cashier can easily make transactions for all members.
The members can only see own records and only his own transactions ( even if he is not the creator - but he is anyway the owner. from parent-table )
I think this is a very common thing, but I have not found a way to make this.
I would therefore suggest, that all this could be solved just by clicking a checkbox, and then the system should set the owner of a child-record NOT as the logged-in-user BUT from the parent-record.
The meaning should be : if checked - then owner of the record is set to the owner of the parent-record and NOT the actual user.
Scenario :
You are a sports club ( or whatever club ). Could be a tennis club.
Each member is created as a user in the system.
Each member is created as a rcord in a parent table, and the member is set as owner of the record.
Then you could have one or more child-tables.
One table is a table with economic transactions. ( member fees, fees for tournaments and so, and then the payments from the member ).
It is the cashier for the club that makes all the transactions, and he should be able to make them without being forced to log in and out as the different member he need to make a transaction on.
The child table is set with the new option "Set owner from parent-table".
This means that the cashier can make transactions in the child table which he is allowed to edit, and only this table he have access to edit.
The member that is set to have view-access to own records can see only his own member record (parent-table ) AND he can also see the economic transaction in the child-table as the ownership is from the parent-table. But he should of course, not have access to edit the records in the child-table.
This way, a cashier can easily make transactions for all members.
The members can only see own records and only his own transactions ( even if he is not the creator - but he is anyway the owner. from parent-table )
I think this is a very common thing, but I have not found a way to make this.
I would therefore suggest, that all this could be solved just by clicking a checkbox, and then the system should set the owner of a child-record NOT as the logged-in-user BUT from the parent-record.